I would like to show a list of images - one image at a time - I was thinking of using the image component. Some of the images can be set to Hide, so they should not be shown. I would like to use an increment action so each time I click on a button the next image should be shown.
The increment action works nicely when all images are to be shown (using UID from below table) - but when some are not to be shown - and then the problem arises. I thought about doing an extra column (Value to use by the increment button) telling which is the next image to show - and do a relation lookout where only I get the row where Hide=No
Take another look at the link in this post and make a copy. I use a helper sheet with unique to get the list images without empty rows, then vlookups to get the determined columns used for a relation back to the original sheet. You could probably do something similar with a query in a helper sheet, some formula to get the row number, then a vlookup to get the row number back into the original sheet.
I will try to help Krivo with a sheet version of that idea when I get to the laptop later today.
I was working on something pretty similar but did not require an increment, but complex visibility based on each user and I hope I can share that with you guys as well soon.
@ThinhDinh that would be great.
Tried to use @Jeff_Hager idea with a helper sheet - I didn’t get it to work as I wanted to get some variables which were only found in the builder. And is will also take a lot of rows
I will stop for now as it is getting late (@ThinhDinh it is very late in Vietnam I believe ah - it might actually be morning )
Just keep in mind that a helper sheet would not be used by glide, so it shouldn’t count against rows. It would only be used internally in the Google sheet.
@ThinhDinh thx a lot. Looks great. I have one problem through. The “inactive” field is a simple text field until glide writes to the field whereafter it is a boolean field. If I make the whole column booleans then I will get all to many rows as glide will think it has values. So how to avoid that?
Maybe I should change the formula so FALSE or empty string is found in the cell. But i’m not sure that the countifs will work then. Any hints/ideas?