Forum Discussion
AhuvaBrown
3 years agoQrew Trainee
If you want to get a list of values in a field from all records that match your conditions, you can use GetFieldValues
I'm not clear on which fields are on which table, but this is what comes to mind.
Say the Incentive Program field id on the table you're searching is 6 and the Related Person field is 7
var text query = "{7.EX.'[Related Person]'}AND{other conditions}"
GetFieldValues(GetRecords($query, tableid), 6)
You would put this in a multi-select text formula field, and it would return a list of incentive program values on the records that match the conditions.
------------------------------
Ahuva Brown
------------------------------
I'm not clear on which fields are on which table, but this is what comes to mind.
Say the Incentive Program field id on the table you're searching is 6 and the Related Person field is 7
var text query = "{7.EX.'[Related Person]'}AND{other conditions}"
GetFieldValues(GetRecords($query, tableid), 6)
You would put this in a multi-select text formula field, and it would return a list of incentive program values on the records that match the conditions.
------------------------------
Ahuva Brown
------------------------------