Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "actions"

How to have Action triggers once, but not on all Record Edits?

Publication date: August 8, 2018

Hello,

Anyway to prevent “Actions” to run only once and from re-triggering after a record has been edited? I have trigger for when a File field is “not empty.” Anytime that record is edited, the Action gets runs again if a file has already been uploaded.

Is there a way or Condition that only triggers if “on change” or something like that? I also tried an extra validation field in the Action conditions (yes/no) but since its value is saved it is only useful for the initial edit.

1) Anyway to run Actions once per-record or prevent from running
2) Anyway to reset a form field to a value – regardless of what was saved in the record?

Workflow to help: Person X submits initial form → Person Y receives notice from Allow End-User Edits Notification, and uploads a file to that record via Edit Records → Action is triggered by the file being uploaded to the record and email sent to Person Z

Help please - web page query form + display record

Publication date: August 14, 2018

I have created a simple (test) Orders database using your system.
Now I want to create a form on my website where a customer can enter an order number and order date, then they can view the details of their order on the same web page or a different web page on my site.

Please can you tell me how to do this.

Thank you

Marcia Levinson
marcia@vitalityforbusiness.com

How to enable the "allow end user edit database records" feature

Publication date: August 15, 2018

Please, see below how to enable the “allow end user edit database records” feature.

1) Go to the Customize & Integrate menu.

2) Open the Database tab.

3) In the Actions menu select the Allow web user to edit database records item.





Hope it helps!

How to remove all records

Publication date: August 15, 2018

To remove all records from the database go to the Records menu and find the button Delete all records under ‘Actions’ DropDown.
Please, see the screenshot below:


records

Cascade

Publication date: August 16, 2018

I have created a form in which a representative has to fill in a field. This document will be mailed to the manager who will evaluate the application/request. If he decides to give it a ‘go’ by filling in/submitting a second field, the third person will be informed by mail. This person will complete the form with necessary data. In my example I have created three forms ( representative, manager and administration).

What people may see in the form:
——————————————————————-
representative ==> field 1
manager ==> field 1 and 2
administration ==> field 1 and 2 and 3

First I have created a form “administration” in which the three fields are available.
Secondly I have made a clone of form administration (name = “manager”), removed field 3. The data are submitted to form “administration”.
Finally I have made a clone of form manager (name=“representative”) and have removed field 2. The data are submitted to form “manager”.

I don’t know if this setup is allowed or is ok for use. It doesn’t work since it is not submitting data tot the main table (“administration”).

I find it strange that after setup I loose the possibility in the second table “manager” on advanced settings, it doesn’t react anymore.

Can I receive some help please?

thx,

Stefaan

Limit Date Acceptance on a Form

Publication date: August 16, 2018

I have a form for Leave where the blokes fill in their first day off work and their anticipated return to work date. How would I generate a pop up message and stop the form processing if they entered a date between a black out period?

In other words if I want to say in May no leave every year. Regardless of when they apply between 1st of May and 31st of May the form wont process and pops a warning which I can customise to say no leave during this period?