Issue syncing Tally form multiple choice answers to Airtable via Make

Hi everyone,

I’m trying to set up an automation on Make that retrieves data from a Tally form and sends it to my Airtable base.

My Tally form is already live on my website, and everything works perfectly there — I receive all the data correctly in Tally and in the Tally module on Make.

In parallel, I created my Airtable base very methodically, making sure all field mappings correspond correctly. For the “single select” questions in Airtable (which correspond to Tally’s multiple choice questions but where only one answer is possible), I carefully created the corresponding options.

Then, I set up an Airtable Get a Record module linked to my Tally module.

However, I’m facing a major problem during the mapping:

  • I have mapped all the answers to their corresponding fields.
  • But none of the multiple choice answers get sent to Airtable.
  • I systematically receive this error:
    [422] Insufficient permissions to create new select option

What could be causing this, knowing that all the options are correctly written in the related field in airtable.

Previously, I managed to make it work by understanding that the data coming from Tally arrives as an array, and that I needed a certain formula to extract the answer for the multi-choice question (with only one possible choice).

Chat GPT had given me this formula:
{{get(answers.“Is there any certified divers in your group?”, 0)}}

I typed it manually, and it worked! But then it stopped working after about three days.

I’ve tried everything since, but nothing seems to fix it.

Could anyone please help me figure out what’s going wrong and how to solve this?

I have the free version of make, and I am a beginner… I have tried through a set variable module, but I can’t make it work, as the answers from Tally never gets into the module.

Any insight would be truly appreciated.

Thanks in advance!