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.commarkshnier2@gmail.com------------------------------
Original Message:
Sent: 10-29-2019 15:25
From: Philip Rivard
Subject: Return Carriage on Graphic Report Pop-ups...
[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
Original Message:
Sent: 10-29-2019 15:20
From: Mark Shnier (YQC)
Subject: Return Carriage on Graphic Report Pop-ups...
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
Original Message:
Sent: 10-29-2019 15:17
From: Philip Rivard
Subject: 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
------------------------------