UpsertIf Function for MySQL

I don’t want to get into detail on this this right now, but if your transformations get very complicated, you might consider using conditional expressions in the workflow to create more steps.

You’d have one step to do the basic setup (converting the form into that fields object and doing any generic transformations) then another step for each form type, which makes any special transformations and then upserts.

You can specify a condition on the edge like state.data.form.survey_type === "Partner Registration", and the step at the end of that edge will only fire if the condition is true.

I’ve mocked something up in Lightning and taken a screenshot to show you what I mean (I haven’t implemented any of these steps)