InfoPath Dev

You need to add default rows for this technique - which means making your best guess as to how many rows will be returned from your list. Under Data in the ribbon, defaults, you'll see this sample form has a number of rows already present. So - the difference between my form and yours is not the source of the data, but that my form has rows in ...

Hello Hilary, Thank you for your reply. Actually I want to do autofill like attachment. You create it before i found it. But this example read data from XML file. When you preview file XML lines autmatically create repeating table lines. This is perfect. I just want to same think but data not read from XML file data read from Sharepoint list. ...

Oh - I think maybe I'm misunderstanding something.... can you tell me more about how you want this to work? When the user selects stuff, it just .... disappears from the multi-select? Or do you have multiple multi-selects bound to the same field, in different sections or views or something?

I mean - I'd think the screenshot that shows the filtered entries showing up as selected, with their IDs implies that you are opening already filled out forms, with the data that is now filtered out already selected? I'm not sure how to handle for that..... perhaps the filter needs to be adjusted somehow to allow already selected items to ...

In the past, I've seen the following design pattern used: On submit rules, if your ticketing system ID field is blank, query the list (data connection can be set for returning just ID) that you intend to submit to. Then set the ticketing system ID field to a concat with the text you want and max(ID) from the queried data. I, personally, ...

Here's another pic, showing all the filter windows...

Thanks Hilary - that's mostly worked! However I'm still getting the entries within the not() coming through as their IDs. :/ (see attached image)

I should have mentioned there was a sample instead of just linking to Jimmy's formula that helped me! Glad you have things working.

Hilary - Many thanks this has sorted it...and sorry I didn't see your sample on the first reply. It was this one that did it for me. thanks again, Mike

Here's another sample - you just need a concat to do this..... Download the linked file, right click and select Design to open in design mode. From there you can preview and check it out.