-
Hi all.
I have a trouble with list and forms. Please help :)
I have a list.
When I create item in new form, I can create only one item in list (one note/point).
I want fill several name of items in one form and create this several item in list.
When find in InfoPath 2013 this setting?
p.s. thanks for screenshots.
-
I also need help with the exact same thing. Anyone?
-
wow, so simple & so out-of the box
you're the queen!!!
thanks alot!
much appreciate
-
That worked fantastic! I never knew what the purpose of the query fields were before, thank you.
-
Hi - This is tricky without writing code. Do you mean the user would actually enter a string like "Mexico, USA and Canada" into a combo box and you'd need to parse it to know that it was three countries? Or is the combo box in a repeating section and the user selects first one country, then the next?
-
In your list connection, set it to not query on load (this is a checkbox on the last dialog of the list data connection wizard). In your form, when the user selects a category, set the category query field in your list data connection (the data connection has query fields and data fields) to the selected category. Then add a rule to query the data ...
-
Yep, I was querying all 8000 rows. Probably the problem? There is a category that I could have the user select from a dropdown. What column(s) would I need to index and then how do you limit the query results based upon the category? By filtering in the query action?
-
I wasn't clear, sorry. Is there information in your form you can use to determine what rows you need from the list? Like - the user selects a department, and you know you only need rows that match that department? You aren't currently querying for all 8000 rows, are you?
-
Would I add an index to the ID field? I can do that, but then how do I limit the number of rows returned in the query?
-
Can you add an index to the list? I've found that on a list that exceeds the threshold, if there is an index, and if I use query fields to limit the number of rows returned, I can get past the list threshold.