Forum Discussion

QBAdmin11's avatar
QBAdmin11
Qrew Trainee
6 years ago
What if I have 2 <ask the user> questions in the report (Project Number and Fiscal Year) but the user still have to specify the Fiscal Year.

It is work if I set Fiscal Year  with a specific value (ex: FY-2020) ...
URLRoot() & "db/" & [_DBID_EXPENDITURES] & "?a=q&qid=7&nv=2&v0=" &  URLEncode([Project-ID]) & "&v1=" & URLEncode("FY-2020")

But if Fiscal Year is still an <ask the user> question, what have I to do? 

Thanks,
Karen



  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    There may be solutions with increasing levels of complexity to set up, but how about landing the user on a report with just the project pre-selected by the URL and allowing them to just use a Dynamic Filter to select a fiscal year?  basically that is the same effort as having to answer an <ask the user> question, it's just off to the side.

    The report description can Remind them tell them to do that.  The report can also sort and group by Fiscal year.