Rather than trying to pull the time from an outside source, I thing you would be better off calculating it yourself. Have a look at this thread. Rather than calculating GMT time, you can set the correct timezone to calculate to Columbian time. Then you will have a value in your table that can be used for conditions in the app.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Add Colombian time | 2 | 316 | April 22, 2022 | |
| Display UTC time in Glide App in users Local Time | 11 | 1281 | August 22, 2024 | |
| Set column - Time zone | 8 | 707 | March 26, 2021 | |
| Time Zone and "Current Date/Time"? | 8 | 536 | February 12, 2024 | |
| 🆕 "Respect time zone" support for Date & Time column in Glide Tables & Airtable | 17 | 1901 | September 24, 2025 |