Forum Discussion
AndrewFry
6 years agoQrew Assistant Captain
I think I understand the concept.
I create a list of warnings. Do I need to assign a name to that list of warnings to be able to properly reference it?
I partition those warnings out to various variables, such as WarningOne, WarningTwo, etc.
Those variables are then listed in the field to create columns and rows.
The part I am stuck on understanding is, where do I apply my IF statements in your suggestion?
The warnings are based upon different IF statements, to identify if a field is completed or not.
Would I simply list out all the IF statements such as:
var text Warnings=
List(",",
If(Trim([Client Name])="","Work Order Missing: Client,"),
If(Trim([Subdivision Name])="","Work Order Missing: Subdivision"),
etc,
etc,
etc,
If([Total # of Assignments Missing Notes]>0,"Assignment Missing: Assignment Notes")
Then do the following (???):
var text WarningOne = Part($Warnings, 1, ",");
var text WarningTwo = Part($Warnings, 2, ",");
etc
etc
etc
var text WarningTwentyfive = Part($Warnings,25,",");
var text WarningsHTML =
List("<br>"
List("," $WarningOne, $WarningTwo)
List("," $WarningThree, $WarningFour)
etc
etc
etc
List(",",$WarningTwentyfour, $WarningTwentyfive)
)
If($WarningsHTML <>"", "<font color=red>" & $WarningsHTML)
Did I understand you correctly?
As a matter of clarification for me, wouldn't the "List" function need a comma after the delimiter?
You have it written as: List("," $WarningOne, ........
Should it be: List(",", $WarningOne, ......
I keep getting an syntax error indicating a missing or expected comma.
------------------------------
Andrew
------------------------------
I create a list of warnings. Do I need to assign a name to that list of warnings to be able to properly reference it?
I partition those warnings out to various variables, such as WarningOne, WarningTwo, etc.
Those variables are then listed in the field to create columns and rows.
The part I am stuck on understanding is, where do I apply my IF statements in your suggestion?
The warnings are based upon different IF statements, to identify if a field is completed or not.
Would I simply list out all the IF statements such as:
var text Warnings=
List(",",
If(Trim([Client Name])="","Work Order Missing: Client,"),
If(Trim([Subdivision Name])="","Work Order Missing: Subdivision"),
etc,
etc,
etc,
If([Total # of Assignments Missing Notes]>0,"Assignment Missing: Assignment Notes")
Then do the following (???):
var text WarningOne = Part($Warnings, 1, ",");
var text WarningTwo = Part($Warnings, 2, ",");
etc
etc
etc
var text WarningTwentyfive = Part($Warnings,25,",");
var text WarningsHTML =
List("<br>"
List("," $WarningOne, $WarningTwo)
List("," $WarningThree, $WarningFour)
etc
etc
etc
List(",",$WarningTwentyfour, $WarningTwentyfive)
)
If($WarningsHTML <>"", "<font color=red>" & $WarningsHTML)
Did I understand you correctly?
As a matter of clarification for me, wouldn't the "List" function need a comma after the delimiter?
You have it written as: List("," $WarningOne, ........
Should it be: List(",", $WarningOne, ......
I keep getting an syntax error indicating a missing or expected comma.
------------------------------
Andrew
------------------------------
MarkShnier__You
Qrew Legend
6 years agoYes your understanding of what to do is exactly correct and yes, I was missing that comma after the delimiter in the List. When I answer questions here i don't have the helper of a Syntax editor and I'm trying to go fast :)
------------------------------
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
------------------------------
- AndrewFry6 years agoQrew Assistant CaptainNo worries. I understand. It would be helpful to have that syntax editor available.
Due to being new to all of this, I just wanted to make sure I was understanding you correctly.
I appreciate your input and assistance Mark. Thank you!
I am sure I will have many more questions as things progress. LOL.
------------------------------
Andrew
------------------------------