Rules that fire when a record is opened or saved

QuickBase lets you trigger a role based on the state of the record being edited. You can choose to trigger the rule:

Operators for conditions based on the record's state

This table lists the operators available when you choose to base the condition on the record:

Operator Description

is opened

Triggers the rule immediately when the record is opened

is saved

Triggers the rule immediately after the user clicks Save. Note that, after the user clicks Save, QuickBase checks to ensure there are no errors on the form that will prevent the save. If, for instance, QuickBase discovers that some required fields have not been completed, QuickBase will execute your rule, but will not save the form.

is saved (after checking)

Triggers the rule after the user clicks Save AND after QuickBase has checked to ensure the form can be saved. only after QuickBase first checks to make sure that all required fields on the form have been completed correctly. If QuickBase determines the record can be saved, it executes the rule and then saves the record.

 

Additional operators for field values

When you write a rule that fires when the record is saved (before or after checking), QuickBase provides additional operators for conditions that are based on a field value.  These operators are:

Operator Description

has changed

Available only when the form also contains a rule that fires when the record is saved. Specifies that any change in the value of the field will trigger the rule. Learn more about rules that fire based on field values.

has been changed to

Available only when the form also contains a rule that fires when the record is saved. Specifies that the rule will be triggered when the field has been changed to a certain value. Learn more about rules that fire based on field values.

has been changed from

Available only when the form also contains a rule that fires when the record is saved. Specifies that the rule will be triggered when the field has been changed from a particular value to any other value. Learn more about rules that fire based on field values.

 

Note: These operators are not supported for List - User fields.

Related Topics

 

Return to top   

© 1999-2012 Intuit Inc. All rights reserved. Legal Notices.