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.

6

Thanks for your help - I’m still struggling to build it so that the user can edit the form for the inventory row on the product page. Ideally I want the product page to display their own quantity that they add and then also if they edit it it will update.

7

I think you can do it like this:

  • In the Products table, add a Query to the Inventory table that filters by: userID is signed-in user’s rowID, and productID is this row’s rowID.
  • That would give you a list, or in your case you might only need a single row, of inventory entries the signed-in user has added for the product they’re viewing.
  • Display it in the details view of Product with a collection, and allow the user to edit the collection item (show edit screen).