That is not possible with Airtable’s native forms, but you can do all of that with Fillout’s advanced forms for Airtable.
Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to create a login page for your form, validate data before allowing the user to submit the form, update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld