4 Replies Latest reply on Dec 15, 2016 11:53 AM by siplus

    List IDs but Isolate by secondary field

    MartinBishop

      Hi I am trying to figure out a method to list some IDs via a script, which is working, but I want to further isolate records.

       

      IsEmpty ( FilterValues ( Get (ScriptParameter) ; List ( Table::FieldID ) ) )

       

      How can I List the FieldIDs, but only show ones that have another field activated.

       

      FieldID | FieldStatus

      1 | 0

      2 | 1

      3 | 0

      4 | 1

       

      List would only show IDs 2 | 4