function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
manav_mnvmanav_mnv 

Concatenate Text and Auto number field

Hi All

I want to concatenate Text field with my auto number field, scenario is:

I have one Text(9) field- Tour Reference(Flagged as External ID)
                 Autonumber- Order ID
I want to create Order Reference field(formula field) which concatenate Tour Reference + Order ID.

How to achieve this. Please suggest

Thanks
Manav
NagaNaga (Salesforce Developers) 
Hi Manav,

You will have to first create your "Auto number field",
then you can use the Formula Builder and Insert Field buttons to insert API Field Names into your Formula(TEXT) field.

User-added imagePlease let me know if this helps

Best Regards
Naga Kiran
ManojjenaManojjena
Hi Manav,

try with below formula .

Tour Reference API & Order ID.API  and select order reference return type as Text .