Auto-populate field when form is completed

Hi Airtable Community,

A newbie here, so apologies if this has been answered 1,000 times - just not sure what to search for…

Essentially, we have a form on our website which is a CV submission for jobs. When this form is completed it populates the fields that we have in our Base. However, we have some additional fields and I was wondering if there’s a way for these to be populated when the form is complete without having to ask them on the form?

When the form is complete, we basically wish for the Base to complete the ‘Source’ field as ‘Website’, as all other entries will be manually inputted.

If that doesn’t make sense I do apologise, but would greatly appreciate any help.

Many thanks,

Thomas

Formulas probably aren’t the best solution here. While it is possible to create a formula that looks at a field that may or may not be filled in, then spit out a response, you’d have to create an additional formula field for every field you want a default value for.

The ideal solution would involve a feature that doesn’t exist ubiquitously - default field values. Which currently is a feature that exists for some fields but not all. Could make a good ‘product suggestion’ post.

So the solutions you’re left with are:

  • a workflow process to manually fill-in empty values
  • 3rd party integrations, which would automatically scour your base for empty values and either flag them for review or replace with default values
  • the Scripting Block - which could do the same as listed above, but would need to be run manually via a button