InfoPath Dev

As a newbie I think I am over my head a bit but all research is leading me to having to enter a double eval and concat to a repeating table so the data can be exported from a SharePoint list to Excel.

I have added a repeating table (tried to repeat the layout below) so the submitter would enter, for example, Camera (Item), Head Office (Centre), Admin (Area) all of which are selected from drop-down lists then additional items are added as required.

myFields

Bids

Table

Item

Centre

Area

I need the data to be displayed as such -

Camera, Head Office, Admin

Scanner, London, Finance

Mobile, Manchester, HR

From examples I have found so far have eval(eval(Table, 'concat(my:Item, ";")'), "..") but I have no idea if this is anywhere near correct and what to do with it.

Would appreciate any help (preferably in idiot speak).

Thanks

Karen

Perhaps there isn't a need for double eval here.  How about this:

- Create another repeating section control from your Table group.

- Inside the repeating section, add an expression box with this formula: concat(my:Item, ', ', my:Centre, ', ', my:Area)

That's it!