Sheets challenge for me.
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
How could this be solved - anyone?
|UID||Image id||Hide||Value to use by the increment button|
Using a similar setup as @Manan_Mehta did