Skip to main content
Question

How to use GetRecords()

  • May 15, 2025
  • 0 replies
  • 378 views

Forum|alt.badge.img+1

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.

Mez
Forum|alt.badge.img+7
  • Quickbase Alumni
  • May 15, 2025

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.