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?
Best answer by Troy Tessalone
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
+14You 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
+2Hey
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 |
+14If the key is Canada then the value is Ca?
Yes, left column is the lookup value, right column is the value to return.
+14Would 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.
