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.
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |