Guest link

Unknown

Guest link

Unknown

[font=Roboto, Arial, Helvetica, sans-serif]Hi, w[/font][font=Roboto, Arial, Helvetica, sans-serif]e have a flow that sends out a guest link. Is there any table in decisions that stores the email to whom this guest link was sent? If so, where can I get that information from the database?[/font]

Unknown

Unfortunately, Assignment entities created for guest sessions do not retain the assignees email address. They are saved in the local DB as assigned to GUEST. So in order to pull the email from the assignment in other flows, you can create a new Entity to hold the data.

Once youve created your entity, you can use one of its fields to store the email address used for the guest assignment. Next, in the Add Task steps properties go to On Step Run, set Step Start Flow Type to Private, and create a new flow. Inside of your new on step run flow, add an input for your guest assignees email address and go to User Defined Types>Entities>(your extension) and drag a Create step into the flow. Set the steps mapping to Build Data and map in your guests email address.

Since youve created a new entity, Decisions created a DB table for it. The tables name can be found by clicking Edit Defined Data Structure from the entitys context menu. Here is an example query that will work with this setup: 

select guest_email as Guest Email from dbo.YOURNEWTYPE

Defined queries in Decisions can be used as steps inside of the flow designer and these steps can be dynamic if you use parameters in your queries.