Jun 02, 2020 07:12 AM
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
Jun 02, 2020 08:42 AM
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: