As a follow-up to this question, the embedded grid edit report that shows up displays only 4 empty rows. We have use cases where the analyst needs to fill in 200+ rows and would like the ability to copy-paste that many rows into the embedded grid edit report.
See above empty report. So when I try to copy-paste more than 4 rows, only 4 rows of data sticks. This would make it very laborious to copy 200+ rows as it would have to be done 4 rows at a time.
Is there a work around for this?
Thanks!
Deepa
I have a solution we use but it is not great (but way better than 4 at a time).
We click on the very left cell (with no column heading) and drag and highlight the 4 rows, right click and say Insert Blank Rows. Now you have 8 rows. Do the exact same thing again with all 8 rows. Now you have 16. Once more gives you 32....and so on. You can somewhat quickly get yourself to to your number. You just want to be sure to have MORE rows than you need. And I would test to see if there are any quirks when you get up to a high number. We have only imported maybe 30 or 40 max, so I am not sure if anything funny happens with 200. Keep in mind when copy/pasting you need to use all mouse commands (dont try ctrl c/v on keyboard, it wont work) and use 'Paste Special'.
However, if you have that many rows, I would suggest trying to use the import function on the table home page. The trick will be the user will need to know to add a column with the related parent record ID....
