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

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.

Thank you so much! That solve my question regarding this highlight issue. I think I will make them as must fill fields. Thanks!

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! 
 

It works! Thank you very much!

New Question. 

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

Thank you. 

you can convert your field to text like this

ToText([my Multi-select field])

Thanks again!