Total rookie so apologies if I’m missing something easy…
I have a simple sheet with 15 columns.
I’d like the opening view of my app to simply display the unique values of ‘column3’ as choices. Choosing any of the values would then open into a view where all rows matching ‘column3’ would show ‘column2’ from each record (not distinct). Finally choosing any of those records would then open up and show all the remaining fields of the record chosen.
Is there a good sample app that shows such a structure (I couldn’t find one).
Is there a recommended way to show distinct values in the initial field? I’ve tried expressions, view options, etc. but I’m just not seeing it in the UI.
Should I do most of the work in the Sheet instead? It’d be easy enough to create additional sheets with Select statements to isolate the records, but that seems like it’d be done more elegantly in the app.
Thanks for any help!