Solved

SharePoint Form & Submit Options

Posted on 2013-07-01
3
390 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
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
CloudedTurtle earned 500 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now