Hi All,
New to Zapier and I am trying to figure out how I can convert values within the workflow?
So for instance, I want to change the value “Canada” on the Country field that I received from Wordpress and convert it to “Ca”?
Does anyone know how to do this?
You can use a Formatter step: https://zapier.com/help/doc/how-use-formatter-functions
Specifically try the Lookup Table option: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table
Hey
You can use “Code by Zapier” as well, there you can put your JS logic for this.
If the key is Canada then the value is Ca?
One last question; Would this work if the record being passed from Wordpress looked like this?
The lookup table would then convert the Country value to “Ca” and the workflow would push it to Salesforce.
| ID | Name | Country | City |
| 1 | Sean | Canada | Vancouver |
If the key is Canada then the value is Ca?
Yes, left column is the lookup value, right column is the value to return.
Would this work if the record being passed from WordPress looked like this?
You’d have to map the Country value from the data points returned from the trigger to the Formatter Lookup Table step, then map the desired fields to the Salesforce step.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.