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

Development and integrations API
, ,
#1

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?

#2

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.

1 Like
#3

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

#5

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?

#6

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”):

#7

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.