Hi there,
I am trying to show a dynamic countdown timer in my Glide app. An example URL for this would be https://i.countdownmail.com/2eiyph.gif?end_date_time=2024-08-02T00:01:00-0800
This link is dynamically generated in my Google Sheets database.
Here is what I’ve tried:
- inserting an image with that link. Works for the most part but it seems like the image doesn’t always get loaded properly and shows the wrong countdown. Perhaps it gets indexed and then stays that way (even though it still counts down?). Not sure. The issue is that when I show the event date and the countdown is counting past it (e.g. event date 8/3 and the countdown is counting to 8/17), it defeats the purpose. And the link is correct.
- using Rich Text and a template row. This worked by far the best with no wrong images being loaded. However, on mobile, it’s not loading it at all. I am using the following:
<div style="display: flex; justify-content: center; align-items: center; height: 100%;">
<img src="upload://sIlcgIQHlNlJ3bWUdg3VUDAuc02.gif" alt="Image" style="max-width: 50%; height: auto;">
</div>
and it shows perfectly on my desktop, but not on any phone or mobile browser.
I was considering using the custom code module with HTML. However, while there is a field to add data above it, I can’t seem to figure out how to use that data inside the HTML.
This seems to be the best way, but I can’t find any documentation about it either. Any advice?