My table has 3 fields:
- One field is country selection - e.g. USA, EU, Canada..
- One field is product - e.g. table, chair, cabinet...
- One field is supplier - e.g. supplier A, supplier B, supplier C.
Does anyone know how to set rules/conditions in SAME field of airtable FORM INTERFACE at below scenarios?
- Scenario 1 - select USA and table, filtered option is supplier A
- Scenario 2 - select EU and table, filtered options are supplier B and supplier C
I am not familiar "add condition" or "add condition group" in form filtering. Pls. advise if you know how to do it.
Thank you.