Has anyone figured out how to submit a form with CMS-field checkboxes and then save the selected fields as a multi-reference field to a separate CMS collection?
In my user onboarding, the user can select category preferences, and I have Categories saved as a CMS collection. I want to save whatever the user selects to their entry in the Member CMS collection, and figure that the best way to do this is via one Categories multi-select field. Ideally, I’d like to do this simply using custom code, Webflow, and Zapier. If need be, I can use Airtable as an interim step.
Here is a screenshot to help visualize what I’m trying to do. Where I’m running into trouble is filtering the form submission for checked categories only and then concatenating those results into something I can submit back to Webflow. From other work I’ve done, I believe I need to reach a format where each category’s Item ID is within quotes and comma separated.
Here is the current data I’m getting from Webflow into Zapier. As you can see, I have all the elements necessary. Now it’s about filtering out unchecked boxes and then concatenating and formatting to submit back to Webflow.
Read-only link (see #/sign-up/interests): Webflow - Gather with us