Dec 19, 2023 05:37 PM
There are times when I need a data field to be "Required". Otherwise, data quality issues are introduced.
When this is needed, usually the data field must always be "Required" (Use Case #1). There are also times when a data field needs to be "Required" only conditionally (Use Case #2), based on a value present in another data field within the record.
What I have observed:
Am I missing something? Please let me know if there is another means to enforce these rules.
Solved! Go to Solution.
Dec 19, 2023 09:08 PM - edited Sep 18, 2024 05:49 AM
Unfortunately, as @dilipborad mentioned above, Airtable has NO VALIDATION of any kind in the entire platform.
The only exception to this is forms, which offer the ability to require fields. But Airtable forms can’t be used to update records, only add new records.
So your only real option there is to use Fillout's advanced forms for Airtable. Fillout is 100% free, and is the only dedicated form app for Airtable that allows you to both create and update records in Airtable with a form. Fillout also has many more validation options than Airtable’s forms. It also has many advanced, Airtable-specific features.
(You can also use more generic form software like JotForm, but it doesn’t offer full integration with Airtable, so you’d likely have to piece together your own communication using Make's JotForm integrations.)
Another option would be to use an external Airtable interface/portal app like Noloco or Softr, but then you’re getting into serious expenses when all you really wanted was some extra validation options.
Beyond that, your best choice for integrated validation options would be to turn to a more capable & more professional database app, like SmartSuite (as @dilipborad mentioned above) or Apple’s cross-platform database app FileMaker.
If you need a FileMaker developer or an Airtable consultant, please feel free to contact me through my website: Airtable Consulting — ScottWorld
Dec 19, 2023 08:39 PM
Hello @DataGuru
I don't think you've missed anything. It's true that AirTable is not supported data required validation at view and table level. It's only support while you're interacting with Forms and Interfaces.
Check this SmartSuite | One Platform for Managing Work
This tool is still in early stage but I think they have these type of things.
Dec 19, 2023 09:08 PM - edited Sep 18, 2024 05:49 AM
Unfortunately, as @dilipborad mentioned above, Airtable has NO VALIDATION of any kind in the entire platform.
The only exception to this is forms, which offer the ability to require fields. But Airtable forms can’t be used to update records, only add new records.
So your only real option there is to use Fillout's advanced forms for Airtable. Fillout is 100% free, and is the only dedicated form app for Airtable that allows you to both create and update records in Airtable with a form. Fillout also has many more validation options than Airtable’s forms. It also has many advanced, Airtable-specific features.
(You can also use more generic form software like JotForm, but it doesn’t offer full integration with Airtable, so you’d likely have to piece together your own communication using Make's JotForm integrations.)
Another option would be to use an external Airtable interface/portal app like Noloco or Softr, but then you’re getting into serious expenses when all you really wanted was some extra validation options.
Beyond that, your best choice for integrated validation options would be to turn to a more capable & more professional database app, like SmartSuite (as @dilipborad mentioned above) or Apple’s cross-platform database app FileMaker.
If you need a FileMaker developer or an Airtable consultant, please feel free to contact me through my website: Airtable Consulting — ScottWorld
Dec 27, 2023 05:24 AM
Hello @DataGuru
As @ScottWorld mentioned you can use a couple of direct form builders and integrate them with Airtable or some website builders.
But I forgot to mention another tool ReTable(No code online spreadsheet & database solution for business | Retable) which also has that type of data validation.
Dec 27, 2023 08:44 AM
Thanks for the additional feedback. I’ll see if they can meet my needs.
Oct 07, 2024 09:38 AM
Hey, you're not missing anything—Airtable doesn’t have native support for enforcing required fields after data creation or conditionally based on other fields.
However, the DataGuard extension can help with both use cases. You can easily mark fields as Required for data creation and updates, and while conditional requirements aren't directly supported, you can set up rules to enforce validation based on different field values.
Might be worth exploring if strict data quality is important for your workflows.