Discussions

Expand all | Collapse all

Is it possible?: Minimum Characters Restriction on Fields

  • 1.  Is it possible?: Minimum Characters Restriction on Fields

    Posted 5 days ago
    I see where I can set a maximum number of characters restriction on a field. Is it possible to set a minimum restriction?



    ------------------------------
    Chelsea Carpenter
    ------------------------------


  • 2.  RE: Is it possible?: Minimum Characters Restriction on Fields

    Posted 5 days ago

    Yes, but not there. 


    You can enable Custom Data Rules in the Advanced Properties of the table and enter a formula like this one


    IF(
    Length([My Text field])> 0
    and
    Length([My Text field]) < 5,
    "You must enter at least 5 characters in the XYZ field")

    this formula would permit blank. 



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Is it possible?: Minimum Characters Restriction on Fields

    Posted 5 days ago
    Worked like a charm, thank you!

    ------------------------------
    Chelsea Carpenter
    ------------------------------