How to highlight a text field when they don't have data entry

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
Can I highlight some text fields when there are no data entry? I know I can highlight a formula filed with syntax. But Can a text field be highlighted? 

Such as, "category" is a formula field. I can add a syntax, IF(Trim([category])="", "pink")

But, "part number" and "phase" are text fields. Sometimes, people may forget to input data. I hope they can be highlighted as a reminder. 

Is it possible? Thank you very much!

 
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,266 Points 5k badge 2x thumb
Hi Ning,

There is not a way to highlight a text field using a formula or function natively in Quick Base. It is possible to make a field required though, so it cannot be left blank. The record will not be able to be saved unless the fields are filled in. Using form rules it is also possible to make a field required only under a specific set of circumstances. Such as Phase is required when Project Type is Planning, etc. Otherwise you can also make a formula field next to it that gives them a message or warning to prompt the user that the manual entry field is needed. I hope these suggestions are helpful Ning.
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Thank you so much! That solve my question regarding this highlight issue. I think I will make them as must fill fields. Thanks!
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Hi Eva, 

I added a new filed "check data input". Is there a formula to make it show "not completed entry" if any field of "name", "supplier", "part number", "location" is empty? 


Thank you! 
 
Photo of Dan

Dan

  • 1,180 Points 1k badge 2x thumb
Try something like this:
if(
[Name]="" or
[Supplier]="" or
[Part Number]="" or
[Location]="",
"Not Completed Entry"
)
You could get a bit fancier and have it list out which values are missing, as well.
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
It works! Thank you very much!
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
New Question. 

What if my input field is a multiple select field. It says the mismatch of textlist and text. 

Thank you. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
you can convert your field to text like this

ToText([my Multi-select field])
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Thanks again!