Abbreviations before UNIQUEID()

[Quentinlebg]

Hey,
My goal is to have a UNIQUEID(), but I want the company that produces the item to have their abbreviations right in front of the UNIQUEID().

[Marc_Dillon]

help.appsheet.com

CONCATENATE()

Merged text from parts

[Quentinlebg]

Thanks, I tried this expression “CONCATENATE(SELECT(Company[Abv.], [Company] = [_THISROW].[Company]), “-”, UNIQUEID())”

But I got this error message: “Expressions in schema ‘Quote_Schema’ have a circular definition. Check app formulas and initial values for column ‘Quote_ID’”

Would you know by any chance if it is due to the company being below Quote_ID?