Skip to main content

airtable make rows non editable based on criteria

  • December 3, 2022
  • 2 replies
  • 22 views
R
Forum|alt.badge.img

HI, I am new to Airtable. I reached for my query before i am posting this in forum.

Let's say I have 2 records.

ID, Type, Item,FYxx_Total

1, Fixed,A,200

1, Fixed,B,100

1, Variable,null,0

As you see, ID is 1. When the user enters the FYxx_Total, the first and the second row shouldn't be editable. Meaning, user shouldn't have the ability to alter the numbers for the Type = "Fixed". The 3nd row, I want user to enter the data for this ID: 1.
is it possible to achieve in Airtable?

    2 replies

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • December 3, 2022

    Sorry, This is not possible in the native Airtable interface.

    Karlstens
    Forum|alt.badge.img+24
    • Karlstens
    • Brainy
    • December 3, 2022

    What’s your ultimate objective? What is the workflow that you’re trying to achieve?

    Locking a record based on the content on another within a table isn’t possible - but that’s not to say your workflow can’t be catered for with a different approach.

    Terms & ConditionsAccessibility statement