I have a SP team site list that contains fields describing widgets, one of which is an ID field that corresponds to an ID in my document library. In my list, I'm looking to create a URL field "Go to documents" that will link to a search of my document library for the relevant ID field. My goal is to build a dynamic string of
"domain.sharepoint.com/.../.../...&?=" & list.ID and set up a workflow or other mechanism to automatically populate it when a new record in my list is added. I can't seem to figure out how to make that happen. I've gotten as far as being able to create a variable in Designer, but can't seem to make it reference the contents of another field.
I'm by no means a sharepoint designer. My background is in databases so maybe I'm even approaching it completely wrong. Hopefully my description makes sense. I appreciate any help. Thanks.
Edit with a more specific example: Say my list is about various projects. Starting new project, I create an entry on the list and give it an ID. Moving forward, we have various documents that will be related to that project. We will upload those documents and give them the same ID as the project on the list. The goal is to have a link from the list to the document library filtered by the project ID.