Forum Discussion

Qrew Cadet

2 years ago

Editing Drilldown Reports

I have an application that has 3 different forms based on the data necessary. When the form is submitted a field is changed to the type of data entered, "Flyer Request", "Rep Sample", and "Project W...

BrianDunk

Qrew Cadet

Hi Mark, couple clarifications:

Can you explain your instructions more in detail " If you make a hyperlink with those words and the hyperlink goes to an <ask the user> report where you answer the question then you can direct the user to go where you want."
- Am I creating a new "Rich Text" Formula field named "Flyer Request Form"

Code with my report qid:

var text URL = URLRoot() & "db/" & Dbid() & "?a=q&qid=190&v0=" & [Survey_Name];

var text Words = [Survey_Name];

"<a href=" & $URL & ">" & $Words & "</a>"

What do I do with this field?

------------------------------
Brian Dunk
------------------------------

MarkShnier__You

Qrew Legend

2 years ago

This field will be your Group by on the Summary report instead of the current field which is [Survey_Form]. Now I guess I left something out of my example because in fact you need three different URLs to drill into.

var text FlyerURL = URLRoot() & "db/" & dbid() & "?a=q&qid=97&v0=" & [Survey Name];

var text ProjectURL = URLRoot() & "db/" & dbid() & "?a=q&qid=98&v0=" & [Survey Name];

var text RepURL = URLRoot() & "db/" & dbid() & "?a=q&qid=99&v0=" & [Survey Name];

var text URL = IF(

Begins([Survey_Name], "Flyer"), $FlyerURL,

Begins([Survey_Name], "Project"), $ProjectURL,

Begins([Survey_Name], "Rep"), $RepURL);

var text Words = [Survey_Name];

"<a href=" & $URL & ">" & $Words & "</a>"

So you will need to create three <ask the user> reports which have have dummied in a qid 97, 98 and 99 which have the correct fields for each type of Survey Form.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

BrianDunk
Qrew Cadet
2 years ago
I assume the beginning of the first three lines of code should be "var text" not "var tex"?

------------------------------
Brian Dunk
------------------------------
- MarkShnier__You
  Qrew Legend
  2 years ago
  Yes. Now corrected.
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - BrianDunk
    Qrew Cadet
    2 years ago
    Ok, so I am doing something wrong as far as linking the summary report to the <ask the user> report. When I click on the "Flyer Request Form" link in the summary report I am still getting the default fields for the Drilldown report. Here is what I have.
    
    I have an <ask the user> report called "Flyer Request Form". If you simply click on the report link on the left you get the report and are asked "Show entry records where Survey_Name is equal to:
    
    I have a field called "Summary_Report_Links" that is a Formula-Rich Text field with the following code: (190 is the correct report qid)
    
    var Text FlyerURL = URLRoot() & "db/" & Dbid() & "?a=q&qid=190&v0=" & [Survey_Name];
    
    var Text ProjectURL = URLRoot() & "db/" & Dbid() & "?a=q&qid=98&v0=" & [Survey_Name];
    
    var Text RepURL = URLRoot() & "db/" & Dbid() & "?a=q&qid=99&v0=" & [Survey_Name];
    
    var text URL = If(
    
    Begins([Survey_Name], "Flyer"), $FlyerURL,
    
    Begins([Survey_Name], "Project"), $ProjectURL,
    
    Begins([Survey_Name], "Rep"), $RepURL);
    
    var text Words = [Survey_Name];
    
    "<a href=" & $URL & ">" & $Words & "</a>"
    
    I think I am missing a step in connecting something.
    
    Thanks again for the help on this.
    
    Brian
    
    ------------------------------
    Brian Dunk
    ------------------------------