Symptoms

I need to transfer data from one editable list to another.

List 2 is a lookup for list 1. I need to update some fields on List 2 depending on the Items that were added on list 1. That’s I need to populate List 2 using the ID’s found on List 1.

 

Diagnoses

Workaround using form rules
 

Resolution

There is no direct way to achieve this as there are no rules to allow dynamic filtering of a List View. There is a workaround you can look into.

The workaround works as follows:

1. When user adds a row in the 1st view, the form will execute the clear method in the 2nd view. The 2nd view is the lookup list. If the list is not cleared beforehand, there will be duplicate rows in the lookup list each time the user adds a row in the 1st view.

2. For each added rows in the 1st view,
a. Add a new row to the 2nd view
b. Execute the read method from the SmartObject that retrieves the lookup information
c. Map the returned values to the corresponding control in Add/Edit row of the 2nd view
d. Apply the changes made to the row on the 2nd view