-
I would add to your concat formula a substring function to truncate after 2 decimal places.
concat("If you pay within the next 10 days we grant you a discount of 5% ("; substring-before(invoice_discount, "." ); "."; substring-length(substring-after(invoice_discount, "."), 0, 2); "€).")
I think ...
-
Why did you choose to do this with c# code when it can be done within InfoPath?
Typically we at least setup the data connection and load the data from the web service into a secondary dom. Then use code or rules to move the data within the form.
We have some sample forms included in the Database Accelerator download. Qdabra Database ...
-
Just to clarify, you have a datebase based template with subtables?
Then you want to automate the insert of a repaeting subsection?
Instead of the user clicking insert new item you want to perform this action based on an event or programatically?
Is this correct?
-
Put the Hyperlink inside a section. Then you can use conditional formating to control the visibility of the section.
-
Under the options Tab when replying you can attach your XSN or any other files. Sample to look at might help.
-
Ok.
1 thing would be to double check detailID is 2 or has the proper value. I am assuming so but always a good thing to check when debugging.
I think what you need is the full name for the DetailID field. the ../../ is relative to the positino and for the filter you may need /dfs:myFields/my:DetailID although I think you may have one more ...
-
Can you post the text for the one that worked but set all rows to the same total?
In the lst filter line it would need the ../../ before my:FormData probably.
I am still confused on what exactly you are trying to do. Maybe you could give some more high level details.
The user gives some input, selects a row of information or something, and then ...
-
Ok, well at least you are making progress.
The key is the filter value for the target (1st occurenc) not what it is set to (2nd). I am guessing it is not always row 2 that you wish to update.
The second issue is that you need to use the complete field reference. It cannot interpret @AutoNumber and therefore the filter is unsuccessful. It ...
-
Hey Ed.
The problem you are running into is that for InfoPath's default functionality in regards to a database form to be enabled it must be created as a database type form initially.
The limitations are any secondary data connection to a database directly can only receive data and has no way of querying the data. It is all loaded and ...
-
Have you tried it yet?
I would think your filter would go at the /d:LaborSummary[RecordID = Field]/@NOW_ETC_HRS. I would be calculating the rowID that needs to be updated. Place that in a field or put the calculation in the filter are there.
Typically you will have to test a bit till you get it the way you need it.