Hello! I have a question here.
I use Zapier to integrate Airtable and Facebook Messenger as a way to maintain my customer support. Messages sent to my Facebook Page will be created as records in an Airtable table.
Here’s what it looks like: https://i.imgur.com/zRsho7J.png
As you can see, messages are always sent back and forth, so I group the records by Sender. But as the messages start to pile up, I want to have the latest messages (or the groups with the latest messages) to be on top of the table. However, if I sort the records, they will only be sorted within the groups, and groups are sorted by Sender alphabetically.
Is there any suggestion to do this?
Hi @Alexey_Gusev do you mean I have to create tables for each sender? It’s impossible because this customer support is made for random users which can be a million. It’s like any random user will just drop a message to your Facebook Page.
Nope, a single empty table, list of senders. primary field - Name, second field - link to first table.
then turn to table 1, copy-paste whole sender column into linked field
then turn to t2, you’ll get a list of all senders, create rollup to get last date
then in t1 add it as lookup and group by it
But that will work if new records will be supported by links(many ways to do it). Or you copypaste field each time when you need to sort by date.
it’s quite complex for just another type of sort. but you can use this connection for a number of further actions
linked field - links 2 tables, visible in both, links created in first, reflected in secondd.
lookup field - field, relying on link field, reflects records from 2nd linked table to 1st table
rollup - “advanced lookup”. lets you apply the formula to all the links in linked field.