Slice table "Tache" with conditions applying to related table

Dear members.
I am new with Appsheet, This is a great application.

My wife is doing different activities .

  • personal : Running the house, Renting Appartments, Musical association, โ€ฆ
  • professional : Employed, her own business, business associations
    She wants a TODO application.

Here is an idea of the relevant table I set up

  • METIER (MetierName, Pro-Perso)
  • PROJECT (ProjectName, byref MetierName)
  • TASK (TaskName, DueDate, Priority, Finish, byref ProjectName)

I made relevant UX

  • PieChart of unfinished tasks by priority
  • List grouped by DueDate of unfinished tasks

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)

0 3 294
3 REPLIES 3

Cortex
Participant IV

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

Top Labels in this Space