?
Solved

SharePoint Form & Submit Options

Posted on 2013-07-01
3
Medium Priority
?
430 Views
Last Modified: 2013-07-03
Hi

Directly related to this post
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_28172317.html

How can I mix straight text "A new Request has been submitted" in the subject line of the Email Submit form to also include a value from one of the fields on the form?

So something like "A new Request has been submitted for %COMAPNYNAME%" Where %COMPANYNAME% is a field on the form?

Thanks
Mark
0
Comment
Question by:Mark Galvin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
CloudedTurtle earned 2000 total points
ID: 39293334
use the Concat() function in your email subject line.

so your value will look something like this:
Concat("A new Request has been submitted for ", <company name field>)

(definitely use the function builder for this though)

-CT
0
 
LVL 13

Author Comment

by:Mark Galvin
ID: 39296185
Hi

Thanks for the heads up.

Tried that. Using the function builder and when I try to verify this:
'concat("A New SharpOWL Request has been submitted " Company Name,) ' (note the "Company Name" field is generated by function builder, as perhere:
 using function builder
I get:
'Expected value type: ,

Actual value: name
concat("A New SharpOWL Request has been submitted " -->dfs:dataFields<--/my:SharePointListItem_RW/my:CompanyName,)' see error
Any ideas?

Thanks
Mark
0
 
LVL 13

Author Comment

by:Mark Galvin
ID: 39296200
Hi

Got it!!

It was the missing ',' after the plain text:
concat("A New SharpOWL Request has been submitted for", Company Name)

Now working!! See:
Got it!!
Thanks for all your help!!

Will award points in a few minutes!

thanks
Mark
1

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question