Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

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

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 ca...
Ask about Quickbase functionality
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
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! 
 
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    8 years ago
    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.