How to change columns' values of the List or Library based on selection in drop-down control

Forms SharePoint Online
1

Hello,

I am trying to implement the following function for a form. If I select "Conveyor" in the Description dropdown box, I will get drop down values for the "Details" column, and I will get 48, 60, 48 for "Dimensions" column and 4000 for the "Weight" column.

image

If I select the "Flattener" in the Description column, then I will get a different dropdown values in the "Details" column. and will get a different set of dimensions and a different weight value.

image

Can you show me how to implement this feature in plumsail? like the general approach.

Thanks a bunch :grin:

2

Dear @jyou,
Does it have to be a List or Library control, or can you use Data Table instead? List or Library saves data to another list, and Data Table will store values as text in the current one.

3

@Nikita_Kurguzov ,

How can I achieve the form using data table? could you show me an example? Thank you.

4

Dear @jyou,
There are many basic samples in this article here - Work with Data Table using JS on Plumsail Forms for SharePoint — SharePoint forms They'll need to be mixed and mashed to achieve the functionality you're looking for, but it should be doable.

Data Table can then be saved to a column in the current list - Ink Sketch, DataTable, and Likert Scale in SharePoint — SharePoint forms

5

@Nikita_Kurguzov ,

Thank you for the links. When I checked the tutorials, I can't find any tutorials on how to make a new dropdown appear based on previous dropdown selection.

I just have a question, how do I code it when I need a new dropdown control to appear under the "Details" column when the value "Flattener" is selected from the "Description" column?

image
image824×305 76.6 KB

Thank you :slight_smile:

6

Dear @jyou,
Yes, it is a more complicated case when the ones described in our docs. Which control are you using List or Library, or have you switched to DataTable?
image

If I understand correctly, the need is dynamic dropdown population based on other field's value?

If I select the "Flattener" in the Description column, then I will get a different dropdown values in the "Details" column. and will get a different set of dimensions and a different weight value.

Would you consider paid support for us to write the necessary code and test it, to make it work? If so, please, contact us at support@plumsail.com to evaluate the price and time necessary to make it work.

7

Hi @Nikita_Kurguzov ,

I am trying to switch to Data table to achieve dynamic dropdown population. Thank you for the resource, I will look into the paid support.

I just have one question, As I see the "Internal name" property is missing in the Data table column setting for me.

image
image1200×433 13.9 KB

How come I don't see the same setting as shown in the tutorials like the following:

image
image916×260 37.2 KB

thank you

8

Dear @jyou,
Thank you for pointing that out, we'll likely update it in all of our docs! The InternalName property has simply been renamed to Name - it's the same property as before.

9

@Nikita_Kurguzov ,

Thank for letting me know and thank you for your help. :slight_smile: