[Vtigercrm-developers] Lookup table in Workflow?

[socialboostdk]

Hi everyone,

Hope you're enjoying some summer days ;)

I have a lot (approx 300) of variables that need to be changed (like "US"
to "United States", and many others) in a text field across many records as
they get added from an external source.

Any ideas on how to do this in a smart way?

I can't change it in the source unfortunately.

The only idea I've come up with so far is to make a.. *massive*.. if-else
structure in a workflow, which of course sounds terrible :-)

Thank you in advance for any pointers :)

Cheers,
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220804/d66226bc/attachment.html>