When someone submits a form, can it create or update a contact, lead, or deal in my CRM?

Yes. A new submission can trigger a workflow that creates or updates CRM records in a connected platform, including contacts, leads, accounts, opportunities, and similar record types, depending on the CRM and integration method you use.