Forum Discussion
MikeTamoush
Qrew Commander
I'm not sure the exact issue, but the way I test and set mine up is by creating the report I want (say list all, just make a copy of it), and then adding my filters as 'ask the user'. I run the report and select a dummy entry for ask the user, and then that gives me my URL that I can now edit for my purposes.
So, perhaps make an ask the user filter that mimics what you want on your list all report, run it, and see if it gives you the syntax you need.
------------------------------
Mike Tamoush
------------------------------
So, perhaps make an ask the user filter that mimics what you want on your list all report, run it, and see if it gives you the syntax you need.
------------------------------
Mike Tamoush
------------------------------
RussellBeaubien
2 years agoQrew Cadet
The users are looking at the relevant project I want the button to give them the right information. I could set it to be the way your saying but then the users would have to go to another table and filter it down, instead of pushing one button
------------------------------
Russell Beaubien
------------------------------
------------------------------
Russell Beaubien
------------------------------
- MarkShnier__You2 years agoQrew Champion@Russell Beaubien
no.. you are not understanding the alternative suggestion.
Make a report which has an <ask the user> on Project Number. Run the report, and answer the question and observe and mimic the URL
URLRoot() & "db/" & [_DBID_my table] & "?a=q&qid=6&nv=1&v0=" & URLEncode([Project Number])
So the user will click the button, it will run the report and answer its own <ask the user> question.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- RussellBeaubien2 years agoQrew CadetThanks, that worked perfectly.
Mike and I started Messaging and I figured out the I was not getting it at first
------------------------------
Russell Beaubien
------------------------------