Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Validation in the linked record row.

205 0
cancel
Showing results for 
Search instead for 
Did you mean: 
HirenViraiyda
5 - Automation Enthusiast
5 - Automation Enthusiast

Is it possible to add validation for linked record rows?

I am using the Record Review layout to display data with a one-to-many relationship. I need to apply validation to ensure that the value is not empty and does not exceed a dynamically generated value.

Is this possible in an Airtable interface?

Thanks.

5 Replies 5
Dimitris_Goudis
10 - Mercury
10 - Mercury

Hey @HirenViraiyda

Yes you can do it. Open the linked field's settings and you will see the following options.

If you work from the data side it works, the same if you work on interfaces as well. But if you create records from forms, the "selections by condition" will not work. But the selection by view will work fine! 

Dimitris_Goudis_0-1739786364470.png

Thanks, 
Dimitris

Hello @Dimitris_Goudis ,

Thank you for your response.

I don't want to apply the validation on the table side; I want to add the validation on the interface side. What I am doing is using the record review layout, in which I am showing all the fields from the main table and also displaying the list of linked records from the same table that users can edit. I want to apply dynamic validation to the editable fields so that users cannot add inconsistent data.

If Airtable does not provide dynamic validation, is there an alternative to implement this flow?Thanks. 

ScottWorld
18 - Pluto
18 - Pluto

@HirenViraiyda 

No, that is not possible if you're just using Airtable on its own.

Airtable does not offer ANY validation of data (static nor dynamic), outside of some extremely minimal validation in forms.

As a workaround, you can always create a formula field that gives the user a warning if their criteria didn’t meet the validation.

However, your best workaround would probably be to combine Airtable’s interfaces with Fillout’s advanced forms for Airtable.

Fillout is 100% free and it offers dynamic validations for Airtable, and it also lets you update Airtable records from a form.

So you would simply make your Airtable interface read-only, and then give people a button or a link to update their records in Fillout, where all of your advanced & dynamic validations can be applied and enforced.

If you need anything more advanced than what Fillout offers, then you would need to turn to a 3rd-party portal tool to give you the combined interface & validation that you’re looking for.

The most popular portals that are currently available for Airtable are: Noloco, JetAdmin, Softr, Pory, and Glide.

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

 @Dimitris_Goudis, note that the information you gave above is incorrect. When turning on conditional restrictions for a linked record field in Airtable, the same conditions follow that field onto the Airtable form.

- ScottWorld, Expert Airtable Consultant

Hey @ScottWorld

Thanks for correcting me; totally appreciate it. I got confused by a similar but different case.