Solved

NWC forms data sources / data lookup form control functionality

T
Badge +2

Hi all,

I've just started using the new NWC forms data sources / data lookup functionality - which is great to see this functionality added.

I have a data source configured to a SharePoint Online List containing interest rates and durations.

 

7246i9FC3EEB903AE8E26.png

I want to be able to select the relevant duration from the drop down and based on that populate the interest rate from the SharePoint Online List into another field.

The only way I could work out how to do this was by adding two data lookup form controls, however this isn't working as I though it might...

I have one data lookup form control  for duration and one for the interest rate.

I've configured a condition on the interest rate form control based on the duration form control and limited the maximum number of rows to return to 1.

However, when I select the duration from the first drop down, although there is a one to one relationship between the duration and the interest rate in my SharePoint Online List, the interest rate drop down still forces the user to select it. I was hoping the way it would work is that once they select a duration, the corresponding interest rate would just display in the form control without having to then click on the drop down and select the value and I'd make the field read only.

Not sure if this is just how the data sources / data lookup functionality works or if I have missed something and could achieve this a better way.

 

7247iF6BB09AD22FC20F0.png

Any feedback will be greatly appreciated. Thanks!

Tim

icon

Best answer by EuanGamble 22 April 2020, 01:08

View original

10 replies

butlerj
Userlevel 5
Badge +19

@tlangford while you can do cascading lookups (as you've found), there is currently no functionality that will "auto-populate" the default value of the second control based on the first control. Best workaround for this would be making the second control required so as to not miss any data entry. 


 


We can also put together a feature enhancement request for the Data Lookup control, but I want to make sure that I've got a good understanding of desired functionality so I do have a couple questions:



  • Should this only be "auto-populated" if there is just one value available, or should there always be a default value that is "auto-populated" when configured?

    • If the second, is there a prefered way that you would like to see that in the configuration panel? Given that the designer won't know values at design time (they will be populated at run time), could potentially do something like "value index" instead of "value text", but depending on sorting even that might change. 




Would love to get your thoughts.


 


Thanks!

T
Badge +2

Hi @butlerj,


 


Thanks for the feedback.


 


Ideally, what I'd like to be able to do (and from what I have seen from other competitor eforms solutions), in the scenario I presented, for the second form control (which would be dependant on the first data source form control), is the ability to use a number or text form control or a drop-down form control.


For the numeric or text form control, I'd like to see this return only a single value based on the selection from the first data source form control.


For the drop-down form control, I'd like to see this return multiple values based on the selection from the first data source form control and these would be displayed as values in the drop-down to be able to select from. So it would be great for this functinoality to be intuitive enough based on the type of form control used in conjunction with the data source.


Perhaps the conditions currently available in the data source form control could be moved out to a separate tab altogether in the forms designer along side the rules tab - perhaps called seomthing like "lookup rules"?


 


Thanks.


 

butlerj
Userlevel 5
Badge +19

@tlangford awesome! Super appreciate that feedback.


 


We have been thinking about how to make rules easier within form controls, so I'll definitely pass this along to our forms product team and see if we can add it along with some of the other ideas we have been kicking around.

EuanGamble
Userlevel 5
Badge +13

Hi @tlangford,


 


At the moment the data lookup control in primarily used for a choice control at the moment. We are looking to expand this functionality whereby you will be able to query for a whole object and use parts of that object as you described.


 


However, there may be a way to get what youre after if I understand your requirements correctly. I have created a video on how I would solve this - hope this is helpful to you.


 



 


Cheers,


Euan

T
Badge +2

Hi @EuanGamble,


 


Thank you for taking the time to explain that functinalty - what you've demonstrated there is exactly what I need to achieve!


 


Thanks again.


Tim

EuanGamble
Userlevel 5
Badge +13

Hi @tlangford,


 


Glad you found that useful. We are currently working on returning a data query as an object, which will make this a lot more powerful in the future, but hopefully, the example below will keep you going until we get this out.


 


Cheers,
Euan

A
Badge +4

Hi. Is there a way to populate multiple controls on a NWC form with data from a SharePoint Online list item

EuanGamble
Userlevel 5
Badge +13

Hi @Andrew87,


 


This is a planned feature.


 


Cheers,
Euan

allan
Userlevel 4
Badge +9

Hi @EuanGamble,
When can we expect to populate several controls via a lookup ?
For the moment, we have to maintain a concatenated value in the SharePoint list, which is a shame.
I would love to be able to populate several labels depending on the last dropdown of a cascading. 

EuanGamble
Userlevel 5
Badge +13

Hi @allan,


 


So we have begun rolling out some new functionality that will continue to evolve over the next few months called 'External Data'. This allows you to call a data source from NWC and use the data. At the moment it is only available in the Label control, but this will extend to other areas of the form designer.


 



 


Cheers,


Euan


 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings