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

[Arnocode]

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) ?

[Suvrutt_Gurjar]

Maybe more details and a few relevant screenshots will be required if the following does not work. But you may want to try a required if condition of 

NOT(CONTEXT("Host")="Server")

or you can try

CONTEXT("Host")<>"Server"

CONTEXT() - AppSheet Help

[Arnocode · Accepted solution]

I solved it by changing the required if formula

[Suvrutt_Gurjar]

Great. Thank you for the update.

May I request you to share the required_if expression you used if possible so that the solution is clearer for any future reader of the post thread.