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): https://preview.webflow.com/preview/gather-with-us?utm_medium=preview_link&utm_source=dashboard&utm_content=gather-with-us&preview=339158fe31f4593ea6fd69c351493fd1&mode=preview