Solved

Auto-fill entries on Nintex forms based on entry link on Sharepoint

  • 16 January 2023
  • 4 replies
  • 84 views

Badge +1

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.

icon

Best answer by bamaeric 17 January 2023, 16:53

View original

4 replies

Userlevel 5
Badge +10

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

 

 

Badge +1

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.

Badge +1

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?

Userlevel 5
Badge +10

You 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:

 

Reply