@Fouad_H_Saad1
Here are the steps on how you can create such a functionality:
-
Set a DateTime type column. Name this column as i.e. [Start] and set an Initial Value of NOW().
-
Add a Change TimeStamp type column. Name this column as i.e. [End] and bind this column to track the change of your last field in the form with a value of NOW().
-
Add another DateTime type column. Name this column as i.e. [Sent] and leave its initial value as blank
-
Add an Action to your table with below properties:
{
**Action name:** Type a reasonable name
**For a record of this table:** Select your table that belongs to your form
**Do this:** Data: set the value of a column
**Set this column:** Select the [Sent] column
**To this value:** =NOW()
**Action icon:** Choose a suitable icon that you see fit
**Prominence:** Display prominently
}
- Add an Email Workflow Rule to this table with below properties:
{
**Rule name:** Give a reasonable name to your rule
**Target data:** Select your table that belongs to your form
**Update event:** UPDATES_ONLY
**Condition:** =AND(ISNOTBLANK([Sent]),[_THISROW_BEFORE].[Sent] <> [_THISROW_AFTER].[Sent])
}
After you launch the form to fill data, the very 1st DateTime column will record a DateTime value initially. When you enter the last data to your form, the Change TimeStamp column will capture a DateTime value too. When you save the form, you will notice the action button on the Detail view. When you press this button, it will record a DateTime value in the [Sent] column and as itโs an update action, it will trigger your email workflow.
LinkedIn
Twitter
