Forum Discussion

Qrew Captain

3 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

Qrew Cadet

3 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
Qrew Captain
3 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
------------------------------