-
Here's my form - take a look at the read view. I've got a form load rule to query the 2ds.
-
So - is the desired outcome that the form only have the items that match on department?
-
Hilary you are way to kind and I can not thank you enough! Thank you!
-
Thanks! I'll wait for your sample file. I'm not able to make it works if I try to query from the secondary connection... I'm doing something wrong for sure
-
No, there isn't - you can't combine repeating data like that.... but there is a way you could populate the main data source from your secondary data source! Attach your latest form & I'll fix it up later today for you. :)
-
Right - this query will always run. It doesn't matter that it always runs. It is a SECONDARY connection. You add another connection to the same list - this works around the issue of the main data source being cleared when you add a query to it on load.... I can update my sample form for this later today & attach a copy so you see what I ...
-
Is there a way to have a quantity field that is set in the main data connection that is a part of the repeating section I have on my form?
-
Your idea makes sense to me. But if I apply a form load action rule, which queries for data in the display view, this rule will affect all the views. So, I don't know how to query data from the secondary connection only in the display view.
-
Hey - I was worried about this when I last saw your form - but thought maybe you were just submitting via email. Secondary data sources aren't updated on submit. Secondary data isn't saved on submit. That's why when I suggested a repeating structure & default data, the main data source was used for the items....
-
I am using a secondary data connection from a SharePoint list. I retrieve my quantities from the data fields portion of the connection. When I submit the form I would like SharePoint to save the input into those fields, while also having the form query the quantities with defaults of zero from the SharePoint list. I can give more explanation if ...