InfoPath Dev

if I leave the lookup lists as is, will the copied list bring the DCs and look-ups in the form? or will a new DC and filter/queries be required?

I have a few lists that are connected by look-ups and data connections and I'm debating on a radical change. If I make a copy of this list will all the formulas/filters/queries that are in the InfoPath form break on this new "test list"? Thanks

so rather than filter the formulas which I cant seem to do, I've create a calculated column that takes the status and returns a yes/no for cancelled. then i added a button on the form to query for status, put rules on the button to set the query field value to "active" and a query rule. so cancelled shows up in the counts and ...

Hi Hilary, I'm trying to apply a filter to some formulas that I have inside my repeating table, but I'm coming up empty-handed. I've tried filtering inside the formula, outside of it, rules on the table and using query fields, but nothing I've tried works. In the table that returns from the Call-up list I would like to not include ...

thanks! So from what I can tell this returned data in a repeating section/table can't be sorted by me. Is the current sort looking at ID number? or does this come from the current view (sort) on the list? but I'm thinking I could highlight items in the returned data if I use a formatting rule?

This feels like a noob question so I'll ask it here. What is the difference between a repeating section and table? Specifically when used to display information from a SharePoint list on an InfoPath form. Thanks

well i can say I got it to work, but I can't figure out why. I have the rule trigger when SO_Number is Blank, number is not one of the fields that gets copied. with the rule like this when I add a new item, it copies the values I want from the previous section, to new and old entries alike. opens perfectly to view or edit. thanks again for ...

that was exactly what I needed, thank you!! I'm doing some more testing but having the trigger as ID = Blank seems to be the answer :) EDIT: Although this means I have to save an item before I can add sections into the repeating table, because the ID is blank before it gets saved.

Something strange is happening to the items with this rule in place. it seems like I can add items to the Sharepoint list no problem, but when I open an item up, all the fields get cleared. If I click on edit, there is nothing there and if I save it, it saves them blank.

In my repeating table I have 9 of 13 fields being copied to the new record. I'm planning on 9 actions on one rule, but I was thinking, is 9 rules with one action each better?