Jul 07, 2022 03:06 PM
I have a linked record table that stores dates for publications. The dates are unique and form the primary field.
When a value is inserted in a linked record field in the main table they are treated as text, which throws out the sorting.
It’s there any way to resolve this?
Jul 07, 2022 03:17 PM
Not directly, but you could add a Lookup or Rollup field that’s pointed at the same date. Those will let you sort properly.
I think its happening because linked fields are arrays. While Lookup fields are often arrays, if you’re only linking to one record then the Lookup’s value formatting sometimes matches the original field (in this case a date). Rollup would be your safest bet.
Jul 07, 2022 04:22 PM
When dealing with link fields in code, they return arrays. However, when virtually anything else looks at a link field, it returns a string, with items separated by commas if there are more links than one. In this case, it’s auto-converting the date into a similar date string.
Jul 08, 2022 12:39 AM
Many thanks for your replies. I feared extra fields might be the only answer.
I’m finding that I’m having to add so many fields for various workarounds it is making my main table very cluttered. Even with the ability to hide fields I think this is going to result in a confusing UI for different types of users.
It seems to me Airtable has serious limitations in two areas - handling relational data and creating a clean user experience!