 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2006Repeating Table
I am an InfoPath newbie. I want to recreate a Word macro as an InfoPath form. I believe I need to create a repeating table that has 3 columns. The first column should automatically provide a sequential number, the second column should automatically provide a total number and the third column, a space for the user to type in a description. For example, 1 of 2 Box 1 containing correspondence 2 of 2 Box 2 containing photos Also, in the above example, if the second row is deleted, will the first row update the total to reflect the change, i.e., 1 of 1 Box 1 containing correspondence? Thanks in advance for your help and patience. Try this tutorial: http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb026 32966e8127 --- S.Y.M. Wong-A-Ton > I am an InfoPath newbie. > [quoted text clipped - 10 lines] > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > correspondence? Thanks in advance for your help and patience. Thanks for the response. I am able to get the first sequential number, but am still having difficulty getting the total number. I need the second column to automatically display a total number of rows, for example: 1 of 3 2 of 3 3 of 3 If the second row is deleted, the second column should change to: 1 of 2 2 of 2 Thanks in advance. > Try this tutorial: > http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb026 32966e8127 [quoted text clipped - 15 lines] > > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > > correspondence? Thanks in advance for your help and patience. You need to use a technique as I've described in one of my solutions (see http://enterprise-solutions.swits.net/infopath/avg-function-infopath.htm) for the second part of your scenario. If you used a normal text box instead of an expression box for the first field in your repeating table, you should be able to set a rule on it. If you haven't, change it to a text box. Having done that, add a new text field to the main node of your form (myFields) and call it "helperField". Then add two rules to the first field in the repeating table: The first rule should set the value of "helperField" to an empty string and the second rule should set the value of "helperField" to any text that's not an empty string, e.g. "calc". Then add a rule to "helperField" to set the value of the second field in your repeating table to count(field2), where "field2" is the second field in your repeating table. That should take care of the total number. --- S.Y.M. Wong-A-Ton > Thanks for the response. I am able to get the first sequential number, but > am still having difficulty getting the total number. I need the second [quoted text clipped - 30 lines] > > > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > > > correspondence? Thanks in advance for your help and patience. The total box works great, but my autogenerated row number no longer works when the expression box is changed to a text box. > You need to use a technique as I've described in one of my solutions (see > http://enterprise-solutions.swits.net/infopath/avg-function-infopath.htm) for [quoted text clipped - 47 lines] > > > > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > > > > correspondence? Thanks in advance for your help and patience. Strange... worked fine when I tried it... Did you use count(../preceding-sibling::my:Row) + 1 instead of position() as the Default Value for the first field? --- S.Y.M. Wong-A-Ton > The total box works great, but my autogenerated row number no longer works > when the expression box is changed to a text box. [quoted text clipped - 50 lines] > > > > > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > > > > > correspondence? Thanks in advance for your help and patience. S.Y.M. Wong-A-Ton, This worked out great! I had some weirdness happening with my repeating table. Once I fixed that, your instructions worked perfectly! Thanks, again! > Strange... worked fine when I tried it... > [quoted text clipped - 57 lines] > > > > > > update the total to reflect the change, i.e., 1 of 1 Box 1 containing > > > > > > correspondence? Thanks in advance for your help and patience. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.