I have a few calculated fields that I use for...

(Don Caruana) #1

I have a few calculated fields that I use for things like displaying the text date. On the detail view, these keep showing up in the app.

So - a couple of questions…1) Can I have a different view (detail? form?) for adding a record vs editing one? Also, is there a naming convention or something used to determine which view it opens anyway? I don’t seem to be able to hide those columns no matter what on the actual app.

(Aleksi Alkio) #2

You can read the the status “adding or editing” with an expression IN([KeyColumn],TableName[KeyColumn]). If it’s true, the record already exists and you are editing an existing record.

(Don Caruana) #3

Thank you! That worked well to clean up my input form!! I was looking around though and couldn’t find that “IN” function. Where is that referenced (in case there are some other gems I might use there!)?

(Aleksi Alkio) #4

help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com