Custom Data Rules
Quick Base introduced custom data rules for app builders to create logic that can be applied anytime a user adds or updates data in a Quick Base table.
By using Quick Base formula language, you can set custom conditions and custom error messages in a table. So whether a user is updating rows via grid edit, updating fields in a form, or uploading new records from a spreadsheet, implementing custom data rules allows app admins to automatically validate data changes and ensure that everything is in the appropriate format.
Here are some instances where the custom data rule feature is available:
Where to Build Custom Data Rules for a Table
Things to remember when creating custom data rules in Quick Base are:
We have an application that tracks apartment buildings, leases and tenants and we want to create some rules around our leases table. Specifically, whenever one of our leasing agents forgets to input the status on the lease agreement. Our formula would look something like this:
Here is the result of what the error message would like if the changes were made via grid edit:
In addition to the above rule, say we also have a special promotion running on a particular unit and building where rent cannot exceed $2,500 per month. Our sample formula will combine both the original rule from above and our a new rule to look something like this:
Here is the result of what the error message would like if the changes were made in a form:
To learn more ways to customize your app in Quick Base, check out more articles here: Quick Base Knowledge Center
Author: Alex Skudrovskis (firstname.lastname@example.org)
Date Submitted: 4/04/19