-
You will need to use the eval function - if you look back at that sample form, you'll see it as a default in the Total field. Something like: sum(eval(group2, "my:Amount * my:Price"))
You use the field picker to select the repeating group, then hand type the XPath for the other two fields - attach a copy of your form if you ...
-
Hi - sorry, didn't get a chance today, will try tomorrow!
-
If you have the XSN, you can change the file extension from .XSN to .CAB and then look at the files - are there any .DLL or script files in there?
-
You can find more info here: https://support.office.com/en-us/article/Add-an-index-to-a-SharePoint-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0?ui=en-US&rs=en-US&ad=US
Basically, if you index the columns most often used for filters / queries you can improve performance. So, let's say you have a Project Number column and ...
-
Okay, I'll give it a try later today & let you know what I learn. :)
-
Is this a SharePoint List? Is the form customized in InfoPath or is the validation just on the list column? I ask because your formula looks like it might be for a SharePoint column, not InfoPath. :)
-
Yuck. I wonder if adding indexes to the list (under the list settings) would help?
-
Here's a modified copy of my default data form where I've changed the formula to set the serial number to handle for any number of digits after the dash. Instead of the "4" in the formula, you use the string-length of the substring after the "-".
-
Oh man, hadn't thought of that - yes, as a list form, non displayed items will be submitted. You'll need to add a workflow to remove anything where display = false, I think. I'll think on the serial number thing later today & see if I can come up with an option.
-
It is possible - but can be a little tricky. Since you are using a repeating table bound to the secondary data source, as long as you are willing to submit one row at a time (i.e. put a Save button in the repeating table) and as long as you aren't on Office 365 (which restricts some SharePoint web service data connections) you can use ...