Hi.
Whats the diference between Show_if and Editable_If?
Shouldnt show_if, show or not the field and Editable _if Show Allways the field by only make editable or not???
Both do the Same! if false the field disaperas in a formโฆ Wahts going on here???
Jorge
More than this, i have a filed marked as Required in Column definition, Shouldnt the filed be ALWAYS required dispite showing or not?
in appsheet Help : "An Editable_If constraint is a condition expression that indicates whether a specific column is โeditableโ in an input form "
Butโฆ it always disapears!
Iโve asked previously about a hidden Required column. AppSheetโs reasoning is that it makes no sense to require a column the user cannot affect, so Required is ignored in that case.
What are you trying to accomplish?
Hi Steve
sorry for the delay!!!
Im trying make a field noneditable when creating a new record. Based on the last sync timeโฆ kinda complicated. Im working on this with Alecksi.
But it seems we can only Warn the user. not block the Whole thingโฆ
Thanks a lot for the explanation!
Great help
cheers Jorge
@Jorge_Santos What youโre trying to do should certainly be possible.
A virtual column with an App formula of =now() will give you the last time the app synced. Virtual columns update automatically every time the app syncs.
It really works thanks to Aleksi helpโฆ
But i think it only works when you open a form. I cant make a related table disapear (show_if) only if the last sync has been less than 2 minutes agoโฆ
Cheers Jorge
im using this simple formula on editable_if: =Day(Now())<=day(โ4/28/2018โ)
Soโฆ this Editable_if only truely works if your EDITING a field not INSERTING oneโฆ Otherwise it just Hides the fieldโฆ
Anyone has experience with this?
Jorge
Show_If determines whether the column is user-visible at all, everywhere. If Show_If evaluates to false (N), the column will be hidden; if it evaluates to true (Y), the column will be visible. If Show_If evaluates to no value (blank), the column will only be displayed if the column value is non-blank.
Editable_If determines whether the column value is user-editable (this is not the same as read-only). If Editable_if evaluates to false and the column value is blank, the column will not be displayed in a form.
If you want to hide columns in forms but not elsewhere, use Editable_If, not Show_If
Note that a Valid_If field can cause confusion in a form! If Valid_If is used with a column constraint (a drop-down menu) and the columnโs value is invalid, Valid_If will blank the column value. If Editable_If or Show_If then hides the blank field, that invalid-now-blank column value will now be hidden and therefore not editable!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |