I need some help. I am building a workflow. In the email section “to” I am trying to send the user the information based on my ‘column’ named ‘location’ that said this is how I set it up:
SWITCH([location], “sample1”,"email@email.com", “Sample2”,"email@email.com")
It shows the data as being valid, but it does not work is there something I am doing wrong? I did make sure to note “all changes”
I tried the following experiment and it worked.
I defined a field called “Name” of type “Name”
I entered the following expression in the “Send to” field of my email workflow rule. SWITCH([Name], “Bill”, "bill@gmail.com", “Nat”, "nat@gmail.com",“David”,"david@gmail.com","unknown@gmail.com")
I made a change that triggered the email workflow rule.
The “Send to” field was populated properly.
I am not sure why your expression fails.
At least you should fix your SWITCH formula first. The else part is missing.
I am a bit lost. When you say “else part”?
Check this one… help.appsheet.com - Conditional Expressions Conditional Expressions help.appsheet.com
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |