Email Submit "To" line (loops in formulas)

re: Email Submit "To" line (loops in formulas)

melih — Thu, 02 May 2013 11:35:21 GMT

It worked for me. I used my secondary data source instead of "person" and I used "." (current field value) instead of "my:email". Thanks

re: Email Submit "To" line (loops in formulas)

tanx a lot — Mon, 21 Jan 2013 13:02:17 GMT

hi scott

I really admire you for your good answer

tanx a lot

re: Email Submit "To" line (loops in formulas)

Niraj — Fri, 12 Oct 2012 16:35:46 GMT

Exactly what I needed. Thanks Bunch!!!

re: Email Submit "To" line (loops in formulas)

Anonymous — Thu, 16 Aug 2012 21:22:40 GMT

Does anybody besides me thinks that InfoPath is not the great tool they promote?

re: Email Submit "To" line (loops in formulas)

asdy — Tue, 20 Dec 2011 17:53:21 GMT

I am having a form with different sections and the momment the user hits the submit button I need each section in this form to be sent to different e-mails, I mean If I am having 3 sections in the form I need each of these 3 sections to be sent to 3 different e-mails. Any ideas how can I achieve this goal ?

re: Email Submit "To" line (loops in formulas)

i cant seem to make this work. — Tue, 02 Aug 2011 19:47:06 GMT

first of all hi!.i have a forma and a people list.

Structure:

myFields

Group

pc:Person (repeating group)

DisplayName

AccountId

AccountType

i want so send emails to several DisplayName and cannot make it work :(

re: Email Submit "To" line (loops in formulas)

Mahesh Kunadia — Mon, 25 Jul 2011 17:48:24 GMT

I have been looking for answer to send email to multiple people using InfoPath function ""Person/Group Picker" and data connection.

Finally, using this formula and adding some tricks I was able to do it.

My Data Source Looks like this:

Notification-group

Notification-send-to

Notification-send-to-group (Person/Group Picker)

pc:Person

DisplayName

AccountId

AccountType

Set default value for "Notification-send-to"

eval(eval(Person, 'concat(pc:AccountId, ";")'), "..")

Setup data connection for email and enter following formula to remove domain name in “To” using “fx”

translate(Notification-send-to, "DOMAIN NAME\", "")

Thank you,

re: Email Submit "To" line (loops in formulas)

Jan — Mon, 20 Jun 2011 14:21:25 GMT

Hi, thanks for this post, I managed to solve one of my problems :).

I was trying to get te same result from a multiple-selection listbox, but can't get it to work.

This is the datastructure :

group1

repeating field1

field2

I would like to see the checked item from field1 in field2, ';' seperated.

all help appreciatied :)

Jan

re: Email Submit "To" line (loops in formulas)

usman — Thu, 16 Jun 2011 17:37:59 GMT

does not work with people picker sp 2010

re: Email Submit "To" line (loops in formulas)

Laurel — Fri, 15 Apr 2011 20:42:39 GMT

I am receiving the same issue with the formula: "../my:RepeatingTable/my:NomineesHidden/my:Person" does not point to a valid location path of a field or group.

I first tried the formula in the main body of the post. When that didn't work, I copied the formula that was given to someone else and adjusted the group names to fit my .xsn. Here is the XPath formula:

substring(xdMath:Eval(xdMath:Eval(../my:RepeatingTable/my:NomineesHidden/my:Person, 'concat(my:AccountID, ";")'), ".."), 1, string-length(xdMath:Eval(xdMath:Eval(../my:RepeatingTable/my:NomineesHidden/my:Person, 'concat(my:AccountID, ";")'), "..")) - 1)

My data structure is this:

NomineeTopGroup (non-repeating Group)

RepeatingTable (repeating table)

NomineeHidden (non-repeating Group)

pc:Person (repeating person group)

display name (string)

accountid (string)

accounttype (string)

I have tried everything I can think of to fix the formula so that it recognizes the AccountID field, but I have failed.

I'd appreciate any help you could provide.