Airtable add or remove amount in a cell

[Choofa]

Have a look here:

How to delete row in airtables from list?

Hi there. I struggle finding out how to delete rows I select in my list. Any suggestion? Here’s the blocks I use for getting the data, and there are 2 columns, "Antall " and "Produkt " that’s being stored together into Global Variable Liste by numbers. But when I ex. select Banana in list, I want the row starting with banana deleted in Airtables, but then I guess I need to know what number it’s on? How to to this? [how%20to%20delete%20from%20airtables]

I’ve tried a few searches and watched a few videos in the community to try find a solution but I havn’t find the correct one for me.

In my new project I have almost similiar blocks, but this time I don’t want to delete the row, I want to add or remove a given amount from 1 cell in a row.

Like, in the other thread I have Handleliste_Antall (Shoppinglist_Amount) where I put in the amount of e.x. bananas.

But if I put in 30 bananas, I’d like to have the possability to add 10 more or remove 15 WITHOUT deleting the row, cuz I need the list in spreadsheet to stay in the order it is. Else it would be easy for me to just make blocks to delete the row and add a new one with same data but new amount.

Any easy doing for this?

[conmed55 (Ariel Conmed)]

You can try to find the position of the row where the value is, then you store the value in a variable and you add or subtract that variable with another value and replace it in your table

[Choofa]

Hi @conmed55

I’ve started a new project for this testing and here’s my blocks, but I can’t figure out how to put it correctly or what blocks I should use, any ideas?

[Vaibhav]

Hey @Choofa Can you provide the aia here or in personal so I can try something on that?

[conmed55 (Ariel Conmed)]

It would be nice to check all your blocks to find out where your TextBox1 comes from. Plus what the operation you’ve done is. If you want you can write to me privately or talk to me by telegram

[Choofa]

Testing.aia (262.2 KB)

Here’s the aia file. I have removed the API and Base ID in Airtable since it’s to my personal spreadsheet

What I want is if the cell contains the number 10, and I write 2 in the textbox I want the cell to become 12 if you know what I mean

Ty for taking your time again to help me out @Vaibhav

[Choofa]

Well, in the picture you see all the blocks since I started a new project only for this testing
Read my previous post to @Vaibhav where I published aia, if you want you can also try something out and give me a solution if you got the time for it

[vknow360 (Sunny Gupta)]

Hi @Choofa
Update row will update row of particular column(s).
And you want to update cell.
So do it like this:

[Choofa]

Makes more sence ofc
Always a pleasure getting help from you!

Thnx