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.

0 2 137
2 REPLIES 2

Bahbus
New Member

Steve
Platinum 4
Platinum 4
Top Labels in this Space