Help

How to keeping adding to the same record using Airtable REST API

Topic Labels: API
Solved
Jump to Solution
973 4
cancel
Showing results for 
Search instead for 
Did you mean: 
RSk
6 - Interface Innovator
6 - Interface Innovator

Hi, I’m currently developing a WhatsApp chatbot using Node.js. I’m implementing a functionality where the bot stores the specific responses from the users in airtable columns. But when I was going through the community I found out that it’s not yet possible to create columns programmatically. So for time being, I wrote a program that updates the field say Responses

The problem I’m facing is when I call the update function it overwrites the existing record. Is there a way I can append the new value to the existing record without overwriting the old value?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

You’ll have to retrieve the old value first and append the new value to it. There isn’t a way to issue an API call that will append field data. All updates are replacements.

See Solution in Thread

4 Replies 4
Justin_Barrett
18 - Pluto
18 - Pluto

You’ll have to retrieve the old value first and append the new value to it. There isn’t a way to issue an API call that will append field data. All updates are replacements.

Oh okay, Thank you for the reply. Appreciate your help.

Hi, is there a way I can create columns programmatically? I read the scripting document but it only allows using the Scripting App. Any alternative or way to create columns using Node.js?

Fields can also be created in custom extensions (extensions used to be apps which used to be blocks, and the SDK is still called the “blocks SDK”):