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 recordL...
Forum Discussion
Have you tried to compare field 9 using 'TV' instead of 'EX', since it appears that is a user field? And what does the formula checker have for the execution of this?
https://helpv2.quickbase.com/hc/en-us/articles/4418287644308-Components-of-a-Query
TV | True Value (compares against the underlying foreign key or record ID stored in relationship fields). When you use tv, you are comparing against the unique value of the user which is either the hashed UID like 123456.abcd OR the email address OR the screen name.
| Also used for queries on User fields. |
I used TV but actually the values is not getting assigned with the values but remains as number itself.