Template
Database
This will help Appsheet developers to find out how to read values for Valid_If, settings, references and using the app itself changing those values.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This is a simple app and the meaning of this is just to show one workaround how to use Valid_if values in your app and have all dropdown values in one GSheet. You don't need to change values with the Advanced editor. You can do it with the app itself!
The idea was this.. we wanted to clean the advanced editor, that we have only one table for dropdowns, refs and settings. We also added on UX where we can change those values with the app. All of this was possible with the SELECT formula in Valid_If. The formula is SELECT(TableName[ColumnName],NOT(ISBLANK([ColumnName]))). The formula means "Select all values from one column and where the cell is not empty".
If all values in this table are with the same format.. like text, you can try to transpose the whole tab in your GSheet and then editing in the app is perhaps easier to manage. Let's have a try:-)
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...