Qdabra qRules

Re: Use Qrules\copytable to populate richtext field in InfoPath 2007

Hilary Stoupa — Wed, 15 May 2013 18:51:00 GMT

You can just use the count function - in the formula editor, select that from the functions and then count the returned repeating group in your secondary data source.

Re: Use Qrules\copytable to populate richtext field in InfoPath 2007

wilfred.ball@torsdc.ca — Wed, 15 May 2013 14:02:31 GMT

Ernesto,

The Insert Method may work (more work, but possible). My solution has to be OOTB (no code) so a question: Having used the FilterOwssvr command to retrieve my source table, is there a property available that indicates the number of rows/records that have been returned? I need this to know how many rows to insert into the destination table.

Wilfred

Re: Use Qrules\copytable to populate richtext field in InfoPath 2007

ErnestoM — Wed, 15 May 2013 13:19:52 GMT

Hi Wilfred,

If the secondary data source contains all attributes, then the main data sources must also contain all attributes to allow CopyTable to work.

You might want to look at something like the method described in this tutorial, instead of using CopyTable.

http://www.infopathdev.com/files/folders/qrules/entry58577.aspx

Hope this helps!

Use Qrules\copytable to populate richtext field in InfoPath 2007

wilfred.ball@torsdc.ca — Wed, 15 May 2013 13:13:22 GMT

Hi,

I want to use the copytable command to populate a richtext field to populate fields a repeating table within my 'Main' data source. I find that if my destination table is a set of fields, I get the error 'The table row of the source and destination must contain the same number of elements and attributes.' I switched to a set of attributes and the copytable WORKS, BUT I cannot choose Rich Text as a data type, only Text.

Note, my source table is a xml secondary data source generated using the FilterOwssvr qRules command to filter rows.

The qRules user guide says 'Attributes and rich text can be copied' but I can't figure out how to make it work.

Wilfred