On "View" of a form. Can the background color of the entered data be changed? I am looking to one color if data is there and standard color if data was not entered.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Photo of Marc


  • 0 Points

Posted 4 years ago

  • 0
  • 1
No. That is not a feature of QuickBase.

An alternate suggestion would be to put up a warning message about missing data at the top of the page. Here is an example:


If(Trim([Invoice # (with the problem)])="","Missing Invoice #"),

If(Nz([Product Selection])=0,"Missing Product"),

If(Trim([Item #])="", "Missing Item #"),

If(Nz([Defect #])=0,"Missing Defect"),

If([$ Claim Dealer Total]=0,"Missing Claim $ Requested"),

If([Do you need a GR?]="","Missing \"Do you need a GR?\""),

If(Nz([Problem Area])=0,"Missing Problem Area"),

If([Problem Area / Total Order UM]="","Missing Problem Area U/M")