I think that is achievable with a user-specific column. Using your same method above, it would go like this:
- User enters their new name using that user-specific entry.
- A relation validates if that entry is not a duplication of any existing entries.
- If the relation is empty, then show the choice component to let the user change it, with the only value being the value in the user-specific column. Otherwise don’t show the choice component and show a text that the name is not available.
In my experience, pushing it back to the sheets require more than 2 seconds to bring back the value to the Glide editor and then sync it to the device of the user, so many of us here have always tried to find some ways to do it inside the Editor instead, lagging troubleshoot is a concerned issue we have discussed many times here.
All in all, nice workaround using the Sheets, and if Raph wants to try the steps I listed in this comment, feel free to do so and let us know if you succeed.
Thank you all