I have a database in airtable.
I have 3 tables, 2 of these are for user and client. They each have multiple single/multiple select field. Some of these field are present in the 2 table.
I have a 3rd table where i store all the value of these single/multiple select field this way:
ID - Category - Value
1 - Gender - Male
2 - Gender - Female
3 - Gender - Don’t say
This Gender field is present on my 2 other table.
Question:
I would like to create an automation for when I add a new item in my 3rd database, like:
4 - Gender - Other
It trigger the automation to map this value in the different field.
So far, i retrieve the value and table id to where these field are located.
I am struggling to see how to inject this new value? what module should i use?
Airtable API / create record? I am not sure as i don’t want to add a data in my database but “modify” my database by adding a new value in a multi select field.
Thanks