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 Pa...
Forum Discussion
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
------------------------------
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendQuick Base is best learned using native formulas and not APIs. APIs are more advanced and are likely not necessary for you to get a lot done.
If the record is not saving, then its either due to a form rule with an "Abort the Save Rule which would have been set on the form Rules - so in the form, or else a custom data validation rule which is set in the Advanced Properties for the table.
Your mission to create app quickly and easily with Quick Base is can definately be met by Quick Base and i would be happy to have a no charge conversation with you to show you some examples of what QuickBase can do.
I'm a QSP (QuickBase Solution Provider) who helps clients when they get stuck.
www.QuickBaseCoach.com mark.shnier@gmail.com
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
If the record is not saving, then its either due to a form rule with an "Abort the Save Rule which would have been set on the form Rules - so in the form, or else a custom data validation rule which is set in the Advanced Properties for the table.
Your mission to create app quickly and easily with Quick Base is can definately be met by Quick Base and i would be happy to have a no charge conversation with you to show you some examples of what QuickBase can do.
I'm a QSP (QuickBase Solution Provider) who helps clients when they get stuck.
www.QuickBaseCoach.com mark.shnier@gmail.com
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Thanks Mark. I'll shoot you an email.
------------------------------
Brandon Clark
------------------------------