Solved: Hide add button for progress equal to 100% - Page 2

Gustavo_Eduardo · 02-06-2023 05:38 AM

Hello everyone.

I have a table with jobs.
When I touch a job it takes me to a progress filtered table, where each row is a progress record.

I need the add action of said table to be unavailable if the last record has progress equal to 100%

The problem is that the Behavior condition is not being executed at the row level as I thought but it is being executed at the Table level. @Steve ?

In this case the parent is Job and therefore, for all progress records that belong to the same job, there will be the same parent value.

I have first created a virtual column filtering all the records whose progress has reached 100%, this gives me only the RowIDs that meet this condition. Then by dereferencing I get the fields from Job.

Then I create another virtual column with a list of filtered Jobs called "FinishedJobs". They are all those records for which the add button should not be displayed.

NOT(IN([_THISROW].[Job],Progress[FinishedJobs]))

Is this possible? How do I do it?

Thank you.

Gustavo_Eduardo

I have to say thanks for the advice to @dbaum but I had to solve it myself and so, therefore, I take credit for the solution and share it for those who need it.

First I have created two Slices, one for those jobs that are completed and another for those that are not completed.

Then I've created a behavior action that sends to a view if the row touched is a finished job and sends to another view if it's an unfinished job.

Then I have limited the Add button to the "In progress" view only, leaving it invisible for the finished view.

I didn't need many more actions than what I name here and it works fine.

View solution in original post