Unique ID question

Hey Guys,

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
: Tasks
: Logs

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.

1 Like
1 Like