I’d like to build a messaging-style system in AppSheet. Currently, I’m using the “Table” view, but when there are multiple tickets, it becomes difficult to reply to a specific message.
Here’s my goal: When an email arrives, I want to be able to reply to that email message through AppSheet, and when the same user replies again, I want to continue this communication easily and in an organized way.
Which type of view or structure would you recommend for this use case? What is the best way to create a messaging-like experience within AppSheet?
For a messaging-like workflow in AppSheet, you’ll want to model your data so each “conversation” has a parent record (e.g., Ticket or Thread) and each message is a child record linked via a Ref column. Then use a Detail view for the parent with an inline table view of related messages, ordered by timestamp descending. This lets you open a ticket, see the full message history, and add new replies in context. You can also enable format rules to visually distinguish sender vs. recipient messages, making it feel closer to a chat interface. For email integration, configure a Bot that triggers on new message records to send email replies with the correct subject threading.