Skip to main content

In our base, we have a field where users can select a project from a linked table. However, we want users to only select from existing projects, not create new ones. Currently, the small "+" button still appears next to the field, allowing users to add new projects—something we want to prevent.

Is there an easy way to disable or hide the "+" button in a linked record field without locking or restricting the entire field or table for the user? We're looking for a solution that allows selection from existing records but completely disables the creation of new ones via this interface.

Screenshot to show that often projects are added by incident - which we would like to prevent

 

@Anne Schmitz 

In the OTHER table (where all of your linked records are stored), click on the name of the table and pull down to “Edit Table Permissions”.

Then, where it says “Who can create records?”, you can choose who you want to be able to create new records in that table.

You can also set it to nobody at all.

This will prevent the users from being able to create new records in that table — either directly or through a linked record field.

Hope this helps!

If you’d like to hire the top Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Thanks for the explanation @ScottWorld! I actually still want people to be able to add new records directly in the “OTHER” table, but I want to prevent them from doing so indirectly through a linked record field. Do you know if there's a way to set it up like that?

Thanks again for your help!

 

 


Hey ​@Anne Schmitz,

I think you would be better off creating an interface to this effect, showing the linked field, and under User actions on the right margin toggle “Link / unlink records” on, but keep “Add records through a form” toggled off.

 

 
Please let me know if this solves your issue. Would be happy to help out.

Mike, Consultant @ Automatic Nation


Hi ​@Anne Schmitz,

You would still need to go through the steps that I outlined above, but then you would need to give your users an ALTERNATE way of adding new records to that OTHER table.

One of the quickest ways of letting them add new records to that other table would be to create a form in Airtable.

And, as an extra bonus, if you want to give them a very advanced form — with hundreds of more features than Airtable’s forms — you can turn to Fillout’s advanced forms for Airtable. You can do really cool things with Fillout, like displaying lookup fields on a form, updating Airtable records from a form, create multi-page forms, and much much more.

Hope this helps!

If you’d like to hire the top Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Also, another great solution from ​@Mike_AutomaticN above!

As Mike mentioned, that would require you to use the interface layer instead of the data layer.


Thanks ​@ScottWorld! :D  


Thank you, too! 😁


Reply