How do i make choice to be user specific when th layout is in detail view?
All users that input the data, it only goes in the first row of the sheet, The DB is set as text per user.
So here is my issue. The choice in filter is from sheet 3 (Menu Sheet). So i cant filter it to the user login from the current sheet 2 (name sheet) connecting to sheet 1 (user login)
And i cant do a relation from sheet 3 to 1/2 as there is no affiliation.
Sheet 3 is purely meant for menu options in the app.
the 2 sheets