I noticed that in desktop mode fields with allowed values or ref values don't show correct value if it is set with "initial value" expression. In standard view the problem doesn't exist
I have been dealing with Desktop/Browser version of my app in the past few and have seen no issues.
Please:
Attn @Arthur_Rallu
Hi, thanks for reply. I integrate with some details. I have a field 16 char long (codice fiscale in the example), once the field is filled I compute 2 others fields with a formula like that (initial value):
IF(COUNT(SELECT(comuni[comune], [codice] = MID([codice fiscale],12,4)))>0,SELECT(comuni[comune], [codice] = MID([codice fiscale],12,4)),SELECT(paesi[paese], [codice] = MID([codice fiscale],12,4)))
these fields can be edited but have a list of allowed values because the field has this valid if expression:
SELECT(comuni[comune], TRUE) + SELECT(paesi[paese], TRUE)
In the desktop mode the field is not filled once the firs field is completed.
Thanks
Omar
Can you try to change formulas by removing the select clause?
Simply use
comuni[comune] and paesi[paese] respectively. Appsheet will automatically use unique values if list is given in the valid if expression.
Hi, unfortunately nothing changes after the change you suggested. I noticed the same behavior when in form you fill a ref field with a new entry: once you create the new entry and go back to initial form the field is not filled with the new entry. Always only in desktop view.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |