Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

TOGGLE TO ANOTHER REPORT

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
------------------------------
reports and charts
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    3 years ago
    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
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      Works great....
      Now, let's a formula that makes it a green button that says 'READY TO SAND"...?

      Thank you!

      ------------------------------
      BuildPro
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        3 years ago
        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
        ------------------------------