Dear members.
I am new with Appsheet, This is a great application.
My wife is doing different activities .
Here is an idea of the relevant table I set up
I made relevant UX
What she wants is have a direct view of the Pro tasks
I don’t succeed in filtering in TASK table with a condition in METIER table.
I guess this is a combination with virtual columns and/or slices.
Could you help ?
Charles (with my wife’s account)
Hello Charles, [i’m french too]
What is the final goal of filtering the table task ? having a desired list tof task assioted with the right métier ?
Does your wife create her project, task etc… inside the APP or its just for visualisation ?
Thank you Jérémie for you answer. I continue in english.
Final Goal : have the view on Pro Task at first galnce when starting the app : major goal
Yes she insert through the mobile app.
I see,
So for creating a new task, you have to fill a form right ?
Selecting the métier type
Then Selecting or creating the project [Unique ID Project]
And finally adding one or more task to the project [Unique ID Task]
So the Row condition expression of the Tache Slice should be :
For example, [_THISROW-2].[Phone] retrieves the value of the Phone column of the grandparent Table.
[_THISROW] => Goes up to the top level.
[_THISROW-1] => Goes up one level to the “Parent”.
[_THISROW-2] => Goes up two levels to the “Grandparent”.
[_THISROW-3] => Goes up three levels to the “Great Grandparent”.
[_THISROW-n] => Goes up n levels.
To reach your Grand parent table [Métier] its [_THISROW-2]
[Task Table Column] = [_THISROW-2].[Métier Table column]
Or
CONTAINS([_THISROW-2].[Métier Table column],“Pro”)
CONTAINS([_THISROW-2].[Métier Table column],“Perso”)
Tell me if this is helpfull, I’m not really an expert and don’t know your app structure and column
And i think you should read this too Dependent Dropdown
Regards
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |