InfoPath Dev

OK, so the "MileageRate" field, the Drop Down list, was there as a test for me to get input from an external data source (my other SharePoint list that has the mileage rates) and to be reflected in the calculated value fields column named "Mileage Rate". This, I was able to get to work so that when a user would select a value ...

Sorry here's the screen shot of the error

Thank you soooooo much for helping with this Hillary. Unfortunately, it still isn't working. I removed the MileageRate field (because I just included this as an example) and updated the form to look like it's supposed to look and work. Now I'm getting the error when selecting With or Without car allowance buttons "only ...

Hi Hillary, I am just now getting back to this and wondered if you wouldn't mind helping me, again. I'm still having an issue getting the proper value to populate into the calculated value fields. I have a data source which has the values that I want to use and I can get the calculated values to populate correctly using a Drop Down List ...

Hi Hillary, sorry to bother you again and I really appreciate your help on this but I can't seem to get this to work. I see what you did and I think I understand what you mean but I can't get the mileage rate to change using a rule to query using external data. I tried setting that rule on the radio button field and the Calculated value ...

Asabir, yes I would like to pull data from another SharePoint list that the accounting group can update. Attached is a picture of the form. Thanks John

Hi Hillary, thanks for the quick reply. It would not vary by row and yes everything would be on one report with or without allowance. I have attached the form that I'm working with (hope that's OK) and also a screenshot of section I'm trying to make work. Thanks again, you're a great help! John

Thanks, but your directions are a little vague. Can you elaborate? Thanks, John ~Update So this is what I want to accomplish and sorry if I butcher the explanation: 1. I have a Expense report that I have a section of mileage for users to fill out. 2. We have 2 different mileage rates for those with or without a car allowance. 3. I want ...

Hello, I'm trying to pull data from an external data source to a text field. I see that (and have used) this can be accomplished with other controls like drop downs, combos, etc... but can I accomplish this using a text filed? Thanks in advance. John

Hello, I'm using InfoPath Designer 2013 and calculating a couple of fields to reflect a negative percentage and getting the dreaded NaN upon previewing and uploading to SharePoint. Using the formula ((field21 - field20) / (field20) * 100), all seems to work exactly how I need it to but when yo go to Submit I get the below ...