Date Validation in multi line text field on Save

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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.
Photo of Vinayak Pavaskar

Vinayak Pavaskar

  • 120 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
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
Photo of QBAlchemist

QBAlchemist

  • 160 Points 100 badge 2x thumb
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.
Photo of Vinayak Pavaskar

Vinayak Pavaskar

  • 120 Points 100 badge 2x thumb
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. 
Photo of QBAlchemist

QBAlchemist

  • 160 Points 100 badge 2x thumb
The method is IOL (Dan's image on load). you can google it or search the QB community forum
Photo of Vinayak Pavaskar

Vinayak Pavaskar

  • 120 Points 100 badge 2x thumb
Thanks I will give it a shot.
You should be able to find data validation under Advanced Settings for each respective table.
Photo of Vinayak Pavaskar

Vinayak Pavaskar

  • 120 Points 100 badge 2x thumb
Thanks a lot, That helped.