The expression in question is exactly what I want to happen; Select values from [Company/Opp] column within the (Top Opps ALL) table when the user email matches the text in the [Rep] column… however nothing shows in the dropdown.
Is ‘Suggested Values’ the correct place to enter this formula?
I’m really baffled on how to do this - it’s the last step in my app
Hi @xavier7lemon,
One thing you may wish to try is, if removing quotes in “USEREMAIL()” in the expression helps.
So please have expression as … =USEREMAIL() instead of …=“USEREMAIL()”
I got the values to show up by using your suggestion above however I am now getting this error:
Any suggestions on how to record the users selections?
Hi @xavier7lemon
It sounds that you have defined the field “Opportunity 1” as Enum type and the value"Project Shield- Presbyterian deal" is not one of those valid Enum values. Is the expression for the field "Opportunity 1"trying to populate that invalid value into the field?
A quick hack of a solution would be to turn on the switch that allows new values in the enum.
The expression for ‘Opportunity 1’ is suggesting starting values of the dropdown list from a column in another table.
What I’d like to have happen is a user selects one of those values in the dropdown and the selection is recorded on another sheet. This was working until I added the expression to suggest starting values.
That worked. I must’ve accidentally turned that switch off. The other Enums have that switch on and are working fine. Thanks a ton @MultiTech_Visions @Suvrutt_Gurjar !
Looking forward to deploying this app as my companies MVP.
