Drop down filter in Action button items

Hi everyone,
I tried to find an answer in previous posts,
but I couldn’t find it.
I have 3 tables in Airtable, Owners, Units and Work orders.
Tables are linked (Owners - Units, and WO with Owners and Units).
(The Owner IS NOT the person Adding or Editing WO)
In List block, on Add record button, I am trying to set
=) when an Owner is selected, then in Units only her/his Units are shown


I tried with

but I couldn’t solve it.
Is it even possible??
This functionality is very important for my app
Thank you very much

@Jjenglert can you please help? thx

Hi there,

I’m not sure I have enough context to be helpful. But maybe I can suggest ways for you to think about solving this problem in a different way?

After the add record action, I would look to use either user permissions or conditional record filtering to then filter the result of the action to account for the owner visibility.

So it may be less about adjusting the way you have the data structured at this point, and more about conditionally showing the value of the action based on the loggedin user.

I hope this can help you?

1 Like

thank you :slightly_smiling_face:

1 Like