Hey all. I've done as much googling and forum perusing as I can and am still stuck on this. I'm trying to have Dropdown 2 values populated dynamically based on Dropdown 1 selected value.
Specifics:
User selects Type form Dropdown 1. Each Type has a Category field, which is a doc reference.
User selects Status from Dropdown 2. Each Status has a list of doc references to the Categories collection. (i.e. some Statuses should not be available for some Types, based on the Type's Category)
So for Dropdown 2 I'm trying to say "query the Statuses collection and filter out Stauses where Category array doesn't contain Dropdown 1's Type's Category". Has anyone figured out how to do this? Seems like it should be straightforward but I can't seem to reference Dropdown 1's Type's Category id or save it to a page state or anything...
Thanks for any help!