Help

Using forms to link records

Solved
Jump to Solution
2941 5
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriel
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I want to use forms to let people outside my organization link records among my existing tables. I don’t want to let them create new records. Just let them link one field to another.

Is there a way to achieve this through forms?

I’m having trouble with the primary field being just a string of text.
Ideally, someone could select the primary field from a dropdown, and then link whatever they want to to that specific primary field, without creating a new record.

Use case example
I have a list of companies as my primary field.
I want someone to use forms to pick a company and associate it to a topic (currently linked to a Topics table, it basically acts as a multiple select).

1 Solution

Accepted Solutions
andywingrave
10 - Mercury
10 - Mercury

Hey there! Just chiming in - Whilst @Mohamed_Swellam is correct here.

There’s nothing to stop you having a form that is a table which just links two records.

Here’s the form - so you can test it out

See Solution in Thread

5 Replies 5

Hi @gabriel,

A form main purpose is to create a new record. There is no way to do so directly from Airtable.

However, what you are looking for is to update a record from a form. You can use 3rd party extensions to do so. Check this out https://miniextensions.com/airtable-edit-form/

BR,
Mo

andywingrave
10 - Mercury
10 - Mercury

Hey there! Just chiming in - Whilst @Mohamed_Swellam is correct here.

There’s nothing to stop you having a form that is a table which just links two records.

Here’s the form - so you can test it out

hey Mo @Mohamed_Swellam

thanks for the fast reply!
I literally just watched a video on that extension - really cool!

the problem with it is that I don’t want people to be able to edit the existing record, I just want them to add links/associations to it – based on my current database design.

Well, then you can use @andywingrave solution. Make a table that is only linking to the other tables. This will create new records in this particular table but not in the other tables.

BR,
Mo

thanks @andywingrave
this is a nice way around it. would be nice if Airtable came up with a robust solution :slightly_smiling_face: