[Vtigercrm-developers] Lookup table in Workflow?

Tom Brown support at vtexperts.com
Thu Aug 4 22:02:44 GMT 2022


Chris,

What about a workflow with an "Update Field" task. I've attached a video
(watch with sound).

Expression:
if tt_source == 'US'  then 'United States' else
if tt_source == 'USA' then 'United States' else
if tt_source == 'CA'  then 'Canada' else
if tt_source == 'IT'  then 'Italy' else
if tt_source == 'ITA' then 'Italy'
else 'NA' end

Is that what you are looking for?

Thanks



On Thu, Aug 4, 2022 at 4:32 PM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
wrote:

> you could use time interval workflows with field update tasks.
> you could also create an installable module and execute some queries upon
> installation.
>
> Saludos
>
> Rubén
>
>
> On Thu, Aug 4, 2022 at 4:01 PM socialboostdk <socialboostdk at gmail.com>
> wrote:
>
>> 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
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220804/e24f7eb9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: UpdateFields_Expression_ifelseifelse.mp4
Type: video/mp4
Size: 2507985 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220804/e24f7eb9/attachment-0001.mp4>


More information about the vtigercrm-developers mailing list