Forum Discussion
MarkShnier__You
Qrew Champion
np,
make an <ask the user> report in the Other App which asks the question(s) about the filter.
Run the report and put in any dummy answers to the questions and observe the URL. Now Lets replicate that URL with a formula.
This will be a formula URL field.
"https://login.quickbase.com/db/9kaw8phg?a=q&qid=99&nv=1&v0=" & URLEncode([field with the answer to the question]
Obviously replace th 99 with your report # and the URL prefix with your own path.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
make an <ask the user> report in the Other App which asks the question(s) about the filter.
Run the report and put in any dummy answers to the questions and observe the URL. Now Lets replicate that URL with a formula.
This will be a formula URL field.
"https://login.quickbase.com/db/9kaw8phg?a=q&qid=99&nv=1&v0=" & URLEncode([field with the answer to the question]
Obviously replace th 99 with your report # and the URL prefix with your own path.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RusselNdip
5 years agoQrew Trainee
When you say create an ask the user report to ask questions about the filter. Do you mean create a report within the table I want to filter the report on or create another table to do this? I guess my problem or question is I'm not sure how generate a report from user input from within one application in the first place.
------------------------------
Russel Ndip
------------------------------
------------------------------
Russel Ndip
------------------------------
- MarkShnier__You5 years agoQrew ChampionRe: Do you mean create a report within the table I want to filter the report on
Yes, then follow my instructions.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------