I have been struggling with this all day. I have an Infopath form that is connected to two Sharepoint Lists.
SP List 1 (Project Charters):
- Charter Title
- Charter Opportunity
- Charter Start Date
SP List 2 (Project Weekly):
- Weekly Title
- Weekly Opportunity.
I am attempting to combine these two lists into 1 repeating table on a new form. The Weekly Title field holds the same values as the Charter Title field, so I can match using Titles. I have found some resources, with this being the best:
There is a sample toward the end that does exactly what I want, but it will not work with my setup. Here is what I get:
As you can see in the picture, the "From my weeklys" column is always the same, and this is the problem. It should match with the corresponding field highlighted in red two the left. This is the formula in the calculated field:
Weekly_x0020_Opportunity[Weekly_x0020_Title = current()/Charter_x0020_Title]
The logic is to return the Weekly Opportunity description, where the Weekly Title matches the Charter Title; however, it only ever returns the same description. The testing column was used to prove that current()/Charter_x0020_Title was producing the unique titles for that row.
I feel like I am really close. The 3rd charter is missing a description, because my Weekly does not have a 3rd charter, so this is working properly. I just need to figure out how to bring-in the proper description.
Note: I am hoping for an Out-of-the-Box solution without coding.
0 commentaires:
Enregistrer un commentaire