First I would like to express my appreciation for AppSheet Team, Appsheet is a fantastic solid data base platform were it can transform ideas to well structured application with ease.
I have a primary view which include fields connected to more than one tables’ columns. what I would like to do is to have one of the fields data to be filtered based on the user signing in. So please can I have a detailed instructions how this can be done?
As to clarify my question I will give the following example:
let’s assume I have a list text field named ABC in a primary view. that field is a reference from a related table named X.Table X has the following columns as attached
Now what I want to do is, when firstname.lastname@example.org will log in, the field ABC has to show 2 category rows (1) Hobbies and (2) Shopping and when user2@outlook will log in the field ABC has to show 3 category rows (1) Home Expenditures, (2) Vacation and Travel and(3) bills and Utilities.
I am open for any scenarios, any suggestions?
Thanks in advance.