Hi, so we’re going to be using AppSmith to act as one side of a chatbot.
Our clients will be using a native app. They’ll be able to access a chat feature where they can speak to an employee. Any messages they get sent will be saved to a certain database table.
On the other side of the chat is our employee that will be using Appsmith to read and write back data from their end. The thing is though, we need a way for the table to be updated in real-time, so that any new messages from our clients will be showing on appsmith automatically too (as opposed to requiring our employees to do a manual refresh of the table).
Is there any way to achieve a similar need to this? If there isn’t, what would be the best workaround?
There’s no way for the database update from another source to trigger Appsmith to refresh the table, but there’s a webhook feature in development that should help:
Also, the latest release includes setInterval()/clearInterval() functions that could be used as a workaround to periodically refresh the table. It wouldn’t actually be triggered by a database update, but you could refresh every 30 seconds or so to check for new replies.