Microsoft InfoPath 2010
The official blog of the Microsoft InfoPath team

Don't settle for just one: Adding multiple default rows

Don't settle for just one: Adding multiple default rows

  • Comments 10
Since I realize not everyone has installed the Beta yet (you can do it!), I figure it's time for a trick everyone can play with, even those still using InfoPath 2003.
 
Starting with more than one row in a repeating table
You may want to do this if you have a form where you know everyone's going to fill out at least five rows, or maybe some people will even print our your form before typing in their answers (I never!). You might even want to have five rows exactly, and then disable adding or deleting rows (in Repeating Table properties), but still use a repeating table to get the data structure you want.
 
Regardless of your scenario, here's how to do it:
  1. Open the form in design mode
  2. Click Default Values on the Tools menu
  3. In the data source, select the group that's bound to the row of the repeating table
  4. Click the down arrow next to the group name
  5. Select "Add another row below"
 
 
You can even specify different values for the columns of each row using the bottom of that dialog. And of course this works for any repeating item in your data source, not just those bound to repeating tables.
 
Keyboard trick!
Save yourself a few clicks by typing the "Insert" key instead of using the menu. Each time you type "insert" it will add another row. Those two clicks per row can really add up when you have a lot of rows! If you type it a few too many times, you can also use the "Delete" key to remove the offending rows. 
 
Got your own tricks to share?
As usual, if you've got your own tips in this area, or a cool reason to use this trick, please leave us a comment for the team to see and the community to gain.
 
Enjoy,
ned
Leave a Comment
  • Please add 5 and 8 and type the answer here:
  • Post
  • InfoPath 2007 introduces a new control, the multi-select list box, for cases when you want to allow users...
  • InfoPath 2007 introduces a new flavor of the repeating section control - horizontal repeating section....
  • Thanks! I was looking all day to figure out how to do that!

  • I cant get this to work. Will not allow you to add a row. does not even seperate rows. Clearer claification

  • I don't even have the ability to access Default Values for the repeating table, which means I certainly don't have the ability to add a row - which I desperately need. Please help! using Infopath 2010 for a browser based form.

  • I see this is an old thresd, but what if I want to have 10.000 rows as default??? I can't sitt an klikk "Add...below" 9999 times...???

    Any ideas?

  • I cant add more then 6-7 rows, is it non? any solution?

  • In case of Infopath 2007 you can find this option under the data tab then default values. From there select the group and add as described above.

  • On InfoPath 2013 this is now under the Data tab on the ribbon if anyone had trouble finding it.

  • I've used this method of default values to keep Display Names and Numeric Values for our form's list boxes for about a year.  I've now run into an issue where I've added a few new rows to 3 of our repeating tables default values that show up perfectly when a new form is added to the library, however for existing forms in the library the new selections are not displayed in the list box but duplicates the initial default value of the display name and value fields in the fields pane. (for example, I added 3 new options to a list box's value table, and when an existing form is opened there are 4 instances of Option 1 in the list box, with the first being the correct option and 3 duplicate options at the bottom of the list.)

    I was advised to clear my InfoPath cache, which I did, but still having this weird behavior.  Any suggestions?

Page 1 of 1 (10 items)