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 using the Conditional Field setting, 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.
While Airtable does not allow two fields to have the same name, you can set a custom field title in the Standard Options section, so your formula field shows under the same name as the regular field, which creates a seamless experience for the end user.