Update QTY if QTY has already been added

Ask for Help
1

Hi there fellow Gliders.

I’m building a collection tool where users can select items from a predefined list and add how many they own of a specific item.

I’ve got a product list sheet and a sheet for any rows that a user adds for their own inventory. The idea is that I can see what items I and other people have.

The issue I’m currently facing is that I can get the tool to add a row to add a quantity owned of a product but I can’t get the tool to let them modify the number if a QTY has already been determined is just adds a new row on submission.

Can anyone help?

Many thanks,
Mark

2

To edit an existing row, you should use an Edit Form rather than an Add Form.

3

Hello,

The ideal would be that each item has a row ID, when adding the item to the new list with the quantity that each supplier has, copy the Row ID of the item in a designated field, this so that you can make a relationship in your main table of products and then perform a rollup of the quantities, it is not recommended that other users make changes directly manually, you can also add with the filters that users do not duplicate the items if they already exist in the list,

4

Thanks for the responses.

Just to clarify, I’m looking to build a one to many relationship where multiple users can have their own quantities for a stock item.

E.g

Product
Nike trainers 360

User 1 | Nike trainers 360 | QTY 2
User 2 | Nike trainers 360 | QTY 6

5

Sounds like you should allow users to have a form to submit rows to the Inventory table. Make sure you also record their user ID.

Then, display the Inventory rows to them, and allow them to edit on that row.

At no points should edits be made to the Product row.