Expand my Community achievements bar.

Easy One Here....combining fields into one field

Avatar

Former Community Member
I would like to combine in one field the entries from six other fields



for example



WO# 89326

Customer Name Hardy

PO# 1234

Plant 2314

# of Designs 27

# of trusses 82



The combined filed would return



89326/hardy/1234/2314/27/82



I can easiy grab one field but adding is binding name as a calc field...how do i add more than one?



Thanks,

Patrick
2 Replies

Avatar

Level 7
Look at the "Cancat()" function.

Avatar

Former Community Member
Thanks Geo - that worked great...here is how i did it



Concat(plant,"/", customer,"/",Workordernum,"/",po,"/",num_design,"/",num_truss)



Any idea how i could hand off that string created as the subject of the email? Also, is it possible to have a "submit by email" button that just open and the and does NOT attach the xml.



thanks for your help...Patrick