Hi,
We have a company directory that I would like for my Nintex form to pull data from to allow for an easy user experience. I would like for the data from the company directory to automatically populate when a user accesses the form.
Here is a clip of the data that can be found on our directory----is there a way to automatically have the fields on my Nintex form pull & populate from this data source?
Solved! Go to Solution.
Hello,
Nintex can pull in data from external sources, but it depends on what those external sources are. Is your directory accessible via SQL or webservice endpoints? I think everyone will need a bit more information to give you the clearest of answers.
Thanks!
Mike
Hi Inger Spikner,
If your Company directory has exposed any web service call, you can then call the web service to get the current user details to auto-populate in the Nintex form when accessed.
Custom JQuery for the above logic can be written in the Custom JavaScript section that is present on the Form Settings:
Thanks so much for your responses Mike Matsako and Chaitra B C.
Our data resides within a SQL database and is displayed on a SharePoint page. We do not have a web service for this or any of our SharePoint.
What can we do with the SQL database to auto-populate on our Nintex form?
Use the Query Excel Services action.
Wait...should have read the whole thread. Don't know how that would work on a form.
That is a very different question Would you mind marking my original response correct as to not mislead others searching for this topic?
Anyways, you will want to import your Excel file into a List, and then surfacing data onto a Nintex Form becomes very easy. You can use the List lookup control if its a list other than the list the form resides on, or several other mechanisms like a calculated field with a "lookup" function on it.
Hope that helps,
Mike