If you are referring to the data validation for saving the code, then that isn't the issue. My issue is that whenever I change a target date to a date less than today and save the record, that's when the message pops.
I think a big part of my issue is I don't really understand the Quickbase formula concept. Is it java some places, qbase native others, and URL driven in even others? Are the API's the best way to work with the data programmatically?
I'm a network engineer who's been frustrated for years that I can do anything I want in access quickly and easily, using VBA, but it doesn't scale. My hope is I can translate that experience to quickbase and finally have a place to build internal DB apps quickly and precisely that will be usable across the organization.
------------------------------
Brandon Clark
------------------------------
Original Message:
Sent: 09-09-2019 16:47
From: Mark Shnier (YQC)
Subject: Help With Formula
The Advanced Properties for the table has a Data Validation Rule loaded which causes an error message and blocks the save. The way a data validation rule works, is that it will only allow the save if the error calculates to blank.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
Original Message:
Sent: 09-09-2019 16:27
From: Brandon Clark
Subject: Help With Formula
If(
//If the target date is greater than completion date and the Completion date is equal to ""
[Status] = "Open" and
[Target Date] < Today()and
IsNull([Completion Date]),
// set the Status to Past Due
"Past Due",
//Otherwise
null)
If the condition is not met, there appears to be no issues. If the condition is met, the error is:
Unable to save changes
Custom data rule failed:
1)Past Due
Any help is appreciated
------------------------------
Brandon Clark
------------------------------