Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Do a sequential lookup/calc from a csv list


JohnGG
 Share

Recommended Posts

This has been driving me nuts for 10 days. I tried. Here is what I want to achieve.

 

This shows the list of Zip codes and the Cities serviced filled out manually. A pain in the butt

Screen Shot 2017-02-12 at 4.29.36 pm.png

 

 

This shows the list of Zip codes and the Cities serviced not filled out, I want to do it programmatically.

Screen Shot 2017-02-12 at 4.29.57 pm.png

 

Any ideas or direction would be welcome.

 

I can do a lookup for one zip at a time but from a list..?

 

Cheers

 

JohnGG

Link to comment
Share on other sites

Assuming you have a table with a list of all zip codes and cities, all you need to do is change the CSV to a return-delimited list and create a multi valued relation between the two.

 

[/i]Set field [ sometable::CSV_zips ; Substitute ( sometable::CSV_zips ; ", " ; ¶ ) ]
Set Field [ sometable::serviced cities ; substitute ( list ( ziptable::Cities ) ; ¶ ; ", " )

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use