

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
The Page Designer block has a fantastic feature that lets me display a โLink to another recordโ field and sort those records by a field inside those linked records. It even lets me choose what text to display so instead of only pulling the Primary Field, I can display any field I want. In that way. it almost seems like it behaves like a Lookup field, but itโs surprising how much more control it allows here.
An example of my situation:
I have a table of Dates. Each Date is linked to a Project.
I have a table of Projects. In this table I have a โLink to another recordโ field that pulls in Dates that are linked to each Project.
The problem:
Thatโs all that the โLink to another recordโ field lets me do. I canโt sort or customize what text is displayed. I can use the โBatch Updateโ block to sort this field, but it sorts it by alphabetical order, a completely useless order when it comes to dates since it ends up sorting by the eventโs Primary field, and not the date.
I could rework the Dates table so the date is the Primary field. That would result in the list of dates being in order when I pull them into another table using a โLink to another recordโ field. But that would also result in a list of dates, and not a list of named events. Not much use. A list of unnamed dates, in chronological order, and a list of named events, in alphabetical order are both less than ideal.
Why does the โLink to another recordโ field in the Page Designer block allow for so much customization, while the same field in a Table, Gallery, or Kanban view doesnโt allow for any at all?