AnsweredAssumed Answered

Calculation : Get last 10 most recent records

Question asked by Cécile on Oct 27, 2018
Latest reply on Oct 28, 2018 by philmodjunk

On my header , I want to create a rotating sequence of the last 10 messages created. I am not sure how to proceed to extract these. I thought of putting them on a 10 pane slider and with a time laps switching pane. or

I could set the gNews displayed in an edit box to a calc.

I tried the following, manually run but I get ?

Let ([

$$r=If($$r > 10;1;$$r+1);

l=SortValues ( (List (µMessages::Date)) ; µMessages::Date ; "French"  );

t=ValueCount ( l)];

GetNthRecord ( µMessages::Message ; t-$$r )

     )

Outcomes