Populate Enum values for a field based on previous selection in form

[jgiangra]

Hi! I'm trying to pull a list of valid enum values for a certain field on a form. I used the formula from the support article mentioned below but its only pulling the first matching value and not a list of all matching values. Where did I go wrong? 🙂

The first question in my form is Law Firm Name, Enum. I then want to user to get a list of valid Law Firm Addresses based on the Law Firm name selected (& also let the user enter a new address). Law Firm Address is Enum field type with allow other values selected.

Valid IF Formula: SELECT(Partners[Law Firm Address], ([Law Firm Name] = [_THISROW].[Law Firm Name]))

https://support.google.com/appsheet/answer/10108207?hl=en

Follow up: I'm doing the same thing with the next field, Law Firm Phone. I want the actions on a deck view for calling/texting the law firm. If I make this field an Enum, for purposes of the form, then the automatic actions on the deck view go away since its no longer field type address and phone.