-
Very nice! This works perfectly when each field is identical, but it does not seek and destroy individual duplicate email addresses that are nested among different strings that are concat'd.
e.g.
works when field1="fred@email.com", and field2 also = "fred@email.com"
result: fred@email.com
but does not work ...
-
Hi, I don't know exactly what you want to do on you form, in my case when I select on a drop down wich is bind to a sharepoint list I set some RT value to my Infopath Field. So I set an "On Changed" event on my drop down field and I usesome code to populate my RT field.
-
Please give this a try
substring(eval(eval((EDG-EEEmail | EDG-MEEmail | EDG-DD1Email | EDG-PlasticsEmail | EDG-EETEmail | EDG-MTEmail | EDG-DD2Email | EDG-TWEmail)[. != ""][not(. = preceding::*)], 'concat("; ", .)'), ".."), 3, 10000)
That is, add [not(. = preceding::*)] after [. != ""]
-
Do you know the custom code you could use to do this? At work, I'm having issues even accessing the Script editor because it tries to tell me I don't have the programming part installed for InfoPath (which I do)... sometimes I can get it to bug and let me do it, ha...
I'm not totally sure I understand qRules entirely. ...
-
Hi Jimmy,
The single big form will ultimately be broken down into four smaller ones with some overlap of data collection between each. The larger form uses conditional formatting to hide some form elements depending upon options set on the opening page. Therefore, not all of the data fields are completed for each study and it's ...
-
Here is the current double eval formula:
substring(eval(eval((EDG-EEEmail | EDG-MEEmail | EDG-DD1Email | EDG-PlasticsEmail | EDG-EETEmail | EDG-MTEmail | EDG-DD2Email | EDG-TWEmail)[. != ""], 'concat("; ", .)'), ".."), 3, 10000)
Note: Each of the fields in this formula, may have multiple emails ...
-
Nope, I don't know of a codeless way to write to an XML file from an InfoPath form. Your title said XML file or SharePoint List, so I thought this woule be an acceptable solution?
-
Hi Patrick,
Thanks for given reply.
Actually, In my form having Listboxcontrol called name is 'DepartmentNames' this bind with sharpoint list. it is poplated data from list. The Listboxcontol data haing like IT Department, E-BusinessDepartment,Marketing Department like so on...
Now, These data i want to show in my Infopath ...
-
Hi Matias,
sorry, I don't quite understand. why are you "adding another data connection"? Are you using that to get the string value for error message? If so, why not just query the Web service if it fails. You can use another rule for that. Sorry, I don't quite understand your question though.
-
Hi Donna,
Curious that you should ask that question. We've been trying to get that exact same scenario to work for the last two weeks and we have been unsuccessful. We can't figure it out. If we do find a solution, we'll try to remember to post here.
Sorry!