Forum Discussion
MarkShnier__You
Qrew Champion
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
------------------------------
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
------------------------------
PhilipRivard
5 years agoQrew Member
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
------------------------------
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
------------------------------
- MarkShnier__You5 years agoQrew ChampionHmm, not sure I have more to suggest.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- PhilipRivard5 years agoQrew MemberThanks a lot for your input. Much appreciated. I will post back If I find a solution.
------------------------------
Philip Rivard
------------------------------