Skip to main content
All CollectionsAdvanced Form for AirtableStandard OptionsRead-only feature
How to conditionally make a field editable or read-only
How to conditionally make a field editable or read-only

Follow this guide to show a read-only or editable version of your field conditionally

Updated over a week ago

When editing a record, you can configure a field to be editable only when specific conditions are met and show a read-only version at all other times using the following setup:

  • Make the field conditional so it will only appear in the form to be edited under certain conditions, like when a specific option is selected on a single-select field, for example.

  • Create a new formula field in your Airtable base with a formula that copies the content of the field in step one. Use curly brackets and the field's name like this:

  • Go to miniExtensions and add the new formula field to your form. By default, formula fields are read-only.

  • Make the new formula field conditional as well, but with the opposite conditions to the original field, so it will appear when the editable version is hidden. You can combine many conditions to find the correct mix for your specific requirement. Here's an example:

If your editable field appears only when a "Status" field shows 'Created', you can make the read-only formula field appear only when the status is NOT 'Created'.

With this setup, when the "Status" conditions are met, your users will see the editable field; when they aren't, they will only see the read-only formula version of the field that shows the same data contained in the original field.

Related

Did this answer your question?