Hi guys,

I have two tables.


Table 1 is called Contacts (contains contact and deal information), Table 2 is called Questionnaire (contains a series of long text questions) and is linked to table 1.

I want to set it up so that when a contact completes my questionnaire through the link I provide them, the data they have provided in the questionnaire form will be automatically attributed to their record in the Contacts table.

I’m hoping that by doing this I will then be able to view the contact and from within the contact, open up their questionnaire responses.

I have considered having them in the same table however the contacts table already holds a large amount of fields.

Through my research of this issue I have found and followed a Airtable guide called “Use case: update records via a form”. From what I understand, this method uses a field in the Questionnaire form that is prefilled and labled “please do not change this portion of the form”.

Unfortunately I cannot use this method as it will allow my contacts to view a list of other contacts if they were to actually click the +add button.

I hope I’ve explained this okay. Any help would be greatly appreciated because I’e been on this for awhile now.