Hi. I am trying to insert an If Else statemen...

(PDM Business Support) #1

Hi. I am trying to insert an If Else statement on a field but I can’t seem to get the syntax right. What is the correct syntax for “If field is empty or has no value?”

(Reza Raoofi) #2

Have you tried IF(ISBLANK(…) , … , …)? If you already knew about it, please explain more details about the problem. help.appsheet.com - IF() IF() help.appsheet.com

(PDM Business Support) #3

Hi Reza. Thanks for that. I have a Yes/No field called recheck. It as an initial value of FALSE but on my edit screen if the [Checker] field is updated with an entry I want the Recheck field to revert to TRUE. Hope this make sense.

(Levent KULAÇOĞLU) #4

@PDM_Business_Support

You can use UNIQUEID() expression in the Initial Value which is a text type, RFC 4122 compliant GUID

(Reza Raoofi) #5

Yes, it can; have you tried UNIQUEID() function? For more details about Key I recommend reading these articles: https://intercom.help/appsheet/data/keys/what-is-a-key

https://intercom.help/appsheet/data/keys/manually-generating-uniqueid-key-values

(Levent KULAÇOĞLU) #6

@RezaRaoofi it’s UNIQUEID() bud😉

(PDM Business Support) #7

Great thanks guys. @Reza I am getting a ‘ISBLANK function is used incorrectly’ error when I tried your suggestion on the recheck field.

(Reza Raoofi) #8

Oops, sorry, I did not see your comment! Corrected it now, even though you had already mentioned the same thing! :wink:

(Levent KULAÇOĞLU) #9

@PDM_Business_Support

@RezaRaoofi is a speedy typer, he had forgotten to close the paranthesis.

IF(ISBLANK([Checker]), false, true)

(Reza Raoofi) #10

@PDM_Business_Support sorry, I forgot to close the parenthesis. Well, @Levent_KULACOGLU corrected me! I also corrected it in my previous comment, so it wouldn’t mislead others in the future.

(PDM Business Support) #11

Guys thanks a million. You are a great help.

(Reza Raoofi) #12

@PDM_Business_Support You are welcome! Thanks to Levent that corrected my typos! :slight_smile:

(Levent KULAÇOĞLU) #13

@RezaRaoofi call me Speedy Gonzales bud :slight_smile:

(Levent KULAÇOĞLU) #14

@PDM_Business_Support

For your [Recheck] column, you have to turn on Reset on every edit property. Initial values are only computed during a new entry, they are not re-computed on editing an existing record.

(Reza Raoofi) #15

Do you mean you need the Initial Value for [recheck] column needs to be conditional based on [Checker] column’s value, and if [Checker]'s value is not blank it should be TRUE, otherwise remain FALSE?

(PDM Business Support) #16

Exactly

(Reza Raoofi) #17

Then you need to enter an expression like this in [Recheck]'s Initial Value: IF(ISBLANK([Checker]), false, true))

Then as Levent mentioned, if you need this to also happen on every consequent edit in the future, you could switch Reset on every edit property ON.

(PDM Business Support) #18

Thanks Reza. On a separate point, if I have a google spreadsheet, with Timestamp as the Key field, being updated through the app from multiple tablets, could there be an issue with saving if 2 records are stored at the exact same time to the second?

(Reza Raoofi) #19

Yes, it might be rare, but theoretically it is not impossible, and could cause duplicate key.

(Levent KULAÇOĞLU) #20

@PDM_Business_Support

That’s rare but possible unfortunately. It will be better if you use a unique id as a key column value