Is there a way to create a dropdown picklist to control multiple tables?

Hi all! I have 2 tables, one table called Projects and another one called Resources. Both tables have “Role” column in them. Can I make a picklist that filters by role, both tables? I can do it with buttons and runactions but if I have 100 roles to filter through, I wouldn’t want to create 100 buttons. Rather, create 1 dropdown menu with all the options.

Thanks for all your help!

Can you share a doc with an explanation and the basics?

It is much easier to help in that case

Yes, you can. Just make a filter formula that filters based on the selectlist (or no filter if selectlist is blank).

1 Like

@joost_mineur let me try that, thank you!

OMG I didn’t think it was this easy. Thank you Joost!

@Piet_Strydom I got it now, thanks for helping!

1 Like

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