InfoPath Dev

I am trying to modify an existing infopath form that contains repeating table container.User enters the details in the table and form is used by another program for processing. The current requirement is for user should be able to copy data from somewhere and directly paste into table. The user may copy data containing multiple rows and paste it.This source could be anywhere and also the user can still enter data manually row by row so a data connection is not feasible. But the data gets truncated with only first row getting entered in form as there is only one row present in the form. I found out this was the behavior after googling. Is there a work around for this. Like overwriting paste function using code? Thanks for any help.

You can copy and paste rows if the number of blank rows is equal to the number of rows you are copying.

 

Hi Patrick, The situation is such that only one row will be visible . And also the user should not be specifying a number of rows( If this is possible ,i could keep a text-box where user enter no of rows/cols from which i can generate table dynamically .) But this is also not possible.

If the rows and columns you were pasting were delimited (for example, comma-separated values), you could add rules with sub-string parsing to map the values out to a table but you would likely have to specify which rows you wanted to set. That can be done with a manifest.xsf manual modification (or you could use qRules SetValue).

If the values aren't delimited, you could switch them to a separate view that is one big table and just have them paste and click a button and then that button could copy the values from this "intermediate" table to the main one using the table trigger technique.

Granted, neither approach is a perfect solution. Let me know if you'd like a demo.

 

Hi Patrick, Thanks for response. I would very much like to know about second approach. Can you just give me a sample on how to do it or point me to right links? Also is this possible by editing existing template?