ENUM from Ref : ID is the value, but what appears is the name

AppSheet AppSheet Q&A
1

Hi there.

I have table “User”

ID Name auth

1 Ahmad Admin

2 Faisal User

3 Yusuf User

I want to show Enum list like this:

USER :

    1. Ahmad
    1. Faisal
    1. Yusuf

And when I save the data, the user input must be the ID (1 or 2 or 3)

Thanks for your solutions. sorry because my english is bad. :disappointed_face:

2

One way you can do this is to create a VC in the users table with the expression [id] & ". " & [name] and designate it as Label.

For any field you want to capture users, just make it an ENUM column with ref to the users table. Even though the appearance is in the form of 1. name, the data stored in the backend DB is id values.