What can I add to the rdr=... (redirect) that will just display the record(s) found by the query? Without a rdr=, I receive the message:
"This XML file does not appear to have any style information associated with it. The document tree is shown below."
URLRoot() & "db/" & [_DBID_WORK_ORDERS] &"?act=API_DoQuery" &"&apptoken=bcceeidcwsqrifdef7s72cqiqhy" &
"&query={'6'.OBF." &[Pay Period Ends] & "}" // Work Order Date on or before Pay Period
& "&rdr=
Question
API_DoQuery question
+5This topic has been closed for replies.
Hi Jim,
Let me suggest a low tech approach
Make your perfect report which had an ask the user. for the pay period ending date.
Answer the question and observe the URL.
On another tab, build this formula to mimic the URL
URLRoot() & "db/" & dbid() & "?a=q&qid=xx&nv=1&v0=" & ToText([Pay Prriod Ending])
That will run the report and answer the ask the user question from data on the record.
Substitute the query id# for the xx
Let me suggest a low tech approach
Make your perfect report which had an ask the user. for the pay period ending date.
Answer the question and observe the URL.
On another tab, build this formula to mimic the URL
URLRoot() & "db/" & dbid() & "?a=q&qid=xx&nv=1&v0=" & ToText([Pay Prriod Ending])
That will run the report and answer the ask the user question from data on the record.
Substitute the query id# for the xx
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.