Triggering Email from Confluence with data from multiple forms using Confiforms IFTT rules

[Karthikeyan Devi]

Hi Friends,

I have 2 forms in my confluence page, 1st form contains the basic details of the User and the 2nd form contains the access for various applications.

For Example:

Form 1 has the following details

                 Emp Name, EMP ID, EMP Email

Form 2  has the following details

                 EMP ID, App Name, Access Level (Read), Access Level (write)

Form 2 is used in Form 1 as "SMART MULTI ROW"

Now, I want to send email to the user when the table is updated after providing the access to the user

When tried I am getting 1 email for Form1 data and another email for Form 2 Data.

Can someone help me to trigger only one email which has the info from both the forms.

[Alex Medved _ConfiForms_]

You can set up a "Send email", ConfiForms IFTTT macro to send an email

However, I am not sure I understand WHEN do you want to send an email?

When exactly an email should be sent?

[Karthikeyan Devi]

As i mentioned in the request that ?I have 2 confiforms to manage the data.

First Confiform is used to take in the request from the user for Application Access

Second Confiform is used to update the application name and the level of access provided to user.

So, the email should be triggered when the second confiform is submitted and a record is created.

Also, I want my email to have the Data from firms confiform and second confiform

Below is the Example:

Confiform 1

User Name : Will Smith

User ID : WS01

Email: Will_smith@nobody.com

Confiform 2 

USER ID: WS01                               USER ID: WS01

APP NAME : Jira                             APP NAME : Confluence

Access Level: Admin                      Access Level: Admin

Email to be triggered with below information upon onCreated event is triggered in the Form 2

User Name: Will Smith

User ID: WS01

Email: Will_smith@nobody.com

APP NAME : Jira, Confluence

Access Level:  Admin, Admin

[Alex Medved _ConfiForms_]

I do understand that you have 2 forms, no need to repeat that and I do understand that you use smart multi-row to enter data into the second from, while submitting the form1

What is unclear is when to send an email - for each row in the form 2 or when the form 1 is submitted and there should be just one email and it should include the data from the form 1 and from the form 2

Now I understand that the email should be sent when form 1 is submitted, so put the ConfiForms IFTTT to send and email into the form 1

You will be able to access APP NAME and Access Level through the smart multi-row field.

Tell me the field names for the app name and access level, as well as the name of the smart multi row field and I will putthe expressions that you will need to put to render the values for:

APP NAME : Jira, Confluence

Access Level:  Admin, Admin

[Karthikeyan Devi]

Hi @Alex Medved _ConfiForms_ 

As i mentioned earlier I have 2 forms and form 2 is an integral part of form 1 using smart multi row.

I wanted to trigger the email with all the Fields from Form 1 and Form2 when the Registration Form is submitted and my IFTT is placed inside the Form 1

Below are the fields per form:

Form 1: 

Username

UserID

Form 2:

AppName

AccLevel

[Alex Medved _ConfiForms_]

Ok, and what is the problem? IFTTT is in the right place. Just put the ConfiForms Field macros inside it’s body for the field values you want to send

[Karthikeyan Devi]

Problem is that it's fetching the Form one fields only, for the form 2 fields it's not included in the email

I even tried this

[Entry.fom1name.fieldname]

[Entry.form2name.fieldname]

This also does not include form2 field

[Karthikeyan Devi]

Below is the Confiforms structure

Below is the Data after user raise a request

Below is the Email Received

Please help me to trigger email upon the Registration form is submitted and email should have the all the data in the following format;

Username : Karthikeyan Devi (TS)

UserID: venlp8

Application Access : Jira, Admin Access

                                 Confluence, Admin Access

[Alex Medved _ConfiForms_]

In "UserDetails" form you have a "UserAccessLevel" field (defintion) - so put this (via ConfiForms Field) instead of these in the IFTTT macro body

[Alex Medved _ConfiForms_]

All you have to do is this