I have a basic Zap that takes a submission from Submittable and upserts a Contact record in Salesforce. The issue I’m running into is that the Submittable form has multi-select checkbox fields that need to be re-formatted into single checkbox fields in Salesforce. For example, a submission could have Question 1, with A,B,C,D all checked in a multi-select response, but that needs to translate into boolean checkboxes on field A, field B, field C, and field D on the Salesforce record.
I think I could do this by formatting one field at a time, but there are upwards of 20 fields that need to be formatted, so that feels inefficient. Is there a way to do this with tables or line items? I’m not entirely sure I understand how the data would translate.