Hello!
I am trying to make an App in AppSheet for my small business. We offer chemistry shows with many experiments at schools. So my data structure is like this:
"Storage Units": This table storage all storage units (like materials, chemicals,...) that we have.
"Experiments": In this table, all experiments are stored. There is also a EnumList with references to "Storage
Units". So in this EnumList, all "Storage Units" I need to perform the experiment are stored.
"Packlist": In this table is for storage of packing lists with many experiments. In this table, there is also a virtual column (EnumList of references to "Storage Units"). In this column, every "Storage Unit" of the Experiments from the Packlist is stored. I did this with a formula, and it works great.
But now I want the user to be able to select one "Packlist" and all "Storage Units" from the EnumList should be displayed. I want the data to be displayed as a table view. I tried using a Dashboard with interactive mode but it does not work at all.
Whats the best way to solve my problem? So far this is the first problem i cannot solve at my own with AppSheet. Please feel free to ask me questions if my post in unclear.
Thank you so much for your help,
Pello1
LinkedIn
Twitter
