-
Thank you. I'll have to do some research. You mention I can write code. What would the code be written in? If there are posts on this subject feel free to direct me to them. Thanks!...Lou
-
I see - so the problem you will have here is that out of the box InfoPath is not going to support passing in form values to your SQL Where clause. You have to return all the data, unless you write code or use a third party tool like a web service or qRules in your form. Is there any chance this data could also be in a SharePoint list, via BDC or ...
-
Thanks. I will try this out, but before I do that and before I attach a copy of the form, I was wondering how the lookup of employee name in data connection B actually works with the employee number from data connection A. Is the employee number from data connection A actually passed to the SQL of data connection B and used in the WHERE clause? ...
-
I don't think this is possible without code. If you are using on-prem SharePoint, you should be able to find some code samples online that will work for you. If you are using Office 365 for SharePoint, browser forms with code are no longer available, so it may not be possible.
-
Is this form used in Filler or the Browser? If filler, just use a message box action. If the browser, you could always add a field to the form's data source for your submit message and then, as part of the submit logic, after the form has submitted, set the value to "Your form has submitted successfully" or whatever. If you set the ...
-
Yes - it isn't really a join, but you could have a calculated value that looks up the Employee Name from data connection B by employee number. When you add a calculated value, you could select Employee Name from B, and click the filter button, and select the row where the employee id is equal to the one in data connection A. Feel free to ...
-
Hello,
I have a scenario where I will have two data connections to two different databases. One extracts employee file number (Extract A), and the other connection extracts the employee file number as well as their name (Extract B). I need to display the employee file number from Extract A as well the employee name from Extract B. I need to ...
-
Hello Everyone,
I'm attempting to create a Print button which instantly print a View for InfoPath when clicked. I'm using a browser enabled form.
-
Trying to find a way to show users a message when they click submit and its successful.
The form is basic information, few required fields, won’t allow to submit without them filled in.
The submit button has condition, that the user needs to check an acknowledgement box. Then the only rules for the submit box currently are submit data via ...
-
Thank you Hilary!. Your suggestion worked perfectly