Select to view content in your preferred language

Smart forms: Dynamic, user-generated dropdown, instead of using domains or subtypes

136
1
a week ago
Status: Open
AlfredBaldenweck
MVP Regular Contributor

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 1ORIG_IDField2
0Paris 
1London 
2Madrid 

 

Table 2FruitRELID
0PommeParis
1PoireParis
2CitronParis
3AppleLondon
4PearLondon
5ManzanaMadrid

 

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!

1 Comment
AlfredBaldenweck

Looks like this user is trying to do something similar in Experience Builder: Edit field adding a code and display 3 differnt de... - Esri Community