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

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

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

Last post 01-14-2013 11:04 AM by AlexK. 4 replies.
Page 1 of 1 (5 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
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 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 150 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 150 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!!
Page 1 of 1 (5 items)
Copyright © 2003-2014 Qdabra Software. All rights reserved.
View our Terms of Use.