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 ?
Solved! Go to Solution.
If the ID is also the row key, you canโt directly do what you want because you canโt modify the userโs input in place. Instead, youโd have to construct the ID in a separate column using the userโs input. That separate column would then be the key column rather than the input column.
See also:
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |