MartinBishop

List IDs but Isolate by secondary field

Discussion created by MartinBishop on Dec 15, 2016
Latest reply on Dec 15, 2016 by siplus

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

Outcomes