Stacker logo
Stacker
Create
Roadmap
Feedback
Feedback
Changelog
Category
Record Lists
Voters
J
Joel Lee
A
Adrienne Goodman
S
Stephanie Edwards
A
Aldo
J
Jeff Miller
T
Tristan Scifo
M
Michael Stansfield
L
Liew Lai Seng
L
Linda Brooks
Peter Nelson
and 14 more...
Powered by Canny
Allow sort by linked records
Chelsea Scriven
May 12, 2021
S
Seb
In the meantime, here's a workaround.
The idea is to create a new formula field based off of the linked record, and then sort by that new field instead. To do that:
In Airtable
  1. On the table you want to sort, create a new formula field.
  2. As the formula, type in IF(LEFT({Linked Record}, 1) = '"', SUBSTITUTE( MID({Linked Record}, 2, LEN({Linked Record}) - 2), '""', '"' ), {Linked Record} )
  3. Replace Linked Record with the name of your linked field. There are 4 to be replaced.
This will create a new formula field with the data from your linked record, but as text. The long formula strips away unnecessary quotation marks.
In Stacker
  1. Manually sync schema and data for the table where you made the change.
  2. Go to that table's Field settings, and turn on the new formula field
  3. Edit layout of the table you want to sort
  4. Choose to sort by the new field
Your table should now be alphabetically sorted by your linked records, through the formula field.
·
December 2, 2021
·
Reply
Powered by Canny