I have a two-fold use case.
- Display user-uploaded videos.
- Display user-uploaded images and videos on same screen, co-mingled based on timestamp when they were uploaded.
For displaying all videos together, I am making use of Tiles layout. I have assigned a default-image to each video file where Category(another attribute) = Video. I have made use of the If>Then>Else column to assign the default image. My columns look like this.
For my second use case, with a separate default-image column, I am able to display the images and videos separately on the same screen using the Inline Lists but still can’t display the co-mingled look based on timestamp because the media_link column (referring to images) is still separate from the default_image column (referring to image for videos).
I tried using the If:else condition directly on Google sheet. But when I set the condition to the full column, new row entries (data uploads) are starting after the last row with the condition.
I was wondering, if there is a way to apply the If>Else>Then condition in the data editor on an existing column pulled from the Google Sheet? (In my case the media_link column, instead of a having a separate default_image column)