RECORD_ID() Help

[Mark_Baker]

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

[Jeremy_Oglesby]

Mark_Baker:

CONCATENATE({Company ID},{Unique ID})

The & is a shorthand for CONCATENATE().

You can just use:

{Company ID} & {Unique ID}

[Mark_Baker]

Champion, thank you for your help Jeremy!

[M_k]

Hi

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

MK