Our team met with Mark Shnier today and we believe he has identified a solution to this issue. For any values that we would dynamically reference from the formula rich text button, we set those fields up as <ask the user> filter criteria. Run the report the first time and answer the question which then generates a URL. Then place that URL string into the formula rich text button.
For example:
The previous URL was this:
URLRoot() & "db/" & [_DBID_SCHEDULE_LIBRARY] & "?a=q&qid=40&query={28.EX." & URLEncode ([Related Contract]) & "}AND{145.EX.1}AND{103.XEX.1}&qrppg=500
We had to reference all the report query parameters as using "&query=" overrides all the report parameters in the native report qid.
We also found that use of the "&query=" was not honored once the user clicked on the next page of a paginated report, so we had to force more records to be displayed at a time by using "&qrppg=500" or similar large number.
The new URL looks like this:
URLRoot() & "db/" & [_DBID_SCHEDULE_LIBRARY] & "?a=q&qid=40&nv=1&v0=" & URLEncode ([Related Contract])
The parameter "&nv=" is the number of <ask the user> questions (or number of values).
The parameter "&v0=" is the answer or value to the first question.
Any values that are non-numeric will need to be URLEncoded.
We will be updating our dynamic formula rich text buttons to this method.
------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.comPortland, OR
801.946.0576
------------------------------
