Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

07-11-2008

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

Replies

Avatar

Avatar
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
gkaiseril
Level 7

07-11-2008

Look at the "Cancat()" function.

Avatar

08-11-2008

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