User input either default or user initials

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.

Create your list by:

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

Example:

solved. Did exactly as described. Worked.

1 Like

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