Hide Dropdown list

[carobernachea]

I have a log of user access and egress.
When they register to enter, if their ID has already been entered, it will be in the drop-down list to select, and it will auto-complete the user's data.
If it does not exist, it will go to NEW and will be created by completing the form from scratch.

My question is, is there a way to hide those values ​​and that is more like an "autocomplete" or that detects the ID of the USERS table and from there, brings the data.

Since it is unsafe for other people's IDs to be shown, since anyone could complete registrations under another ID that is not theirs.

I leave images so you can understand

Thanks in advance,
Greetings!

[lynchk21]

It won't be an auto-complete, but if you set the column to a text type, and use IN([_This],USERS[ID])=TRUE  This will prevent new users from "selecting" new, so then you would need to create an action button to a new form, or a different way to navigate to a new form for new users

[carobernachea]

It worked! But it leaves the "true" eternally written, and I have to delete it to enter the value...

[lynchk21 · Accepted solution]

Put the  IN([_This],USERS[ID])=TRUE  in the valid_if field rather than the initial value

[carobernachea]

oh!!! thanks thanks thanks ❤️