Clearing chat history

I’ve been using Glide’s Chat feature for interacting with a “makeshift” AI Assistant in our app. But I noticed that there’s no option to auto-clear or trim off old chats so there’s a lot of scrolling when you’ve got a long chat history. Has anyone tackled this problem? Or have a workaround for this? What’s my best approach for keeping the chat histories tidy for all users?

Cheers,
Patrick

You could probably do some with a query that only selects messages older than a certain date or something like that, and then add an After Submit action that deletes those rows through the query.

1 Like

An alternative to what Jeff suggested above is creating a scheduled workflow that runs at a chosen time everyday.

You want to have a column that calculates how much time it has been since the row has been created.

Create a loop through the table and filter for rows that have the number above larger than a threshold, and delete each of them.

Please note that scheduled workflows would see time calculation at the timezone UTC.

1 Like