Dependent records populating from list collector to a field

[servicenow14710]

Hello developers, I have a custom table(ctable.png attached) with two columns lets say list from the table should be populated in a list collector(multi selection is possible) and its corresponding role column has to be displayed in another field (label/text field)

From the image(ctable1.png) list1 is a list collector and role is field in which its corresponding roles are populated.

Lets suppose i select read, write in list collector in role label readaccess, writeaccess has to be populated. also this should be dynamic like if i delete  write from listcollector writeaccess should be removed from the label .

Any help is highly appreciated, Thanks!

@Karan Chhabra6 , @Anurag Tripathi,

@Prince Arora , any suggestions. Thanks! 

[SanjivMeher]

Can you tell me the use case for this? I think the easier way would be to populate the fields when the record is saved. To do that, you can create an onBefore Business Rule and then query the custom table, get the values and populate the role field.

[servicenow14710]

Hello @SanjivMeher : I have to populate the role in another custom table which has list column so its corresponding values has to be shown in that custom report table once catalog item is ordered.As you suggested when we query the custom table to get list collector values (as they are multiple selection) is it possible with the same.

If possible can you suggest me with that business rule script . can we do this via script include?

Thanks!

[SanjivMeher]

Do you have a flow designer associated to the catalog item. You can use that to update the other table, after the catalog item submission. You probably need to create a flow action and use it in the flow. If you provide the variable name where the values are and then the target table and field name where the values would go, we can help with a sample script.

[servicenow14710]

Hello, i am using workflow for this we are not using flow designers in any as of now and not allowed to. Thanks!