Hey All! I was hoping someone could assist with some direction. I have been struggling for a few of days now on this 1 part ( learnt google sheets really well in this time but maybe I’m missing something or going about it the wrong way.
I am currently having a problem filtering my items sheet, based on logged in user.
I have an “Items sheet” with unique rows in it. I need to be able to show only items that the logged in user has not previously selected ( selected = setting a switch via a form to “YES” on the individual items themselves. )
I am trying to avoid having duplicate rows in the items sheet, due to needing a duplicate item for each user. imagine 200 users and 200 items, for every item I would need 200 users.=40,000 rows
I was thinking about creating a matrix on separate sheet, of all the items and if the user had accepted them or not, then using CONCATENATE to put them all into 1 cell on the “Items Sheet” but this would require glideapp to be able to have a second filter option ( i am using a filter already) and ability to set that filter to “CONTAINS” and ability to also select “Logged In User” as the data set.
Does anyone have any thoughts or guidance at all? Is this a non issue or is it something that is known to be tough/impossible at the moment?
Thanks for any help folks! if I can overcome this, then ill be on track to completing this project