I am trying to figure out the best way to achieve the following requirement:
I have a Object1 that I create a record checking or not 5 checkboxes as applicable. Example:
Bee (not checked)
Durable (not checked)
Entrance (not checked)
In the other hand, I will need to create the variations in object2.
record 1: name = 0002x9 - Arrow
record 2: name = 0002x9 - Castle
For those i did not select the checkbox in the object 1 will not create a variation in object 2. And if I diselect a checkbox (once it has already been selected) the record created in Object 2 needs to become "Inactive")
I need to always check if the record (variation) in object 2:
already exists - update (active or inactive),
does not exist - create.
How could I achieve that using flow + process builder?