AppSheet: How to show column forms on edit screen only

AppSheet AppSheet Q&A
1

imajenn2617_0-1686859364464.png
imajenn2617_0-1686859364464.png447×611 17.2 KB

There are two column identifiers that I do NOT need on the “Add” row/item data entry form, but I do need them to show up when I edit a row/item. I did found out how to not include them for both the Entry form and the Edit form, but is there a way to do only do one of them?

For background, we use this to enter all of our items that have not been picked up by a customer, but when adding an item Date Picked up and Picked Up by are irrelevant. However eventually the customer will pick up these items so I need to be able to edit the column and update that the items were picked up on a date and who picked them up.

What is the best way to do this?

2

Unter Verwendung folgender Ausdrücke in den entsprechenden Spaltentyp “ShowIf”:

  • ISBLANK({*}) Gibt zurück, wenn ein Ausdruck leer istTRUE
  • CONTAINS({text_1},{text_2}) gibt zurück, wenn enthält TRUEtext_1text_2
  • IN({*},{List}) Gibt true zurück, wenn sich ein Wert in einer Liste befindet
1 Like
3

You can check if the entry is a new one or edit with a formula IN([KeyColumn],TableName[KeyColumn]). If you use this with the Show_If, it won’t show those when you are adding a new row because the key value doesn’t exist yet in your table and result with that evaluation is FALSE.