Skip to main content
Question

Date Validation in multi line text field on Save

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.
    This topic has been closed for replies.

    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
    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.
    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. 
    You should be able to find data validation under Advanced Settings for each respective table.
    Terms & ConditionsAccessibility statement