@Kevin_Mooney Webflow is just providing basic functionality with forms, it’s not their strong point.
There’s got to be a better way!
There is, but based on your original post, you may not like it
The typical approach is to use native Webflow form, so that you can style them with the look & feel of your site (versus copy/pasting some hacked form via another service) and to back up the missing functionality that Webflow does not yet provide, through a “glue service.”
The glue services I’m referring to are Integromat & Zapier.
Yes there is an extra cost.
But if you go with the former (Integromat) they have an ample free tier that will get you most of what you could ever need. If you bump into limits with their free tier, then it’s only $9/mo.
So much so, that I use this “stack” regularly:
Native Webflow Form → Integromat → <whatever I need to do next>
If you want to explore this route a bit further, let me know. I’m happy to point you to some learning resources.