Colorized List Formula
I currently have a text formula that creates a list that looks like this: List("\n",ToText( [Field 1])&" "&"Width", ToText([Field 2])&" "&"Length", ToText([Field 3])&" "&"Depth") I want this li...
Forum Discussion
The \n is a newline character, which works for regular formulas. Once you check the "allow some HTML" you now need to use the HTML new line character. I just tested in a dummy app to confirm this works:
"<span style=\"color:red;font-weight:bold;\">" & List("<br />",[Field1] & " Width",[Field2] & " Length",[Field3] & " Depth") & "</span>
"<span style=\"color:red;font-weight:bold;\">" & List("<br />",[Field1] & " Width",[Field2] & " Length",[Field3] & " Depth") & "</span>
- Works perfectly! thank you!
- nice.. It works :)
- What if I don't want a field to show unless there's a selection made?
- If you post your code we can adjust it.
- Ok, I'm just starting to build it, but it's used on multiple forms, so there are times when I don't want some selections to appear. Here is what I have so far, and it's working:
"<span style=\"color:red;font-weight:bold;\">" & List("<br />"," Final Determination: "&[Pass/Fail],"Reason: "&[Reason for Determination],"Inspector: "&[Inspector]) & "</span> - No problem, just wrap it with an IF statement
IF([ some field is not blank ] ....,
"<span style=\"color:red;font-weight:bold;\">" & List("<br />"," Final Determination: "&[Pass/Fail],"Reason: "&[Reason for Determination],"Inspector: "&[Inspector]) & "</span>"
) - Can you use the code I provided for the example? I'm not sure what you mean. Every field should be wrapped in an if statement, or wrap the whole thing?
Thank you! - Just one IF to wrap the whole thing, but you need to define the conditions where you do want the button to show.
- Button? There's no button. I'm just trying to create a dynamic list that consolidate information from different forms from the same table. If I only use one 'IF', then is it only going to respond to the first rule that is true? I want every field where data has been entered to display. Here is the code:
List("<br />",
"Request: "&[Request],
"Description: "&[Customer Selection],
"Dealer AA#: "&[Dealer Auction Access ID],
"Rep AA#: "&[Rep Auction Access ID],
"Gov't ID (Last 4): "&[Last 4 of SS#],
"Question: "&[Type of Sales Inquiry],
"Report Requested: "&[Report Type],
"Transport Type: "&,
"# of Vehicles: "&[Number of Vehicles],
"Purpose: "&[Purpose],
"Sale Date: "&[Sale Date to Run],
"Requests: "&[Special Instructions],
"Recon: "&[Recon Services],
"VIN(s): "&[VINs (Last 6)],
"Recent Note: "&[Recent Note],
"Purchased: "&[Purchased],
"Vehicle: "&[Vehicle Details],
"Claim: "&[Claim],
"Major Component: "&[Major Components],
"Vehicle History Issue: "&[Vehicle History Issues],
"Other Issue: "&[Other Issues],
"Final Determination: " &"<span style=\"color:red;font-weight:bold;\">"&[Pass/Fail] & "</span>",
"Add Title: "&[Reason for Determination],
"Add Title: "&[Inspector]) - try this
List("<br />",
IF(Trim([Request])<>"", "Request: "&[Request],
IF(Trim([Customer Selection])<>'', "Description: "&[Customer Selection],
IF(Trim([Dealer Auction Access ID]<>"", "Dealer AA#: "&[Dealer Auction Access ID],
etc
