-
Hi DMBach and welcome,
I don't recommend the code you attached because it concatenates the values. Certainly, you don't need it since you can just use an InfoPath rule and eval(eval(concat(...))) to do the same thing without code.
What I do recommend is to insert the values into a separate "selected" table and then sort that ...
-
Hi IceThatJaw and thanks for posting,
While SQL datatypes are not the same as XML datatypes (obviously, InfoPath uses the latter), your SOAP ore REST Web service will be returning XML. So, for a dropdown, you just have a structure like this:
<listgroup>
<item>foo</item>
<item>bar</item>
</itemgroup>
Yes, ...
-
Hi W and thanks for posting,
Microsoft has prescriptive guidance about the library and list view thresholds (~5000) but it's only strictly enforced if you use item level permissions. In other words, you can have a form library that has 50,000 items so long as you don't have item-level permissions.
OK, so let's say you are going to ...
-
Hi again,
First of all, why are you moving to InfoPath? Is it because it supports XML and can easily connect to Web services? If so, good. Now, regarding "coding considerations", InfoPath validates the form using XML constraints and validation rules, so you don't need code for that. What you will need code for is doing things that ...
-
Hi Perceptus,
You should be able to just add a rule that changes the fields under the Query node and then queries the data source.
-
Hi Jason_han and welcome,
The InfoPath data is stored in XML so exporting to Excel and editing will probably not place the data in the right format for your business process. Why are you using InfoPath in the first place? To create an e-form that automates your business process, right? Excel is not an e-form editor and doesn't ...
-
Hi Syd and thanks for posting!
I don't know the answer to your question, but one possible workaround would be to just convert your form to regular XML and map that to SQL using a Web service (such as DBXL). You'll have more control over your form's data that way. However, I realize that's a major change though.
So, some ...
-
Hi Moe.Vafaei,
Have you tried just selecting the form library and adding the workflow to that?
Just wondering,
-
Hi Shrout1,
I'm assuming your repeating table would have two ID fields. One will get auto-generated when the row is inserted. You can use qRules GuidGen feature for that. GUIDs are better than row IDs since they will migrate across systems as your data moves. Then, define a second field called "Manager" which gets the ID ...
-
Hi LGentile11 and welcome!
Yes, you can create a table with three columns of data and then merge the columns into one cell in the view and replace the fields with a button that has a calculated value set to the concatenation of said columns. Clicking on the button sets a yes-no "selected" field (4th column) and that field can be used to ...