How to use GetRecords()
var text QUERY = "{9.EX.'" & ToText([Person Assigned]) & "'} AND {3.NE." & [Record ID#] & "} AND {11.LE." & [End Date] & "}AND{10.GE." & [Start Date] & "} AND{13.NE.'Completed'}"; var recordList overlappingTasks = GetRecords($QUERY); var number conflictCount = Size($overlappingTasks); If( $conflictCount > 0, "Not Available", "Available" ) I have used the above query to configure any existing records but the comaprison is not done in the way expected like the number 9 gets compared not the value like that in everything.42Views0likes4Comments