I’m building a big Nintex form on Sharepoint 2019 and I’d like to know if it’s possible to have certain columns already filled out automatically based on from which location on the site users access the form. I know it is possible to set a standard value in the content type, but that’s not what I’m looking for. I want to have the standard value be variable, for example through different urls that I could link on different sitepages.
Solved
Auto-fill entries on Nintex forms based on entry link on Sharepoint
Best answer by bamaeric
You can pass in a parameter in the new form URL and retrieve it using the fn-GetQueryString inline function. Below is an example of how to do this in the Responsive Forms designer:
1. Add a new list column. In my example, I created a “Single line of text” column called Location.
2. Add the Location control to the form.
3. Configure the Location control settings.
- Default value source = Specify default value
- Default value = fn-GetQueryString(Location)
3. Add a URL parameter in the referring URL for a new form with what you want defaulted in the Location field in the new form. Here’s an example of the referring URL for a new item form: https://domain/site/YourList/NewForm.aspx?Location=Atlanta
4. When a user opens a new form from this URL, the Location field will have a default value of “Atlanta”.
Here’s more information about the fn-GetQueryString inline function: https://help.nintex.com/en-US/nintex2019/current/#sp2019/Forms/Designer/InlineFunctions.htm
+13You can pass in a parameter in the new form URL and retrieve it using the fn-GetQueryString inline function. Below is an example of how to do this in the Responsive Forms designer:
1. Add a new list column. In my example, I created a “Single line of text” column called Location.
2. Add the Location control to the form.
3. Configure the Location control settings.
- Default value source = Specify default value
- Default value = fn-GetQueryString(Location)
3. Add a URL parameter in the referring URL for a new form with what you want defaulted in the Location field in the new form. Here’s an example of the referring URL for a new item form: https://domain/site/YourList/NewForm.aspx?Location=Atlanta
4. When a user opens a new form from this URL, the Location field will have a default value of “Atlanta”.
Here’s more information about the fn-GetQueryString inline function: https://help.nintex.com/en-US/nintex2019/current/#sp2019/Forms/Designer/InlineFunctions.htm
Translate
bamaeric wrote:
You can pass in a parameter in the new form URL and retrieve it using the fn-GetQueryString inline function. Below is an example of how to do this in the Responsive Forms designer:
1. Add a new list column. In my example, I created a “Single line of text” column called Location.
2. Add the Location control to the form.
3. Configure the Location control settings.
- Default value source = Specify default value
- Default value = fn-GetQueryString(Location)
3. Add a URL parameter in the referring URL for a new form with what you want defaulted in the Location field in the new form. Here’s an example of the referring URL for a new item form: https://domain/site/YourList/NewForm.aspx?Location=Atlanta
4. When a user opens a new form from this URL, the Location field will have a default value of “Atlanta”.
Here’s more information about the fn-GetQueryString inline function: https://help.nintex.com/en-US/nintex2019/current/#sp2019/Forms/Designer/InlineFunctions.htm
Thanks, that works perfectly.
Translate
1 person likes this
As an addition, can you also do this for multiple-choice columns? I’ve got it working for single-line textboxes and I’m assuming it works the same for single-choice columns and Yes/no columns, but how would it work for columns where users can pick multiple non-exclusive options?
Translate
+13You should be able use the same concept with the fn-GetQueryString() inline function to accomplish this.
For example, let’s say have a Choice control on your form named Color configured with Display Format = “Check boxes (Multiple-Selection)” and Choices are Red, White, and Blue.
To pre-populate the Color check boxes with Red and Blue:
- Configure the Color control with Default Value = fn-GetQueryString(Color)
- Set the URL to https://domain/site/YourList/NewForm.aspx?Color=Red;Blue
- Add the ?Color=Red;Blue parameter to the end of the URL.
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.