Additionally, I've created an automation that auto sends an email containing the pre-filled URL. Is there a way that I can avoid the url break line when it sends

@ethang 

For help with your prefill link, check out @kuovonne’s Prefilled Forms extension.

However, using a prefilled link is not the best way to solve this problem, because:
(1) it requires you to constantly send the newest prefilled link to your users or else they will see outdated information on their forms, and
(2) there is no easy nor reliable way to merge the new form data with the old record data without resorting to JavaScripting or Make.

Instead of going through all of that, the quickest & simplest & best way to do this is by using Fillout’s advanced forms for Airtable.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields 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, and much more.

In your case, as soon as they fill out a “new record form” for the first time, their new record will be created in Airtable, and you will send them an automated email that gives them a special URL. This special URL never changes, and it will enable them to update their record in Airtable by using a Fillout “update form”.

You can see how to set this up in my video below, which also shows off many other advanced techniques using Fillout:

• Using Fillout to create an eSignature approval process with PDF file creation.

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

Airtable has a guide for updating records via form submissions that you can find here.  Using this method still leaves you with a record created via that form submission I'm afraid, but it'll update the approriate row for you at least

For the issue you're facing with the link breaking, try updating your message so that it sends like this instead:

For example:

And this will send the email like this:

Thanks Adam, I'll give the record updater a look. I could always just filter out of the workflow based on some sort of criteria.

Ahh yes, hyperlink is perfect, thanks!