Forum Discussion
SeanConnaughto1
3 years agoQrew Cadet
"<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
------------------------------
- IvanWeiss3 years agoQrew CaptainThanks 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
------------------------------