Discussions

 View Only
Expand all | Collapse all

TOGGLE TO ANOTHER REPORT

  • 1.  TOGGLE TO ANOTHER REPORT

    Posted 05-14-2022 15:01
    Is there a way to put "Toggle to next report" button to toggle to another report? Or...create a field on 1st report to toggle to another report?

    For example:
    READY TO HANG REPORT to go to
    READY TO SAND REPORT

    ------------------------------
    BuildPro
    ------------------------------


  • 2.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-16-2022 08:17
    You could create a button in a formula rich text field and put that field in the report.  It would look a little clunky, but it can be done.

    Something like this would work:

    var text reportAddress = "report url";

    "<a href=" & $reportAddress & ">READY TO SAND REPORT</a>"

    ------------------------------
    Paul Peterson
    ------------------------------



  • 3.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-18-2022 15:35
    Works great....
    Now, let's a formula that makes it a green button that says 'READY TO SAND"...?

    Thank you!

    ------------------------------
    BuildPro
    ------------------------------



  • 4.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-18-2022 16:41
    You can try something like this:

    var text bgcolor = "#26945d";
    var text txtcolor = "white";
    var text word = "READY TO SAND";
    var text url = "report url";
    var text style = "style=\"text-decoration: none; background:" & $bgcolor &
    "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor &
    "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

    You can tweak the bgcolor as you like.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 5.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-18-2022 18:33


    ------------------------------
    BuildPro
    ------------------------------



  • 6.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-18-2022 18:40
    Changed formula, but no button.

    var text bgcolor = "#26945d";
    var text txtcolor = "white";
    var text word = "GO TO ASSIGN FINISHER RPT";
    var text reportAddress = "bdsdmyt7n?a=q&qid=544";
    var text style = "style=\"text-decoration: none; background:" & $bgcolor &

    "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor &
    "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

    "<a href=" & $reportAddress & ">GO TO ASSIGN FINISHER RPT</a>"

    ------------------------------
    BuildPro
    ------------------------------



  • 7.  RE: TOGGLE TO ANOTHER REPORT

    Posted 05-19-2022 07:55
    I left out the most important part, sorry:

    "<a " & $style & " href=" & $URL & " target=_blank>" & $word & "</a>"

    ------------------------------
    Paul Peterson
    ------------------------------



  • 8.  RE: TOGGLE TO ANOTHER REPORT

    Posted 06-25-2022 15:26
    Where does this go in the formula?
    "<a " & $style & " href=" & $URL & " target=_blank>" & $word & "</a>"

    var text reportAddress = "bdsdmyt7n?a=q&qid=544";

    var text bgcolor = "#26945d";
    var text txtcolor = "white";
    var text word = "READY TO SAND";
    var text url = "report url";
    var text style = "style=\"text-decoration: none; background:" & $bgcolor &
    "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor &
    "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

    "<a href=" & $reportAddress & ">GO TO ASSIGN FINISHER RPT</a>"

    ------------------------------
    BuildPro
    ------------------------------



  • 9.  RE: TOGGLE TO ANOTHER REPORT

    Posted 06-25-2022 18:39
    Not tested but try this

    var text reportAddress = "bdsdmyt7n?a=q&qid=544";

    var text bgcolor = "#26945d";
    var text txtcolor = "white";
    var text word = "Go To Assigned Finisher Report ";
    var text url = "bdsdmyt7n?a=q&qid=544";
    var text style = "style=\"text-decoration: none; background:" & $bgcolor &
    "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor &
    "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

    "<a " & $style & " href=" & $URL & ">" & $word & "</a>"

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



  • 10.  RE: TOGGLE TO ANOTHER REPORT

    Posted 06-27-2022 08:48
    Mark is correct with the placement of the anchor tag

    ------------------------------
    Paul Peterson
    ------------------------------



  • 11.  RE: TOGGLE TO ANOTHER REPORT

    Posted 07-03-2022 13:29


    ------------------------------
    BuildPro
    ------------------------------



  • 12.  RE: TOGGLE TO ANOTHER REPORT

    Posted 07-03-2022 13:46
    I was able to get it to work. thank you

    ------------------------------
    BuildPro
    ------------------------------