Skip to main content

Trying to date-order an array being rolled-up from a date field

  • September 21, 2017
  • 8 replies
  • 58 views
E
Forum|alt.badge.img+2

Me again, still working on same database as Going mad trying to avoid duplicates with ARRAYUNIQUE.

I’m trying to create a field that shows a date-ordered list of unique dates on which the items on the table are listed in a linked table.

The rollup (or a lookup) works fine, and ARRAYUNIQUE() is doing its thing, however the result is a slightly strange, non-sequential order which I think might be related to the creation time of each record.

Has anyone got any bright ideas of a workaround that might let me sort this into a sensible order?

    8 replies

    J
    Forum|alt.badge.img+4
    • John_Beaudoin
    • Known Participant
    • 44 replies
    • January 6, 2018

    BUMP

    @Ed_Moore, I just ran into the same issue with concatenated results in a roll-up. The results appear to be ordered by record creation. I need them to be alphanumerically sorted, as I’m using the rollup field in the “Page Designer” block to produce a list.

    Anyone have a solution?

    Thanks,
    JB

    A
    Forum|alt.badge.img+18
    • Andre_Zijlstra
    • Inspiring
    • 166 replies
    • February 21, 2018

    Today I ran into the same problem. I think it is related to entry order, and that really messes up the whole idea of the rollup for me.
    Anyone ideas to help out?

    M
    • Max_Elman
    • New Participant
    • 1 reply
    • July 29, 2018

    Today I ran into the same problem. I think it is related to entry order, and that really messes up the whole idea of the rollup for me.
    Anyone ideas to help out?


    Also interested in this!

    J
    Forum|alt.badge.img+1
    • Joel_Ronne
    • New Participant
    • 2 replies
    • March 19, 2019

    Has anyone found a solution to ordering rollups? I would be ok if I could just reverse the order so that the latest entry was shown at the top.

    A
    Forum|alt.badge.img+18
    • Andre_Zijlstra
    • Inspiring
    • 166 replies
    • August 22, 2020

    As much as I like some of the new introduced AT features, I really really REALLY would love to see this fixed. Some stuff in my databases I just can’t use because of this flaw.

    Y
    • Ydelbys_Perez
    • New Participant
    • 1 reply
    • November 29, 2021

    Hello everybody, i really do need to do this too. I need to get the look up field ordered. Or register in a field the order of the item order in a view.

    A
    Forum|alt.badge.img+18
    • Andre_Zijlstra
    • Inspiring
    • 166 replies
    • June 24, 2022

    Today I ran into the same problem. I think it is related to entry order, and that really messes up the whole idea of the rollup for me.
    Anyone ideas to help out?


    Hi Airtable! Is there any news about my question? As long as the order in the rollup result can not be controlled it is impossible for me to use it!

    Please let me know if there are any developments in this area.

    Regards,
    André

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9814 replies
    • June 24, 2022

    Unfortunately, the only way that you can change the order is to do this manually by one of the following methods:

    1. Drag-and-drop your linked records into a different order within the linked record field, or
    2. Use the batch update extension to sort the linked record values within the linked record field.

    Alternatively, for a slightly more automated way of doing it, you could:

    1. Write a custom JavaScript to do it for you, or
    2. Use a no-code automation tool like Make.com (which doesn’t require any coding).

    It would be amazing if Airtable offered automatic sorting of linked records, especially since more advanced database platforms like FileMaker natively offer this feature built into their product.

    So be sure to email support@airtable.com about adding this important feature into the product.


    Terms & ConditionsAccessibility statement