Need Help With Inventory App Airtable Quantity Update

Discuss
, ,
#1

Hello.
So I am making an Inventory app for my organization and everything is laid down fine as to how I want to make it.

I am using Airtable to keep data records of the Inventory app -

These are the columns -

  1. Item Name
  2. Quantity
  3. Unit
  4. Category
  5. Stored In
  6. Date & Time

Now, if I want to update the quantity of a certain item (let’s say I had 3 Quantity and I want to add 1 to the existing 3 quantity to make it 4.
OR
I want to issue (delete) the quantity and reduce it by 1 to make it 2.

How can I do such operations with the blocks.

This is the concerned section of the blocks I am struggling with -

blocks (20)

blocks (21)
blocks (21)903×177 16.1 KB

I don’t know what to enter in the Row Number. This is the block that I could find that could do this operation according to me.

Please help me! (I can also provide AIA)

#2

Horizontal lines are called row number.
Here you can enter index value of row

#3

Almost you got it. But you forget which item you want to update it… That is the problem.

#4

But how do I know the index number when there is no serial of any Item being added in Airtable in the first place. I want to update the row based on the item name.

#5

Please can you send me airtal screenshot

#6

I want to update the Quantity “Cell” of a particular Item (based on the Column - Item Name)

#7

add the item name as a list or, if the user want to update name of the item (say samsung, oppo, Sugar…) each item have unique row number use that… Everything is there in your hand

#8

image
image1366×768 83.1 KB

#9

I want to add or subtract the quantity of a particular item.

#10

if the user want to update name of the item (say samsung, oppo, Sugar…) each item have unique row number use that… Everything is there in your hand

#11

For example you have added 5 entry in spreadsheet.
Like

  1. Geometry
  2. Register
  3. Pensil
  4. Books
  5. Pen

And you want to change the quantity of pensil. Then pensil has index number 3.
So enter the row value 3

#12

yes, absolutely

#13

I think you did not fully understand the issue.

#14

This post was flagged by the community and is temporarily hidden.

#15

but the problem is, if you try to update with that blocks the exact cell will update but the remaining cell value of the row will vanish. So dont use update method. try this combo

image

#16

This is potentially useful.
Download the element names and then add to the list variable,
then use the list extension to search for the item, fetch the index,
put the index and use it as you like.
Create a timer to banish problems