Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
4 years ago

Formula Query to check for users already on PTO and display on a form

Hi everyone, I am relatively new to formula queries and love the power of them but am finding them super complicated to use....  I am trying to create a rich text field that will display employees ...
formula queries
SeanConnaughto1's avatar
SeanConnaughto1
Qrew Cadet
4 years ago
"<table>" &
"<tr><td>Record ID</th><th>PTO Start Date</th><th>PTO End Date</th></tr>" &
SearchAndReplace(ToText(GetCellValues(GetRecords("{8.OAF.'"& [PTO Start Date] & "'} AND {9.OAB.'"& [PTO End Date] & "'}"),)), ";", "") &
"</table>"​

FYI--You are going to need to change the "GetCellValues" to "GetFieldValues" as that was changed recently. Maybe try this:

"<table>" &
"<tr><td>Record ID</th><th>PTO Start Date</th><th>PTO End Date</th></tr>" &
SearchAndReplace(ToText(GetFieldValues(GetRecords("{8.OAF.'"& [PTO Start Date] & "'} AND {9.OAB.'"& [PTO End Date] & "'}"),[QUERY FIELD YOU WANT TO CAPUTRE HERE])), ";", "") &
"</table>"​


------------------------------
Sean Connaughton
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    4 years ago
    Thanks Sean, so what is meant by query field you want to capture here for the GetFieldValues?  I am not quite sure what field that is supposed to reference.  For some reason I am having a mental block on that one....

    I am looking to "loop" through all of the records to get the full name, PTO Start Date, PTO End Date and display them on a table

    ------------------------------
    Ivan Weiss
    ------------------------------