I need to duplicate a row, with required columns that are sometimes empty due to cascading dropdowns

Hi,

I want to allow users to duplicate a row in the app using an action "Data : add a new row to another table using values from this row". In the form, there is several columns that are cascading dropdowns. Some parent values do have children values, some do not.

For example, let's say there are 2 columns 'Site Parent' and 'Site child'. Site Parent has 2 possible values, Site A and Site B. Site A has 2 children, Site A1 and Site A2. Site B has no child, so 'Site child' is not visible when Site B is selected.

The child column is visible and required when there are children for the parent. 

However, when i trigger the bot with this action on a row where the user selected Site B, i face an error telling me that the child column cannot be empty. I tried to solve this by adding a condition on the required parameter (count children, required if > 0) but now the error is 'the field failed 'Required_If' condition'. 

Anyone know how to solve this issue ? Thanks ๐Ÿ™‚

And why does it not follow the same rule as when someone manually type it in a form (if the field would not be visible to a user, then it is not required) ?

Solved Solved
0 3 208
1 ACCEPTED SOLUTION

I solved it by changing the required if formula

View solution in original post

3 REPLIES 3
Top Labels in this Space