Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Date Validation in multi line text field on Save
Vinayak Pavaskar
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 ...
QuickBaseCoach Dev./Training
04-18-2019 11:47
Data validation is now a native feature. On the table settings look for Data Validation. Maybe ...
Adeeb Algadban
04-18-2019 13:40
1) Data validation 2) JavaScript 3) cleaner solution (best practice) but more work: Create ...
Vinayak Pavaskar
04-20-2019 19:01
Thanks for prompt reply, But I couldn't find the Data Validation in table settings. Also Can you please ...
Adeeb Algadban
04-20-2019 23:34
The method is IOL (Dan's image on load). you can google it or search the QB community forum
Vinayak Pavaskar
04-22-2019 06:44
Thanks I will give it a shot.
QuickBaseCoach Dev./Training
04-20-2019 19:24
You should be able to find data validation under Advanced Settings for each respective table.
Vinayak Pavaskar
04-22-2019 06:44
Thanks a lot, That helped.
1.
Date Validation in multi line text field on Save
1
Like
Vinayak Pavaskar
Posted 04-18-2019 10:30
Reply
Reply Privately
Options Dropdown
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
0
Like
QuickBaseCoach Dev./Training
Posted 04-18-2019 11:47
Reply
Reply Privately
Options Dropdown
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
0
Like
Adeeb Algadban
Posted 04-18-2019 13:40
Reply
Reply Privately
Options Dropdown
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
0
Like
Vinayak Pavaskar
Posted 04-20-2019 19:01
Reply
Reply Privately
Options Dropdown
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
0
Like
Adeeb Algadban
Posted 04-20-2019 23:34
Reply
Reply Privately
Options Dropdown
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
0
Like
Vinayak Pavaskar
Posted 04-22-2019 06:44
Reply
Reply Privately
Options Dropdown
Thanks I will give it a shot.
7.
RE: Date Validation in multi line text field on Save
0
Like
QuickBaseCoach Dev./Training
Posted 04-20-2019 19:24
Reply
Reply Privately
Options Dropdown
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
0
Like
Vinayak Pavaskar
Posted 04-22-2019 06:44
Reply
Reply Privately
Options Dropdown
Thanks a lot, That helped.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic