map multiple variables to one field in the record producer

Alik_92
Tera Contributor

Hi everybody,

I have a question regarding mapping multiple variables to one field in the record producer. Only one variable can be mapped out of the box. Is there any workaround to achieve this with multiple variables?

 

Thanks in advance!

3 REPLIES 3

Danish Bhairag2
Tera Sage
Tera Sage

Hi @Alik_92 ,

 

You can use record producer script section & write the code in below manner:

 

Please use proper backend name of the fields

 

 

current.field1 = producer.field;
current.field2 = producer.field;
current.field3 = producer.field;
current.field4 = producer.field;

 

 

Thanks,

Danish

 

AnveshKumar M
Tera Sage
Tera Sage

Hi @Alik_92 

 

You can use record producer script to do this. For examples, if you have two variables which needs to be concatenated and assigned to a field in target record, you can use the following code.

 

current.short_description = producer.variable_1 + " " + producer.variable_2;

 

AnveshKumarM_0-1700486662609.png

 

 

Please let me know your exact variable types and target table  and field types if you want specific solution.

 

 

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Anvesh

Hi Anvesh,

 

Bildschirmfoto 2023-11-20 um 14.29.46.png

 

Starting with the variable "home address" to "your leasing contract" should have a "description" field.