InfoPath Dev

Hi - I think to a certain extent you do need to repeat your base data, because that is just the way list items are structured. Each row has to stand on its own, and the list form can only submit to a single list. In your attached template, I only see one view, and don't see any preceding-sibling formatting. Is the template you attached your ...

 For your fields that will be different for each record, drag the repeating group from the schema (you will need to show the advanced view in your data source task pane) onto the form - put all the fields you want to have with unique data in there. For the fields that will be the same, you can also drag the repeating group, and add the ...

Hi Franciele, There is no limit to the number of rules. I am guessing that it is the number of promoted columns. For best performance, you'll want to use two techniques: 1) use calculated values to reduce overhead - you can do this by putting each text control in a section (within the cell) and then copy the section and paste it right ...

Awesome Hilary this helps alright, thanks! So it's a one column SharePoint list to hold the stages 1-> 12 for example. Then in the form Stages field entries set the filter exactly as you have, selecting the correct field that holds the values form the external list, preceding-sibling::Status[1] = ...

I found a solution to grabbing the data, based on what Hilary mentioned in her last post. It involves creating helper fields in the repeating table of the secondary data source. In the repeating table of the secondary data source create duplicate fields for all of the columns of your data and call them M[FieldName] or whatever makes the most ...

My sample didn't work for you? There is a sample form attached to my earlier post with a complete formula - if you have trouble implementing it in your form, just attach a copy of your form to a reply and I'll help you out.

Thanks, I thought it would be possible. I've run into those errors on another form, hasn't been an issue so far. I'm having a problem get a function to work and I'm not sure if it's me being stupid, or I'm asking it to do something it can't. I've set up a repeating table that shows "Field Office" which ...

 Hi. I don't know if I am doing this correctly but I have a form with a repeating section that I am trying to save to a sharepoint list. I have a non repeating section in the same form and I need each entry of the repeating section to inherit all fields of the non repeating section.  I am using this formula ...

 Yes, this is pretty close! The behavior of the rule works differently in preview vs. in the browser however. :(  In preview the total updates as you add or subtract line items from the list. In the browser, the total only changes when a line is added. If you add in 10 lines, then start deleting them, the total will stay at 10 ...

So - this is on the Totals view? You want each category to display only one time? That would be a preceding-sibling condition - hide if category = preceding-sibling category. d:Category = preceding-sibling::d:SharePointListItem_RW/d:Category is the expression I'd try. Then for your sum formula - probably something like this (for each of your ...