locked
Populate Site Column with Synonym RRS feed

  • Question

  • I have a fun one for the community. I am unable to use a Lookup Column since I have multiple site collections and will it not governable to keep 18+ lists updated.

    What I want to do is to auto-populate an ID field once a user selects a Vendor name. I am using Managed Metadata for the Vendor Name and have the IDs listed as the Synonym. My ideal state is to populate the a Site Column named "Vendor ID" with the Synonym of "Vendor Name". Any ideas on how to expose the Synonym of a Term to do this?

    Many thanks in advance!


    My Company Blog: http://blog.concurrency.com/author/krusk
    My Personal Blog: http://thebitsthatbyte.com
    Wednesday, June 22, 2011 2:18 AM

Answers

  • I have no idea how to expose the synonym of a term to auto-populate a field, what I think of is to add a rule to a button in InfoPath list form which query the property of this record using SharePoint 2010 Lists web service and then set the ID field with the returned data. With this approach, a SOAP data connection should be created while editing the InfoPath list form and then you should configure the query data and set field action. A downside of this is that, we need to have a SharePoint list stores the Vendor information with their name and unique ID.


    Thanks & Regards.

    • Marked as answer by Lily Wu Sunday, July 3, 2011 1:39 PM
    Wednesday, June 29, 2011 2:07 AM
  • Thanks Lily. I will look into the options. Currently, I am attempting another approach that will not require the auto-population.
    My Company Blog: http://blog.concurrency.com/author/krusk
    My Personal Blog: http://thebitsthatbyte.com
    • Marked as answer by Lily Wu Sunday, July 3, 2011 1:39 PM
    Wednesday, June 29, 2011 4:38 PM

All replies

  • I have no idea how to expose the synonym of a term to auto-populate a field, what I think of is to add a rule to a button in InfoPath list form which query the property of this record using SharePoint 2010 Lists web service and then set the ID field with the returned data. With this approach, a SOAP data connection should be created while editing the InfoPath list form and then you should configure the query data and set field action. A downside of this is that, we need to have a SharePoint list stores the Vendor information with their name and unique ID.


    Thanks & Regards.

    • Marked as answer by Lily Wu Sunday, July 3, 2011 1:39 PM
    Wednesday, June 29, 2011 2:07 AM
  • Thanks Lily. I will look into the options. Currently, I am attempting another approach that will not require the auto-population.
    My Company Blog: http://blog.concurrency.com/author/krusk
    My Personal Blog: http://thebitsthatbyte.com
    • Marked as answer by Lily Wu Sunday, July 3, 2011 1:39 PM
    Wednesday, June 29, 2011 4:38 PM