Quick Base Discussions

Expand all | Collapse all

Date Validation in multi line text field on Save

  • 1.  Date Validation in multi line text field on Save

    Posted 04-18-2019 10:30
    I have a multi line text field where I record the course taken by an employee. I am maintaining the history of these dates. But since its a text field user is free to enter any text. On save I want to show an error message if the entered text is not valid date. Can someone please help me on this.


  • 2.  RE: Date Validation in multi line text field on Save

    Posted 04-18-2019 11:47
    Data validation is now a native feature.

    On the table settings look for Data Validation.

    Maybe a formula to calculate error message words or null. If they calculate to non null words, the save will be blocked and the message will display


  • 3.  RE: Date Validation in multi line text field on Save

    Posted 04-18-2019 13:40
    1) Data validation
    2) JavaScript
    3) cleaner solution (best practice) but more work:
    Create a change log table (change log text field) and use automation to record a date change when users modify the field. This way you keep the field looking better for reporting and also you can add more fields to track as needed.


  • 4.  RE: Date Validation in multi line text field on Save

    Posted 04-20-2019 19:01
    Thanks for prompt reply, But I  couldn't find the Data Validation in table settings. Also Can you please guide me on how can I use JavaScript in QuickBase. Any article would be helpful. 


  • 5.  RE: Date Validation in multi line text field on Save

    Posted 04-20-2019 23:34
    The method is IOL (Dan's image on load). you can google it or search the QB community forum


  • 6.  RE: Date Validation in multi line text field on Save

    Posted 04-22-2019 06:44
    Thanks I will give it a shot.


  • 7.  RE: Date Validation in multi line text field on Save

    Posted 04-20-2019 19:24
    You should be able to find data validation under Advanced Settings for each respective table.


  • 8.  RE: Date Validation in multi line text field on Save

    Posted 04-22-2019 06:44
    Thanks a lot, That helped.