Button to filter a table

1

i have been searching for the solution for this but it seems all the answer are outdated and can’t fix my specific problem could someone help me in fixing it?

image
image1765×1248 171 KB

in the image there is 2 database one is db_action which will have task and it has priority select which is another database… so i have 2 problem …

  1. in the db_action table i have a button field which i want to cycle beterrn the priority dynamically … rightnow is works fine it goes 1,2,3,flow but if i added more priority it will not be added until i change the formula

  2. second in the priority table i want to have buttons which when i click them i filter the view of the db_action to fit the clicked button… i heard about interactive filtering but i don’t know where to do that

here is the link for an example coda :

2

There are many many ways to do this in Coda.

I added an additional column to your priority table called ‘FilterBy’. Pressing the button sets the current row as True and the rest as False.

In the main table I filtered the rows to be equal to the only priority where ‘FilterBy’ is True.

3

thats amazing its work perfectly, do you know how to solve the other problem? which i want the cycle button to cycle dynamically between the priority list

4

Sure, I had forgotten before. I added an index starting at 0 to your priority table. If a row on your main table has a priority with an index equal to the maximum, then the button makes it 0, otherwise currentPriority + 1.

5

thats amazing… thanks for very fast response… and i really appreciate your way of thinking . its so simple and amazing

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.