I have making inventory app.
Firsrt time I was maket it for myself, but some peoples see what I am doing and want to use my app. And I am starting prototype for another users.
Id of our inventory is same. In my database I have product with number 1, 2 and 3. And my users must use this own id like this. So we will have same ID.
But I want to make them uniq just add useremail befor ID. When user add new id, I have just add prefix, when his work with products trip the prefix and his will see just ID.
How can I do that ?
I am trying to add prefix on ID column, autocomplete section, app formula, but after saving appsheet system clear them.
Any thoughts ?