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. 

[1minManager]

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. 

Within the ENUM settings you can Choose Phone as the type

[1minManager]

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]))

My hunch is that this bit [Law Firm Name] = [_THISROW].[Law Firm Name] is causing only one matching record to be returned.  Try this instead as a test

SELECT(Partners[Law Firm Address],TRUE)

Which should pull in them all

Simon, 1minManager.com 

[jgiangra]

Hi - thank you for the reply! I tried the expression and it returned all addresses, not just those that match the selected law firm.

The expression I'm using reads like exactly what I'm trying to do and it actually is working for a field in another table. I have a Deals table and a Partners table. When I use this formula on law firm address for entering a new deal (deal table), it pulls back only addresses in the dataset that match the selected law firm.; however, when I use this formula when entering a new Partner (partners table), its only pulling the first matching address for the select law firm. I think [This row] is meant to be used when referencing another table but I don't know how else to do it when referencing the same table.

[jgiangra · Accepted solution]

@1minManager I fixed it. I had law firm as the key in the partners table but when I changed the key to another filed, it started working with my original expression.