Forum Discussion

PhilipRivard's avatar
PhilipRivard
Qrew Member
6 years ago

Return Carriage on Graphic Report Pop-ups...

Hello All,

Is there a way to add a return carriage in the Formula to be able to show every information when my mouse pass over it.

I'm using the Formula to concatenate multiples fields and I would like to act on how they appears during the mouse over.

Let me know if I'm not clear. Thanks !



------------------------------
Philip Rivard
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Do you have a current formula you can post?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • PhilipRivard's avatar
      PhilipRivard
      Qrew Member
      6 years ago
      [BATCHNO] & " | " & [Batch - Production Variety - Production Cultivar Name]
      & " | " & [Harvest Date 1] & " | Day: " & ToDays([Batch - Real_Production_Time]) & " | "
      & "Rafts Qty:" &[TOT_RAFTS] & " | Yields"

      This is the formula that I've wrote in a Line and Bar Graphic Report ( Section Options).

      Thanks.

      ------------------------------
      Philip Rivard
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        You can use the List function to separate non null values with a separator,

        so  cleaner way to write your formula would have been.
        List((" | ",
        [BATCHNO],
        [Batch - Production Variety - Production Cultivar Name],
        [Harvest Date 1],
        ToDays([Batch - Real_Production_Time]),
        "Rafts Qty:" & [TOT_RAFTS],
         "Yields")

        the formula does not have to be written vertically, but that is how I do it for readability and avoiding syntax errors.

        If you want to have a carriage return instead of the pipe, use a \n as the separator.

        List("\n",
        [BATCHNO],
        [Batch - Production Variety - Production Cultivar Name],
        [Harvest Date 1],
        ToDays([Batch - Real_Production_Time]),
        "Rafts Qty:" & [TOT_RAFTS],
         "Yields")


        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------