For my salesperson's airtable, He needs to change the name of a few companies. He is unable to do that since it is a formula field. How can he undo the field from being a formula field and just a normal field so he can make edits to the name of a few companies?
Making a Formula Field a normal field so it is editable
+31You can check out Airtable's Field Type Overview for instructions on how to change field types. I don't think just changing the formula field would work as expected though, and that you might want to look into the formula being used in said field and see how to adapt your salesperson's workflow from there
Adam, Airtable Consultant - thetimesaving.company
+2You can double-click on the field header to open the editing menu. This will open a new menu of options where you can:
Change the field type
Configure additional options available for that field
When you are finished editing the field, click Save.
+13I agree with @TheTimeSavingCo's recommendation to look at the formula.
There was a reason that the company name field was designed as a formula. Breaking it by changing the field to a short text field could have unintended consequences.
Maybe the "base name" of the company is stored in another field, and your company name field concatenates that field with some other information that makes it more useful? If that's so, then the saleperson may find that referencing the underlying field produces the desired result.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.