SharePoint List Button/HyperLink open InfoPath Form - InfoPath Dev
in

InfoPath Dev

SharePoint List Button/HyperLink open InfoPath Form

Last post 04-12-2016 09:22 AM by wilkies0106aw. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-04-2016 04:37 AM

    SharePoint List Button/HyperLink open InfoPath Form

    All,

    Back to IFP after a long hiatus.

     

    SharePoint 2013

    InfoPath 2013

    I've a calendar list view on a site page.

    Can I have an extra field on a calendar event which is a button or hyperlink which would then open a prepopulated InfoPath form with data taken from the calendar event details?

     

    Thanks

    W

  • 04-12-2016 09:22 AM In reply to

    Re: SharePoint List Button/HyperLink open InfoPath Form

     Ok, cracked it.

    Calendar list - obviously each item in a list has an ID associated with it. For some reason I had to create a calculated column. I called mine EventID, I just copied the ID field to this field.

    On your form add a field which acts as a place holder. I hide my placeholders on an Admin view. When you publish the form, publish the field as a parameter field, NOT a column name.

    Create a site page, add an InfoPath form webpart and a Query String (URL) Filter webpart. Set the Query String Parameter Name.

    Connect the query string filter to the InfoPath webpart.

     On your calendar list, create another calculated column. Change its type to a NUMBER, not a string of text

    I used the following formula: =CONCATENATE("<DIV><a href=","http://mydummysite.com/sitepage.aspx?querystingparametername=",EventIDcolumnname,">","LinkText","</a></DIV>")

    You might have to play around with the formatting of your url depending on your locale and version of SP etc. 

    After that you can set fields in your form, based on matching the ID value to the placeholder field value.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.