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 wou...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- [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__YouYou 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
------------------------------- 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
------------------------------
