Repeating Table: Force all rows to have same value for one column - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Repeating Table: Force all rows to have same value for one column

Last post 03-17-2015 01:26 AM by Ayub Syed. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 11-17-2011 01:16 AM

    Repeating Table: Force all rows to have same value for one column

    Does anyone know a way to have all the rows of one column of a repeating table to always have the same value?

    Say the user changes the value in the first row for that column, then all the other cells in that column change to have the new value. (Preferably this will happen if a user changes any cell in the column, not just the one in the first row, but just the first row would be fine if that's all that's possible).

    I have access to both InfoPath 2007 and InfoPath 2010 so can use either. The form submits data to and receives data from an SQL Server database. Code is fine if this requires it.

  • 11-17-2011 07:58 AM In reply to

    Re: Repeating Table: Force all rows to have same value for one column

    I think the way I'd do this is by leveraging an XML secondary data source. Create an XML file with fields for each of the columns you want to be able to set. Then, in your main data source, you could set that field when you change a value in the field that is in the column - rules on the 2DS field populate the column. I've attached a simple sample form. Right click the link in the heading to this post, save the file locally, right click the saved file and open in design mode. From there you can preview.
    Hilary Stoupa

  • 11-18-2011 02:16 AM In reply to

    Re: Repeating Table: Force all rows to have same value for one column

    That's fantastic, thanks very much.

  • 01-14-2013 10:30 AM In reply to

    • AlexK
    • Top 200 Contributor
    • Joined on 12-31-2012
    • Posts 61

    Re: Repeating Table: Force all rows to have same value for one column

    I would like to do the same thing, but in my case I want the fields to lookup text from another SharePoint list. So in the field dropdown, whatever is selected once, all other repeated fields in that column take on that value. Any idea how to do this?
  • 01-14-2013 11:04 AM In reply to

    • AlexK
    • Top 200 Contributor
    • Joined on 12-31-2012
    • Posts 61

    Re: Repeating Table: Force all rows to have same value for one column

    I followed Hilary's steps but with some slight alteration for my scenario. My field is set to lookup type and pulls data from an external list, and using the secondary XML mapping to that same field worked like a charm. Thank you!!
  • 03-17-2015 01:21 AM In reply to

    Re: Repeating Table: Force all rows to have same value for one column

    Hi Hilary, your above mention example is not working for me, please provide complete description about it...
  • 03-17-2015 01:26 AM In reply to

    Re: Repeating Table: Force all rows to have same value for one column

    I have a similar issue... I have a repeating section with TeamLead, ProjectName, Sal as columns, the user has to enter TeamLead only once and the remaining repeated TeamLead columns in the repeating section should get the same value as first row TeamLead . I tried to apply default value, but it is only working for the first repeated column.. Please try to resolve this issue....ASAP Thankyou
Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.