Anyone using celigo integrator io? Can I map two ...
# generala
AK47
10/21/2021, 7:55 PMAnyone using celigo integrator io? Can I map two fields concatenated together? What's the syntax? field1 & field 2? or || or + ? && something else? lol Please help
AK47
10/21/2021, 8:30 PMOr maybe a way to use ISNULL so if one field is null, i can map another field
m
matt.graney
10/21/2021, 9:01 PMFor the mapping in question, select the gear icon, and set the field mapping type to multifield. Then you can set the expression to
Copy code
{{field1}}{{field2}}matt.graney
10/21/2021, 9:03 PMmatt.graney
10/21/2021, 9:05 PMFor your second question (re ISNULL) you can use the “if” handlebar function:
Copy code
{{#if field1}}{{field1}}{{else}}{{field2}}{{/if}}matt.graney
10/21/2021, 9:13 PMa
AK47
10/21/2021, 9:43 PMAwesome, thanks so much!
AK47
10/21/2021, 9:45 PM@matt.graney When you say field1, I need $record.fieldid with a $ prefix, right?
AK47
10/21/2021, 9:45 PMor just the field field
AK47
10/21/2021, 9:47 PM*id
m
matt.graney
10/22/2021, 12:56 AMyou don’t need the $. Check out the links I included.
matt.graney
10/22/2021, 12:57 AMthe mapper should autocomplete these fields for you
a
AK47
10/25/2021, 8:53 PMthanks @matt.graney I got this to work!
m
matt.graney
10/26/2021, 4:13 AMGreat! Congratulations, @AK47
3 Views