Solved

SharePoint Form & Submit Options

Posted on 2013-07-01
3
403 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

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
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…
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…

911 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

15 Experts available now in Live!

Get 1:1 Help Now