Hi all hoping someone can help or lead me in the right direction....
I have 2 data connections to an InfoPath form. Second data source holds majority of information.
What I am trying to do is build a calculated field in my SharePoint list to house the InfoPath form as a URL link. I have several lines of data on the SharePoint list that I want the InfoPath form to read the ID and prepopulate the form. So URL would be built in a Column on each line populating the InfoPath form when pressed.
1. I have created the form and the calculated field and it is clinking to each list line. however I am not sure its correct.
=("<a target='_blank' href='https://oursites.dhsstaff.dhs.gov.au/Groups/61019708/LEARN/Lists/Nominations/Item/newifs.aspx?ID='[ID]'>Nominate</a>")
2. Second issue is filtering the data in the InfoPath form to read the ID that is associated with the data connections.
Hope this makes sense.
I am new to this sort of stuff so I apologies