General

Re: Send email to original form submitter

Hilary Stoupa — Mon, 09 Dec 2019 18:35:54 GMT

I think you might have been trying to open the file from the link, instead of downloading and right clicking. Can you find the calculated value control InfoPath designer? Add that to a form view. For the value, in the formula editor, click the button for inserting functions. Find the user name function and select it.

Re: Send email to original form submitter

PWCSNE — Mon, 09 Dec 2019 18:30:57 GMT

I use SharePoint Online and it cant connect to a server for your form. Any chance you could do a couple of screenshots of the settings?

Re: Send email to original form submitter

Hilary Stoupa — Mon, 09 Dec 2019 18:12:43 GMT

Here is form with just a calculated value with the userName() function. If you are using browser forms, you need to publish to the browser to test. Save the attached file locally. Right click the saved file and select Design to open in design mode.

Re: Send email to original form submitter

PWCSNE — Mon, 09 Dec 2019 18:00:46 GMT

Can you please provide me with an example?

Re: Send email to original form submitter

Hilary Stoupa — Mon, 09 Dec 2019 17:44:25 GMT

I'd put a calculated value on the form and set its value to the userName() function. If this is a browser form, publish and check the value in the browser. If this is a filler form, you should be able to just preview. The formula suggested here depends on what is returned.

Re: Send email to original form submitter

PWCSNE — Mon, 09 Dec 2019 17:37:24 GMT

I tried this and it fails. Do you know of any other ways to do this?

Re: Send email to original form submitter

Hilary Stoupa — Thu, 07 Jan 2016 15:38:31 GMT

Sure - use substring-after(CreatedBy, "i:-0#.f| membership |"), selecting the "CreatedBy" field using the field picker. :)

Send email to original form submitter

illegal_operation — Thu, 07 Jan 2016 03:46:37 GMT

I have a form, where users go in and make fill in the first part of the form.

It's submitted to a form library, and another user will approve the request by checking the box and saving.

What I would like to do next is have the form then do is email the original person who first submitted the form, an email. I thought I could create a secondary connection, and connect to the list and the 'created by' field to get the person's email.

It almost works, but in SharePoint the field has additional data.

Looks something like

i:-0#.f| membership | <<Then the email is here>>

Is there a way to strip off the bolded part and just maintain the email address?

I'm trying to make this as automated as possible, so a user doesnt' have to enter their email address.

Or is there another way to go about sending the original person an email?

This is a browser based form too.