I am trying to create a Zap that communicates info from Submittable to Salesforce. Salesforce has very particular ways that country, city, and state codes need to be formatted otherwise it will not be inputted. Zapier support suggested I created a Vlookup table to convert the typed information from submitters to the specific codes. Does anyone have experience with this type of Zap? The vLookup table suggested seems like it would be a potentially huge project to try to create. I am not opposed to going back to Submittable and changing the way we accept information from Submitters to make this a smoother transition.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24296 replies
-
21 March 2022
Hi
Good question.
Here are 3 common ways to create a Lookup Table in Zaps:
- Formatter > Utilities > Lookup Table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
- GSheet - Lookup Row
- Airtable - Find Record
Thanks for your answer- I know how to make and use a Lookup table. I’m asking more here about alternatives. In this case, I would have to make a Lookup table that communicates short-answer information (with all common mispellings, capitalization, etc) to the codes for every possible state or region for the entire world. That seems like a frankly impossible task to undertake.
Userlevel 7
+14
- Certified Zapier Expert
- 24296 replies
-
22 March 2022
If possible, best to standardize and validate data collection as much as the start of the data flow to avoid having to handle unstructured data at the end of the data flow.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.