Newbie Questions

Re: Promoting fields in repeating table

warrtalon — Sun, 15 Nov 2009 20:12:59 GMT

You don't have to copy data to show it in another view. You just copy the controls. The data is defined by the field itself, but you can have as many controls showing that data as you want.

However, if you need that data in a different part of your data schema, then you'll need to copy it, but I don't think that's what you're asking.

Re: Promoting fields in repeating table

ramii — Sun, 15 Nov 2009 19:37:51 GMT

Thanks Warrtalon for your quick reply.

Is there any way I can create a New View on the Form itself which may have tabular structure, so that on clicking on any button on our current view will copy all the data into separate fields on the New View, where I can just select all those columns I can copy them all?

Ramii

Re: Promoting fields in repeating table

warrtalon — Sun, 15 Nov 2009 19:14:00 GMT

You can't. That's a weakness of InfoPath and SharePoint - it is unfortunately not addressed in 2010 either. Luckily, Qdabra (the folks who run this site) have developed their own qRule that helps us do this, and it is part of the 2.0 suite that is soon to release. I have tested it and confirmed that it works on IP/SP 2007 (both rich client and browser) and in IP/SP2010 (browser-only for now).

The other option is to use Qdabra's DBXL tool, which then leverages SQL as a back-end and is more powerful.

Promoting fields in repeating table

ramii — Sun, 15 Nov 2009 18:35:09 GMT

Hi all,

I am having problem with promoting fields in repeating table, thereby exporting them to excel or atleast able to copy them onto spreadsheet.

I have tried using the Eval function eval(eval(group2, 'concat(my:field2, ";", concat(my:field3, ";", concat(my:field4, ";")))'), "..").

It works for me. I am able to append all those columns in one string separated by semi-colons. Now the question is how I will be able to

extract each fields separately from those. If I publish my browser-enabled form into a Form Library.

Data sources are like

myFields

group1 --non repeating

group2 -- repeating

field1 -- expression box ( which we are not looking to promote)

field2 -- Number

field3 -- Decimal ( Amount...)

field4 -- Text

I took anothe field TEST on the Form and I am getting results like 11111;23434;text;22222;4535345;textagain;33333;23423;textagain;

Any help is appreciated.

Thanks,

Ramii