-
I kept searching and found in another blog the answer I needed. In the blog I found how to reference a particular row in a repeating table based on a condition.
In the GL amount expression box data source, I used sum(/my:myFields/my:group1/my:group2[my:category = "entertainment"]/my:amount)
Thank you Matt Faus!
-
I am starting with the InfoPath Expense Report template. I have added a section at the bottom of the form, that has a GL entry for every category that can be chosen in the Itemized Expenses section. What would be the easiest way to get the total of the amounts for each "category" chosen in the Itemized Expenses ...
-
How I would approach this is add a field to your table, called include or display or hide, etc. I would probably make it a boolean but sometimes an integer is nice so that you can calculate how many are excluded, say if equal to 1 is exclude, these could be summed and subtracted from the total records.
This would act as a flag to include or ...
-
I have a form in development in IP 2003.
Based on an email address, I search a SQL table and populate a dozen fields.
I do this by setting the default values on each field based on a match on the email fields
When I open the form, I am getting inconsistent results. Sometimes the fields are populated and sometimes ...
-
This is an example of database mapping with nested tables. See Database Mapping for more information.
-
This is an example of a table in SQL that is used as a secondary table for shredding from a form.
-
This is a sample data source with a repeating group.
-
In general, the left side of the Database Map section deals with the target database schema, and the right side deals with the XML schema. Either type in the name of the table or press the browse button to open the Database schema task pane. To insert a name from the database schema task pane, simply double-click on it. The ...
-
I hope this is in the right place... and not a repeat...
But anyway, I have this repeating table all set up, with values and such in it. Since I can't exactly describe what's in the table without breaking policy, I'm going to use an example:
So this table consists of payrolls for employees, listing off how much they make and the ...
-
Adam,
Thank you for your help!! I never tried the signing a section, and that allows me to attach an image. Awesome! Now to make this more dummy proof, can I add a button to the form that would initialize the signing wizard? and afterward send an email? if so what would that code be? Thanks again for your ...