Using this Conditional actions, you can automate some actions in the database.

When you enter certain data into the form, you can send E-mail and SMS notifications, Update the record, Show messages and Redirect user to web pages.

These actions can be used and combined with each other at the same time.

Here is just a few 'Conditional actions' usage examples:

 

• Send Email/SMS when order status changes
• Upade record
• Show predefined message depending from the user's choice on form. I.e. 'Thanks John for ordering Phone!', when user selected to order Phone
• Redirect user to another web-page. For example to Samsung page if ordered Samsung device and to Apple site if ordered iPhone
• Do not send data if criteria match. For example, if your criteria specifies the date range in which you do not want to accept input. For example, show message 'No vacations in August' if user selected August as a vacation month.

 

The Actions menu in Form builder:

 

Adding conditional actions:

 

Creating conditional action:

In order to create Conditional action you have to:

 

 

• Choose criteria using the form similar to Search form or the one you use in Conditional Formatting. Please, notice that there is no Edit for criteria. So you have to carefully define your criteria or you'll need to create another action.
• Enter name
• Choose when to perform action. It can be done when form submitted and when record updated
• You can activate 'Do not submit data to table if criteria matches' option
• Choose which action to perform. You can: send Email/SMS, show message and redirect to any web page

 

Once you created your 'Conditional action' you have to open it for editing again.

Because you need to setup your Email/SMS or message templates. Or enter web-page for redirect.

Update Record option:

Create following criteria - Client is Texas Montango LTD.

Edit the action:

If Client is Texas Montango LTD., then update the record in the following columns:

Using the cross icon, you can add more record columns.

The result in the table:

 

Please, login to QuintaDB to be able to post comments