Newbie Questions

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Tue, 12 Jul 2016 11:44:57 GMT

Glad you figured it out. Sorry I was away.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Mon, 11 Jul 2016 12:41:34 GMT

Good Morning!

It is Monday morning and I took a fresh look at my issue with hiding a section...it seems the check box properties was showing the test box as TEXT and not TEXT (Boolean)...this corrected my issue.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Fri, 08 Jul 2016 20:28:08 GMT

I am having an issue hiding one of my sections. I am setting it up just like you instructed, I have multiple sections that I have formatted to do this; however, this one section, when completing the condition for Hide does not show FALSE in the drop down. Doesn't show TRUE either. I replaced the check box, closed the program and reopened it, and tried multiple times but it would not appear. I typed in FALSE but it added quotes that I could not take out, and the section is showing on Preview. I compared the other sections' Rules and have done them all the same.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Wed, 06 Jul 2016 20:56:00 GMT

You will want to use a secondary data connection. You will want to connect that secondary data connection to a sharepoint list where you have all your selections.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Wed, 06 Jul 2016 20:36:57 GMT

Good Day!

I have a drop down list of job positions and would like to copy and paste them into a drop down menu but cannot seem to find a way...it only allows for one entry at a time, correct? Or is there another way to get a large list in a drop down menu?

thank you!

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Fri, 01 Jul 2016 14:19:21 GMT

I neglected to mention when I put the Custom pattern in the Condition for the "difference" field rule it changed this: difference does not match pattern Custom Pattern: -{0,1}\d+ to "-0"

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Fri, 01 Jul 2016 14:05:15 GMT

Thank you, that worked, except it calculates like yours. If I took from the 1st to the 5th off, that should be 5 days paid vacation, but it calculates 4 days....I get the subtraction is actually 4 but the actual days off are 5. Any fix to this?

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Fri, 01 Jul 2016 13:54:50 GMT

The "." means you are picking the same field you are putting the rule on. When you pick a field you pick difference.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Fri, 01 Jul 2016 13:39:24 GMT

Good Day K5Optima!

In reviewing the code from the link you sent me, you do not show this rule in your "difference" field:

Add the following Rule to the difference field:
Action: Set a field's value
Field: .
Value: 0

with the following Condition on the Rule:
difference does not match pattern Custom Pattern: -{0,1}\d+

When I attempted to fill the Field in with "." it will not type or paste....you must pick a field....how do I get the "." to go into the field.

When actually filling in the dates on your example that you sent, I filled in from Aug. 1st to Aug. 5th and it calculated 4 days, but it should be 5. Any reason you left the "difference" field Rule out?

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Thu, 30 Jun 2016 17:50:12 GMT

Here is where I grabbed the code and setup the rules. http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Thu, 30 Jun 2016 17:26:57 GMT

thank you for that keyboard shortcut...I should use them more often...I used the copy shortcut and was able to copy your code which worked well. However...I am doing something wrong in the "difference" block as it remains at "0" when I put in dates.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Thu, 30 Jun 2016 16:15:00 GMT

Do control V to paste.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Thu, 30 Jun 2016 14:44:10 GMT

This is what I have been attempting to do, however, when I right click, no window appears for me to Paste...nothing appears...I have the code in a Word Document and copied it, saw it in the Clipboard....???

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

K5Optima — Thu, 30 Jun 2016 14:34:57 GMT

If you go to the rule then action and click the fx button next to value you can paste the code. You need to make sure when you paste the code the field names match the fields in your form. If you haven't changed the names that I did you should be fine.

Re: Calculating a Total sum of repeating table where repeating table row does not show row total

Annie1234 — Thu, 30 Jun 2016 14:30:17 GMT

Good DayK5Optima!

I have been moving along and made errors and corrected errors and now my form is coming along nicely. With all the changes I made, I lost the Date Difference Rule and attempted to copy and past it from your example you sent me, but the whole code does not appear and it will not let me copy it. I found the code on Google and attempted to copy and past it after adjusting it to look like yours, but I am not allowed to past it in the function. What am I missing here? I can't believe I will have to type this whole code in there...HELP PLEASE?