User input either default or user initials

vsman · 2025-02-08T17:20:42.413Z

New user.
Have setup a spreadsheet. When a user logs in-
1- they should only be able to select the drop downs that say A.
2- In the dropdown the only choice they should have is A or their Initials (I have setup a initials data field in user datatype.

I keep hitting a roadblock in the dynamic options for the drop down.

image611×356 13.6 KB

davidb · 2025-02-08T19:45:39.852Z

Create your list by:

Within an Arbitraty text, concatenate your fixed (e.g., A) and dynamic (e.g., Current User's Initials) choices using a delimiter.
Split the concatenation by the delimiter.

Example:

image1410×546 50.4 KB

vsman · 2025-02-08T20:30:26.951Z

solved. Did exactly as described. Worked.

system · 2025-04-19T17:20:55.115Z

This topic was automatically closed after 70 days. New replies are no longer allowed.