Good Evening,
I'm building an app for my mom, but am having issues with the groceries section.
In the "Cart_Details_Inline" view I want the groceries to be sorted by category as they are in the "Groceries" view. I've used a virtual column in the "Cart_Details" table to reference the Category column in the "Groceries" table. Problem is, instead of categorizing by that column it is listing every category in the app. How do I fix this?
Thank you!
@Kat wrote:
I've used a virtual column in the "Cart_Details" table to reference the Category column in the "Groceries" table.
The App formula for that virtual column adds to every row a list of all the categories.
Instead, you presumably want only the category applicable to each row. Change the virtual column's App formula expression to a Dereference expressions - AppSheet Help. For example:
[RefColumn].[Category]
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |