Hello,
I am trying to put together a vacation request form that has a repeating table (based off of MS template "absence" request) that has a drop down list with the type of absence (vacation, sick day, etc), and I formatted the start and end dates to total the number of days in a total field. There is another table (non-repeating) that has the available number of days for each category (per the template) which I pull from a list on my SP site.
(bear with me) ; )
I have the "total" field from the above repeating section populate the "This Request" field in the availability table, which subtracts from the total number of days that were available, and populates the "new balance" field. I have a rule in the repeating section total that says "if [leave code] is equal to "Vacation", then set fields value [this request] = [total].
Now, here's the problem I can't wrap my head around. If someone adds ANOTHER vacation request, it populates the other field with THAT total. How do I get the sum of all the specific request types? Keep in mind, there could be various different request types in the same repeating table . . . for instance, 2 vacation days with various requested days, and a couple of floating holiday requests with different date ranges.
I hope that made some kind of sense, and I hope one of you brilliant developers can help me.