How to add prefix to key on created?

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 Solved
0 3 1,231
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

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:

View solution in original post

3 REPLIES 3
Top Labels in this Space