Help

RECORD_ID() Help

6412 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_Baker
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Guys,

I am creating a base with a column which uses the Record ID formula but having some trouble.

I want to create a unique ID for each new record with a string at the front from which comes from another column. For example, when a new record is created it draws the string BB from company name column and then adds the unique id so would end up looking like BBrecnzjghg09818 or something. Is this possible to do?

If someone also books an appointment in the future I want to be able to search the base and identify that record (individual) and so that I do not end up with a whole bunch of duplicates for an individual.

Not sure if this makes sense but thought I would reach out!

Thanks,
Mark

12 Replies 12

The & is a shorthand for CONCATENATE().

You can just use:

{Company ID} & {Unique ID}

Champion, thank you for your help Jeremy!

M_k
11 - Venus
11 - Venus

Hi

As usual, I have learned something new. I might give this a try.

MK