If you have the external user enter their email address on the sign out form,

then use the new data lookup control with a data source / data connection to retrive the sharepoint list item using the email address as a where filter on the data lookup.

Other than email you might have a registration code, or some other identifier.

Hi, thanks for the suggestion. I think I understand what you mean.  So I need to create a separate sign-out form which the user is redirected to after submitting the sign-in form?

The user then needs to enter their email address again on the sign-out form and then follow your instructions from there using the data lookup control to retrieve the SP list item I want to update with a sign-out date/time?

Thanks,

Linda

Linda,

you could try a solution with using a query string parameter.

You might still need two forms, a sign in and a sign out.

(or try with one form but with two pages: a sign in and a sign out page and more complex rules logic in the form and conditional logic in the workflow

Updated: doesnt look like I can use pages, use groups instead where visibility can be set by a rule)

The assumption is that after the sign in the external person is sent an email with a sign out link and uses that link to do the sign out.

After the sharepoint list item is generated in your sign in workflow, you will have a unique ID.

I would probably want to generate a guid or use the workflow instance ID as the identifier, that way the sign out URL is not predictable.

This ID could be saved into a new column in your sharepoint list for query later on.

Check out the first step by step example to see how you can access a query string:

https://help.nintex.com/en-US/nwc/Content/Designer/FormsRules.htm

Once the sign out form is submitted you can use the variable to query for the sharepoint list item and then update it.

You could still potentially use the new data lookup control on the form for the external user to confirm their sign in time.

Thanks so much for your help - your suggestion got me on the right track and it's working now! :smileyvery-happy:

Hi Gavin,

I'm struggling with a Data Lookup on my NWC form now.  I have a data lookup field for ''Site'' and in the configuration of the data source I have added both the ''Site'' field and also a "Manager Email" field which I want to use to send an email in my workflow. How do I get the Manager Email field into a Variable so I can use it for the email?

Linda