-
Hi Todd and thanks for your warm welcome,
I would create a separate view (copy the one you have) and convert the text boxes to calculated values (right click and choose change to->calculated value). Make sure you add logic to your form to switch to this view before emailing.
-
Add a form load rule to query the list on load so you can edit all items.
You can use formatting to hide items you don't want to show them for editing.
-
Have you tried modifying your data connection and checking the form_x0020_Name column?
-
Hi Jesse,
Yes, and Jimmy can help you with this when he meets with you on Tuesday.
Thanks for your patience!
-
My guess is that InfoPath thought the result would be a single employee as opposed to multiple. If you modify the data connection and use the last name with two hits, InfoPath will be smarter and see that there can be two returned values. The first time you set up the data connection you probably used a query that only returned one value.
-
Hi Nick and welcome,
You are setting it up correctly.
What you have discovered is probably the #1 gap when integrating InfoPath with SharePoint.
We have been advising people on this issue for 10 years now.
Basically, you have these options:
Map your repeating data to separate rows a list and pull that data from your other form (via ...
-
Glad to hear that. Thanks for updating us.
-
I'm attaching a sample form.
-
Thanks for the interesting post. I suppose you could have a text field that takes just two characters and auto-moves to next field when they are typed.
-
Fantastic! Glad to hear you figured it out. Sorry we were delayed in responding.