We have editable fields that are using Valid If formulas, but for some fields we cannot edit the field value and other we can edit.
Both fields (working, and non-working ones) are getting the valid list data from the same table, so it makes no sense they should behave differently.
Valid if formulas:
Dropdown Lists Static[Colour]
Dropdown Lists Static[Connectors]
They are both text fields, and the "Dropdown Lists Static" table fields are also text for both.
If we change the non-working field, to remove the "Valid If" formula and instead put it in "Suggested Values" - then it becomes an editable column again.
But we need to use "Valid If" and not "Suggested Values" so we can restrict the values the user can enter.
It appears to be yet another recent bug with Appsheet that does not make any sense (2 field, exact same setup, behaving differently). We have encountered a few other bugs recently, that are clearly Appsheet issues where formulas and fields with the exact same setup behave differently. Appsheet support is pretty painful to work with, as they constantly come back and ask you do to things that don't relate the actual issue. Anyone else having similar issues with Appsheet?
It was great for many years, but recent issues and lack of support really have me questioning my decision to both apps and systems with them.
LinkedIn
Twitter
