Dear Olena,
I’ve done that through Make (former Intergomat).
-
You need to open an account in Make: https://www.make.com/en . The first to scenarios are free, so you can try this solution with a couple of forms.
-
In Make, you start from scratch with a blank scenario. First element you add is a Custom Webhook:
-
Click on Add on the Pop-up window and copy the webhook address:
-
Now go to Kobotoolbox and open up the form you want to link. Navigate to SETTINGS:
-
Then click to REST SERVICE on the left menu and on REGISTER A NEW SERVICE:
-
On the pop-up that open give the Service a Name and paste the link of the Make Webhook:
then click on Create -
Open the survey in kobotoolbox and answer it, leaving no empty field. That is very important, so that the webhook can determine the data structure of the survey and you can associate it with your airtable base.
-
Now Make receive the data of the survey that are answered!
-
It’s time to connect airtable to make. Go back to the Make Scenario maker, click on add another module and search for airtable:
then click on Airtable and then Click on Create a Record. -
You need now to connect make to your airtable base via the API token (more info on how to get it if you don’t know how here). In Make, on the airtable module click on add, give it a name and copy paste the API key form airtable. Then click on SAVE.
-
If all it is good now you can chose the base and the table you want to link in the menu of the module and the record list will appear:
-
Now in order to map the kobotoolbox answer to the airtable base you need to run the scenario once:
-
Open up your kobotoolbox form again and send through another test form with all the answers.
-
Now go back to make and open up the airtable module, when you click on a record field a list with the fields of the kobotoolbox form answer will appear, chose the variable that need to be associated, to each field:
-
Once you are done save all and activate your scenario :
-
Make a test in order to see if all is working correctly :winking_face:
Let me know if you are able to set it up and if you have any other question, I’m glad to help.
Claudio
Hi Claudio - I used your wonderfull screenshots and explanations to make my first connections from Kobo to Make!
I wanted to ask about an error that I am receiving. From one survey in Kobo, three different records are made, which are linked. For example, we are registering a farmer (creating a farmer record), and then creating a garden linked to that farmer (creating a garden record), and then creating species records that are linked to the garden. The Farmers are being registered in a separate base, and then referenced in a different base. When I try to make the second record that is linked to the first, I get this error “You are not permitted to perform this operation because the table “People - Gardens” (tblOgQnKHegAIlPZx) has been configured to limit who can perform this operation” - I think this is because “People-Gardens” table is synced from another base.
Any ideas on where I am going wrong?
