0

Choice Field

There is a table where information is entered every day, and there is a Choice field - categories. When we open a new day, it is necessary that the value of the categories is transferred to the next day. How we can do this? For such cases we use the formula

let c := number(Id);
let bc := last((select 'Daily Result' where number(Id) < c) order by number(Id));
first(select 'Daily Result' where Id = bc).Category

It doesn't work for the Choice field. Tell us please the correct formula for trigger choice field

Regards

1 reply

null
    • iliper LTD
    • iliper_LTD
    • 1 yr ago
    • Reported - view

    let i := number(Id);
    let c := last('List of Players'.'Daily Result'[number(Id) < i].Category);
    Category := c

     

    Just for cloud version

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 51Views
  • 1 Following