I am using a form where everything trigger off the first selection in the form. Now I have the choices pulling from a column in another table. I used select list and then added the table.column to provide the choices in the drop down. So far no problem. However I also want to add another secondary filter based on values in current table. So I am trying to limit the choices that show up first by the table column and second by the row. See attached example.
Thank you
Check these two posts:
Tips when using forms: Validation - Showcase / Tips and Hacks - Coda Maker Community
Tips when using forms: Style and filtering - Showcase - Coda Maker Community
Let me know if these links help.
Best regards
Arnhold
Thanks. I tried but failed. I think the use case is a bit different. I am trying to get the drop down list which is connected to a related table but then filter those choices further by another field in the same related table. Giving up for now since not yet a critical need.