Solved: Automatic customerID generation - Page 2

JesperErsoy · 09-30-2019 04:32 AM

Hi

so i have a CRM and i would like to generate the customer ID automaticly is that possible?

I have several different companys in the CRM so lets say i have a company called AAA and i want to create the first customer for company AAA

i want to make the customer ID AAA-1 since this is the first customer and then the next customer i want to call AAA-2 and so on but is it possible to have appsheet generate the ID automaticly ?

Mariano_Sanz_Gi

It’s also an excellent solution I did it that way too, but repeated IDs can be generated if a previous record is deleted. That’s why I switched to calculating the maximum instead of counting the records.

View solution in original post