0

Conditional formula

Hello everyone, I have a small question for you:

I'm using a "join" formula to show records from a referenced table in the record.

I added a number field to the referenced table so I could see the records in a specific order.

How could I transfer that order to the formula??

The formula is this: 

join(for i in 'Posts' do
    i.'Position' + " " + i.'name'
end, " / ")

I was also wondering if it'd be possible to NOT show specific records from the referenced table, by using for instance a check-box field as switch.

Thank you!!

5 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    try this:
    join(for i in 'Posts' [checkboxfield] order by numberfield do
        i.'Position' + " " + i.'name'
    end, " / ")

      • pirinisz
      • 2 yrs ago
      • Reported - view

      RoSoft_Steven worked perfect, now I can set the order, thanks a lot!!! One more thing: if I don't want to show one of these records, let's say No 3, could I exclude that one somehow??

      • pirinisz
      • 2 yrs ago
      • Reported - view

      RoSoft_Steven or maybe showing just the first 2-3 records...

    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    Something like this:

    join(for i in slice('Posts' [checkboxfield] order by numberfield , 0,2)do
        i.'Position' + " " + i.'name'
    end, " / ")

      • pirinisz
      • 2 yrs ago
      • Reported - view

      RoSoft_Steven You're the best!!! THANKS A LOT!!!!

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 5Replies
  • 81Views
  • 2 Following