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.
My questions:
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!
There is now!
https://www.appsheet.com/samples/community24713?appGuidString=d0823889-3df7-4028-8229-3ee28f6cd5a1
It depends entirely on what youโre trying to present. โInitial fieldโ suggests an input field, which does not seem to be what you were asking for in a sample app. If you mean something different than what youโve described previously, please explain further.
Generally, itโs better to use the sheet only to store data, and leave the work to the app itself.
Thanks Steve!
I did a lot of playing today and figured out most of what I was wanting to do. I came to many of the same conclusions you mention which is great (maybe Iโm actually getting it ;-). I noticed you used grouping and slices to solve the first part of my question which is exactly the two routes I was using. What I learned first and foremost for next time is to pay more attention to my underlying data source and make that as simple as possible before starting the app.
Thanks again!
Dan
Well done!
User | Count |
---|---|
44 | |
30 | |
24 | |
23 | |
13 |