Skip to main content
1-Visitor
June 16, 2014
Question

[IM] query-question: how to filter for last set checkbox?

  • June 16, 2014
  • 1 reply
  • 1517 views

Hi @all,

we want to have some checkboxes in our Integrity-Items. With setting these Checkboxes the user should give his statement that he has done some work. So as an example an item could have three checkboxes, is it possible to do a query-rule which is showing what the last set checkbox was?

Thank you,

kind regards, Jens

    1 reply

    16-Pearl
    June 16, 2014

    Hello Jens,

    The easiest way I can think of to do this is to have a non-editable field that indicates which checkbox was last set, and use a trigger to populate that field with the name or symbol for whichever checkbox was last set.

    This gets complicated if multiple checkboxes get set at once, but I'm assuming you have a plan for that.

    Regards,

    Kael

    JensN.1-VisitorAuthor
    1-Visitor
    June 20, 2014

    Hello Kael,

    thanks, thought the same way but was hoping that there is some solution with less effort.

    kind regards, Jens

    16-Pearl
    June 23, 2014

    I did think of a few others, but they all had the problem of not quite working.

    I'm hoping with you that someone else has a more elegant solution.