Re: Calculate an InfoPath form value based upon a SPList that's date sensitive.

MittyMuffikins — Tue, 15 Apr 2014 14:45:25 GMT

Does anyone have any ideas on how to do this?

Calculate an InfoPath form value based upon a SPList that's date sensitive.

MittyMuffikins — Tue, 18 Mar 2014 19:11:02 GMT

Hi Everyone,

I cannot tell you how glad this forum exists.

I’ve got an issue and it’s probably been asked before but I cannot find a good representation of it when I search.

I have a expense request form that deals with mileage. I have a SPList that stores Begin_Date, End_Date and Rate_Per_Mile. The list will be updated by the person who is responsible for the information.

In my form I have a Date field and a Miles field in a repeating table. I want the reimbursement amount to find the right row with the right Rate_Per_Mile and calculate the amount. I tired it by adding a secondary data connection and no matter what I put in for the date on the expense request, I get the first row and I’m not sure what I’m doing wrong.

Any help would be greatly appreciated.

Thanks.

Newbie Questions

Re: Calculate an InfoPath form value based upon a SPList that's date sensitive.

Calculate an InfoPath form value based upon a SPList that's date sensitive.