Solved: How to add prefix to key on created? - Page 2

sayan1 · 03-06-2020 05:48 AM

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 ?

Steve

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.