Hi everyone,
I’m working on a table that pulls in user data to generate a weekly summary message using AI. The issue I’m running into is that the “Complete Chat” column keeps updating every 5 seconds — even though no new data is being added and no new rows are being created.
Has anyone experienced this before?
What could be causing this?
Is there a way to see what’s triggering the update so I can troubleshoot it?
The sync mode is set to Normal.
Thank you
What data source type are you using?
What inputs are you giving the Complete Chat column?
Do any of them reference the current time, either directly or indirectly?
It does. I use the today’s date to help identify events that are within 7 days.
Is there any workaround for this or do I have to redo how I use today’s date?
Okay, that most likely explains it, because the current date/time in Glide changes every 10 seconds. What you should do is convert your dates to integers using a Math column. Use the following formula:
Year(Date) * 10^4
+ Month(Date) * 10^2
+ Day(Date)
Do the same using the current date/time as a replacement, and then do a numerical comparison. Because this value will only change once every 24 hours, that should resolve your problem.