First of all, thanks for very useful post.
It works very good, but I have just a little lack.
The structure of my secundary dataconnection is like that:
My formula is:
eval(eval(AdmDiagnosis[ClinicalPriorityDesc != "Secundario"]; 'concat(ns1:Code, "~", ns1:Description, "¬")'); "..")
xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("GetAdmittingDiagnosis")/dfs:myFields/dfs:dataFields/ns1:GetAdmittingDiagnosisResponse/ns1:GetAdmittingDiagnosisResult/ns1:AdmDiagnosis[ns1:ClinicalPriorityDesc != "Secundario"], 'concat(ns1:Code, "~", ns1:Description, "¬")'), "..")
This formual works perfect, but if I try the equal filter
[ClinicalPriorityDesc = "Secundario"]
This error raised:
Reference to undeclared namespace prefix: 'ns1'.
Error occurred during a call to property or method 'Eval'."
I workaround this issue using the not equal comparision instead the equal, but I'm curious if there is a way to fix that...
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)
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.
does not work with people picker sp 2010
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 :
I would like to see the checked item from field1 in field2, ';' seperated.
all help appreciatied :)
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-send-to-group (Person/Group Picker)
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\", "")
first of all hi!.i have a forma and a people list.
pc:Person (repeating group)
i want so send emails to several DisplayName and cannot make it work :(
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 ?
Does anybody besides me thinks that InfoPath is not the great tool they promote?
Exactly what I needed. Thanks Bunch!!!
I really admire you for your good answer
tanx a lot
It worked for me. I used my secondary data source instead of "person" and I used "." (current field value) instead of "my:email". Thanks
Solved it with this formula
eval(eval(Person, 'concat(concat(substring-after(pc:AccountId, "\"), "@domain.com"), ";")'), "..")
I am facing a weird issue and do not know how to solve. Please help.
I am using Infopath and I have one multi-selection listbox with secondary data connection with total 4 columns. There are ID, Title, Email Address, Description.
The listbox is displaying Title value.
Purpose: user need to check the listbox and decided which listbox to select. Once tick, the eval formula will look up Email Address column and send email out. This is the formula - eval(eval(Email, 'concat(., ";")'), "..")
Question: why the email display without check any check box?
Expectation: User should check the box then email address only show in email To list
I have a master/detail repeating table in my form, and one of fields is "EmailAddress" which shows customer's email address. I created a submit button and put the "EmailAddress" field to "TO" object. When I tested it, the submit button only would return the first row of emailaddress from the repeating table, but not the rest of it.. Even thought I put the XML code like this: current()/dfs:dataFields/d:vw_HZLeadLists/@EmailAddress
It still just return the first record of emailaddress... Could you give me some ideas? Thanks a lot!
Thank you very much! It was a lot of help