Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to add the new value to the existing value using Airtable automation

141 2
cancel
Showing results for 
Search instead for 
Did you mean: 
RSk
6 - Interface Innovator
6 - Interface Innovator

Hi, My Airtable use case is to maintain Farmer’s finances. We have developed a WhatsApp bot, and by using webhook triggers the information gets stored in Airtable.

image1_airtable.png

I am using webhooks to populate the Expense Amount field. For eg: The bot asks the question about the Expense Amount, as soon as the user answers this question, the webhook triggers, and the value of the Expense Amount gets updated.


What I am trying to achieve is, if the User enters the Expense Amount for the same expense type, the field should add/sum the new value to the previously populated value.

 

For eg: If the user John, enters the Expense Amount for E1 as 200 again then the Expense Amount field should be 300(100 + 200).
I want to append the new incoming values in the field and not overwrite it. 

Any advice or help is appreciated

2 Replies 2

Can you provide more details on what your webhook currently does? Does it create a new record, or does it find the existing record and overwrite the values? What platform are you using to make these data changes?

I also recommend considering a new linked table where all transactions with the same user and expense type are linked to the same record, and then use a rollup field to sum the values. This will preserve the individual record data and also provide you with the sum.

I have edited the question.

1. The webhook updates the Expense Amount field. 

2. WhatsApp is our source of information, all the information gets stored/ updated based on the bot flow.

 

Can you please guide me to some articles or similar implementations for reference?