Skip to main content
Question

Present field results in columns and rows

  • September 21, 2019
  • 0 replies
  • 41 views

I have a formula that checks a number of different summaries to ensure that all "required" fields are completed.

It lists the fields vertically if they are missing data.

However, the list is quite extensive and causes the form/row to be quite long at times.

Is there a way where instead of presenting each item in a single column with X number of rows, I can make the results populate into 2 or 3 columns by X number of rows?

My current formula (truncated) is this:

var text Exceptions =

List("<br>",

If(Trim([Client Name])="","Work Order Missing: Client"),
....
....
....

If([Total # of Assignments Missing Notes]>0,"Assignment Missing: Assignment Notes")
);

If(Trim($Exceptions)<>"","<font color=Blue><b>Below is a list of fields that are missing data to move the Work Order to an Active status:</b><font color=Red><br>"&$Exceptions)

Is there a way where instead of

"<b>",

where the break comes after every comma, I can make it come after every 2nd or 3rd comma?????

Also, kudos to Mark for helping me with the formula!




------------------------------
Andrew
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You can make a formula field to calculate your warning messages, but use a comma as a separator.

List(",",
etc

OK so now you have a comma separate list of warnings.

Then you can create say 20 formula varibles like this

var text WarningOne = Part($Warnings, 1, ",");
var text WarningTwo = Part($Warnings, 2, ",");
etc

Then  you can have a  formula to calculate the warnings, but since you want Rich text, go back to a <br> separator.  The formula below should list the warnings in two columns

var text WarningsHTML = 
List("<br>"
List("," $WarningOne, $WarningTwo)
List("," $WarningThree, $WarningFour)
etc
)

Then you can say

If($WarningsHTML <>"", "<font color=red>" & $WarningsHTML)


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