From this post
I'd like to be able to make text fields have a drop down dynamically, based on an arcade expression that the user defines themselves.
My use-case, given in the post linked above, is to grab values from a related record as an option.
So, if the relationship is something like:
Table 1 | ORIG_ID | Field2 |
0 | Paris | |
1 | London | |
2 | Madrid | |
Table 2 | Fruit | RELID |
0 | Pomme | Paris |
1 | Poire | Paris |
2 | Citron | Paris |
3 | Apple | London |
4 | Pear | London |
5 | Manzana | Madrid |
I'd like the dropdown for Field2 in the origin table to give me the options of Pomme, Poire, and Citron when I'm doing something in the record for Paris.
I specifically want to be able to do this using Arcade because my use case is actually more complicated: Parent Table has a 1:M relationship with Child1 and a 1:M relationship with Child2. I'd like to use values from Child1 in the dropdown of Child2.
Thanks!