Date Validation in multi line text field on Save

Question

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.

quickbasecoachd · Answer

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

adeebalgadban · Answer

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.

vinayakpavaskar · Answer

Thanks for prompt reply, But I&nbsp; 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.&nbsp;

quickbasecoachd · Answer

You should be able to find data validation under Advanced Settings for each respective table.

adeebalgadban · Answer

The method is IOL (Dan's image on load). you can google it or search the QB community forum

Forum Discussion

Date Validation in multi line text field on Save

Related Content

Using multi select field in pipelines

Multi-File Upload

Summary report w/multi-select field

Find and Replace Field Values

Multi-select field