Hello Everyone,
I'm new to Infopath and this forum has been of great help recently! I'm building a Sharepoint list form and have trouble with Submit data. My SP list is one flat list with Project and Phase details where project name, contacts etc repeats where as the phase and deliverables are unique. So far I'm able to achieve the following
- Connect to the same SP list as secondary and load project names into Drop down
- 1st repeating table shows Project name, contact etc and I hid the repeating rows with formatting rule
- 2nd repeating table shows project phases and deliverables and I filter the project data with another formatting rule which only works with secondary data source
- On drop down change, I set the fields values from secondary source - I can't find a way to filter the main datasource
- I tried setting field values before submitting the data from secondary fields to main with a button but it didn't work. The form retains the entry but nothing gets saved in the list
I'm not sure what I'm doing wrong here. I'm open to make design changes. My requirement is just the users should be able to update multiple project deliverables in repeating table.
Thanks a lot!