@Mark any roadmap to add this option to access to the other tabs we add in our sheets?
@Mark This is great. Is there any chance of adding the same conditions against the add record options as-well as edit?
E.g. ticking the âAllow users to add itemsâ box will also show the ability to add conditions on who can add.
Thanks
Weâre definitely planning to do that.
2 Likes
Great! This will increase the possibilities
I am working on this app with free and paid users. This would be ideal for that, right? âIf user is Premium show this contentâ ?
Yes!
Is there any way to allow arrays to be referenced through this new process? Iâm trying to add a Choice Component where a user would select one of their Jobs (stored in the User sheet in multiple columns joined as an Array in Glide). Currently, I can only add a specific column and itâs not picking up on the array.
Havenât tested thatâŚmight be one of the limitations if youâre not seeing the column.
Shoots! I would really improve my process. Right now, I canât figure out a way to create a choice component that only displays the Jobs that the user has previously selected in their profile.
It currently works with the old way:
Thanks for the video. Iâm was already pulling in the array values to my other sheet (using the userâs email address as my way of creating the relation), but then I canât figure out a way to create a Choice component that would contain the array. Basically, I want the user to be able to pick one of their jobs in a form.
Lookup:
Choice Component options: expectation is that the array would be an option in the choice âoptions columnâ but itâs not. I guess this is more a request for the Choice Component than for the new User Profile functions.
RightâŚno choices donât work that wayâŚeach choice needs to be on its own row.
Figured it out!
Created a new sheet with all Jobs listed (used a Unique function that combines and sorts the Jobs columns in the User Profile sheet ---- =sort(UNIQUE(PROPER({âUser Profileâ!G2:G;âUser Profileâ!H2:H})))).
This gives me a column I can use to create a relation from the array of job titles to the UNIQUE column in the Jobs sheet.
Once I have that relation done, I can add a Lookup in my other sheet that pulls in the Jobs Relation values.
Itâs hard to explain but it works!
Does it pull in ALL jobs or just the ones that the user entered using relation/lookup?
It pulls in each personâs jobs that theyâve entered into their User Profile. Exactly as I wanted to it work, but I donât really understand how I got it to work haha
Hum, interesting! I would not have gone on gsheet side to resolve this!
Hi Mark,
I also have this problem with my app:
I have established a user sheets that I am using for profiles and tracking which users have agreed to our terms and conditions and the sheet is constantly getting updated with duplicate email whenever someone simply logs into the app. Is there a fix for this?
You arenât using any scripting to copy emails from App: Logins, are you?
@Alex_Wuerth Weâre working on a fix for that. Itâll roll out on Tuesday. Sorry for the problems.
1 Like
I Dont see User on visibialityâŚIs that only for some user ?to use