https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120342.aspxFri, 25 Jan 2019 19:44:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120342benefishall0https://www.infopathdev.com:443/forums/thread/120342.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120342OK, 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 from the drop down list, it would be reflected in the calculated value fields. But I don't want this. I would like to have radio buttons that specify with or without car allowance, have that pull from the same external data source as above and reflect that in the calculated value fields. I really hope I'm explaining this right and don't have your head spinning... :) Does that make sense?https://www.infopathdev.com:443/forums/thread/120341.aspxFri, 25 Jan 2019 18:40:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120341Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120341.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120341So - I don't understand why the MileageRate1 field, which is a true / false field, is being used in the repeating table... shouldn't the mileage rate in the repeating table (the calculated value) be bound to a number field? The field called "MileageRate" which I was guessing would be the actual rate, looks like it is a choice field - what are the choices for that field?https://www.infopathdev.com:443/forums/thread/120340.aspxFri, 25 Jan 2019 18:14:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120340benefishall0https://www.infopathdev.com:443/forums/thread/120340.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120340Sorry here's the screen shot of the errorhttps://www.infopathdev.com:443/forums/thread/120339.aspxFri, 25 Jan 2019 18:13:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120339benefishall0https://www.infopathdev.com:443/forums/thread/120339.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120339Thank 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 'true' or 'false' allowed" I attached the template for your review Thanks again, Johnhttps://www.infopathdev.com:443/forums/thread/120338.aspxFri, 25 Jan 2019 15:54:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120338Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120338.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120338Try this one. You don't need to query the list again - you are doing that when the form opens. I've got rules on MileageRate1 to set MileageRate - hopefully that is what you needed.https://www.infopathdev.com:443/forums/thread/120334.aspxThu, 24 Jan 2019 19:41:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120334benefishall0https://www.infopathdev.com:443/forums/thread/120334.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120334Hi 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 but not when I use an option button. I also have the rule setup where if the option button is equal to True to Query using that data connection. This works (kinda) but populates the fields in the Mileage Rate column with either "true" or "false" not the number from the external form. I have attached the form template to this post and the section is at the bottom of the form in the "Mileage" section. (With and W/O Car Allowance) Any help would be greatly appreciated.https://www.infopathdev.com:443/forums/thread/120205.aspxWed, 19 Dec 2018 16:50:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120205Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120205.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120205Once you have created a list, do you know how to add a data connection to that list to your form template? Under Data Connections, Add > then follow the prompts to add a list data connection. Once you have done that, save a copy of the form and attach it to a reply so I can help you with your rules.https://www.infopathdev.com:443/forums/thread/120201.aspxTue, 18 Dec 2018 15:18:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120201benefishall0https://www.infopathdev.com:443/forums/thread/120201.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120201Hi 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 field. I also have a list created with 2 separate columns (1 with Allowance and one without), no dice... Also, not quite sure what you mean by "attach a new copy of your form with the data connection added". Sorry total Newbie... :) And thanks again! Johnhttps://www.infopathdev.com:443/forums/thread/120196.aspxFri, 14 Dec 2018 22:43:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120196Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120196.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120196Ok - so this data isn't repeating, which means you'll need to add a rule to set each field, unfortunately.... If the Mileage Rate would be the same for every row - perhaps it would be better not to have a field for each entry? Just have one field with the value? You could display it in each row - just use a calculated value to show it to the user. Here's an update of your form showing what I mean. Save it locally, right click and select design to open in design mode. Next, as to the secondary data - add a list to your site with a single entry and two columns - one for mileage with allowance, and one for mileage without. Then add a data connection to your form that queries for data from that list. You can then just pick the right info when the radio button is selected in your form - if you need help, attach a new copy of your form with the data connection added. :)https://www.infopathdev.com:443/forums/thread/120188.aspxThu, 13 Dec 2018 17:40:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120188benefishall0https://www.infopathdev.com:443/forums/thread/120188.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120188Asabir, 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 Johnhttps://www.infopathdev.com:443/forums/thread/120187.aspxThu, 13 Dec 2018 17:37:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120187benefishall0https://www.infopathdev.com:443/forums/thread/120187.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120187Hi 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! Johnhttps://www.infopathdev.com:443/forums/thread/120183.aspxThu, 13 Dec 2018 15:49:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120183Asabir0https://www.infopathdev.com:443/forums/thread/120183.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120183to better understand the issue here, on the mileage section you want to get external data? where is external data required? do u have another list for the accounting group to update their info?https://www.infopathdev.com:443/forums/thread/120179.aspxThu, 13 Dec 2018 15:37:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120179Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120179.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120179Would this vary by row? Or is everything on a given report either with or without allowance? Can you put together a simple sample form showing what you are trying to do, and I can help you with the rules .... you can attach a sample form under the options tab in a reply.https://www.infopathdev.com:443/forums/thread/120177.aspxThu, 13 Dec 2018 13:20:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120177benefishall0https://www.infopathdev.com:443/forums/thread/120177.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120177Thanks, 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 to use radio buttons for users to click that would show either of the 2 rates for that column. (ex: click "Without Allowance" button and it populates 10 fields in that column w/ that rate) 4. I would like for the ladies in the accounting group to be able update the rates somewhere (easily) to reflect the rate change on this form. Hopefully this doesn't confuse too much. Thanks, Johnhttps://www.infopathdev.com:443/forums/thread/120174.aspxWed, 12 Dec 2018 19:56:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120174Asabir0https://www.infopathdev.com:443/forums/thread/120174.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120174Yes, It si possible by using Xpath on the properties.