Data validation

[Adam_Reece]

I’ve just started using Airtable, and straightaway I’m wondering if it’s possible to replicate the data validation function available in Excel.

Specifically, what I’d like to do is select from a Single Select list (the field would be called Category), and in the next column/field have a Subcategory, which would give me a Single Select list with a unique list based on the selection I made in the Category field.

For example, if my Category selection was Utilities, my Subcategory selection list would include Phone, Electricity and Gas. Alternatively, if my Category selection was Travel, my Subcategory selection list would include Fuel, Public transport and Flights.

Thanks.

[nitin]

gist.github.com

https://gist.github.com/nitincodery/36908042adf49d442fbf99cac3ddf916

airtable-validate-inputs.js

/*
Create Tables and select the one you need to input data.
Create Validations Table for each Table as TableName-Val.
Create Three Fields as Text in Validations Table as Column, Regex, Remark
Enter Column Names to Validate into Column Field in Validation Table.
Give Regex to validate and Remark to show when invalid data entered.
*/

/* Ask to input data in table whose validation table exists. */
let allTables = base.tables.filter(table => table.name.endsWith("-Val")).map(table => table.name.slice(0,-4))

This file has been truncated. show original

[Alexey_Gusev]

checking conditional fields, I had an idea
It’s not a true ‘data validation’, but conditional form fields can be used for a basic check ‘contains/does not contain’. You may add required single-select conditional field with empty options list, so it can’t be filled and form can’t be submitted when the field is active

[Leana_Siochi]

Thank you @Alexey_Gusev !!! This was super helpful!

[Tobias_LGKR]

+1

Data validation or dependencies, however you like to call it would be helpful with long lists to choose from.

[Luke_Castle]

willinspire:

se contains every country name, ISO alpha2 code, ISO alpha3 code, national flag, currency name, currency ticker, national language, time zone, international dialing code, national capital, GPS grid location, and alternative and native language spelling of every country in the world.

It also includes every US state, state flag, state seal, state map, image of the states largest urban areas, image of every state’s rural area, capital city of every state,

Can you make this shareable @willinspire please. :pray:t4: