Discussions

 View Only
  • 1.  Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 15:18
    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
    ------------------------------


  • 2.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 15:21
    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
    ------------------------------



  • 3.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 15:25
    [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
    ------------------------------



  • 4.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 15:29
    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
    ------------------------------



  • 5.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 16:00
    Thanks Mark for your method.

    It seems I can now see all the information but it sills on 1 line. Is there a way to show it on 2 lines ?



    ------------------------------
    Philip Rivard
    ------------------------------



  • 6.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 17:28
    Hmm, not sure I have more to suggest.

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



  • 7.  RE: Return Carriage on Graphic Report Pop-ups...

    Posted 10-29-2019 18:06
    Thanks a lot for your input. Much appreciated. I will post back If I find a solution.

    ------------------------------
    Philip Rivard
    ------------------------------