how does netsuite "formula (text)" concatenation w...
# generalj
Joseph
01/29/2019, 2:26 PMhow does netsuite "formula (text)" concatenation work?
why is my formula invalid?
concat('athq.com/search?brand=',{custitem_awa_custom_parent.custitem_awa_brand},'&type=',{custitem_awa_custom_parent.custitem_awa_type})
r
ryanhowson
01/29/2019, 2:44 PMYou can try using pipes e.g. {custitem_awa_custom_parent.custitem_awa_brand}||{custitem_awa_custom_parent.custitem_awa_type}
ryanhowson
01/29/2019, 2:49 PMI've used this for generating a URL (actual URL removed)
'<a href="url=' || SUBSTR({entityid},1,3) || '%23' || SUBSTR({entityid},5,5) || '&custrecord_nn_nps_contact='||{contact.custentity_nn_con_nps_id}||'">Text</a>'
j
Joseph
01/29/2019, 2:54 PMawesome! it works!