Discussions

Expand all | Collapse all

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

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

    Top
    Contributor
    Posted 04-27-2018 13:36
    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!

     


  • 2.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 04-30-2018 14:57
    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.


  • 3.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 04-30-2018 20:55
    Thank you so much! That solve my question regarding this highlight issue. I think I will make them as must fill fields. Thanks!


  • 4.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 05-03-2018 19:27
    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! 
     


  • 5.  RE: How to highlight a text field when they don't have data entry

    Posted 05-03-2018 19:30
    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.


  • 6.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 05-17-2018 12:48
    It works! Thank you very much!


  • 7.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 05-18-2018 13:20
    New Question. 

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

    Thank you. 


  • 8.  RE: How to highlight a text field when they don't have data entry

    Posted 05-18-2018 14:28
    you can convert your field to text like this

    ToText([my Multi-select field])


  • 9.  RE: How to highlight a text field when they don't have data entry

    Top
    Contributor
    Posted 05-18-2018 15:20
    Thanks again!