0

How to sort SubTable fields in summary formula field in MainTable

Hi guys,

I struggle a bit with the coding of a formula field in my MainTable (VIDEOS), intended to turn records from SubTable (VideoBeats) into a simple 'cut&paste-able' single-page text for teleprompter

 

The problem is: How do I sort the subtable records by the manually managed "BeatSequenceNo" value instead of the auto-created ID ? (the WHY: sometimes I change the VideoBeats sequence  in the writing process - which makes a mess of my teleprompter script) 

Ninox-sort-summary

Thanks, John.

4 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    Hi John -

     

    You can use the order by function. If you have a select statement then you can add order by at the end.

     

    select VideoBeats order by BeatSequenceNo

     

    Let us know how it goes.

    • KAXIG ApS
    • John.1
    • 3 yrs ago
    • Reported - view

    Thanks Fred, that was actually one of the things I did try - but nothing returns (for some reason)

    I have a feeling though of being close to the finish line - just missing the last piece in the puzzle

    But instaed of writing a lot, I've made a 1:23 min. video showing my issue: https://vimeo.com/655617740/e2e80bf663

    I bet it´s something simple I've missed  :)

     

    J-)

    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    It seems that you are expecting the function that gathers the linked records to be somewhat "aware" of the sort order set in the subtable display. It is not the case: if you need a particular sort order in a formula, you must specify it inside the formula.

    Try replacing "Beats.SUMMARY" by "(Beats order by No).SUMMARY".

    • KAXIG ApS
    • John.1
    • 3 yrs ago
    • Reported - view

    Thanks a lot Alain - works like a clock :)

    I knew what I did, wouldn't work - just didn't know how to do it correctly.

    But now I do, thanks to you.

    Happy Xmas :)

    John.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 266Views