Multiple value type appsheet

AppSheet AppSheet Q&A
1

Hi I’m devleoping an app in Appsheet and found one problem that would like to get help. There is a column that normally the value is date then I select type of data as date. By the way, there are an condition that I would like to put “N/A” as a value on the date. How can I do that?

2

I do not think you can. So either use a blank or a date that you would never use as a valid date (Ex. Jan 01, 1800) as a substitute for NA.

1 Like
3

Thanks, then it only by put “” as blank

4

Yes, a “” (two quotes with nothing in between) should do it.