So I am currently building a small customer manager app and would like a little help. I have four data tables :
: Customer information
: Vehicle information
I want to create a unique ID so I can be able to reference my different tasks and logs. So I created a UNIQUE_ID_CLIENT, added the formula [LAST_NAME] & [DATETIME]. However, when I use it as the key, it says a key can’t use a formula. What would be a correct way of doing this ?
Not all my customers use emails, not all my customers use phone number, so I can’t use any of those values as a identifier.