Duplicate a row to save time adding new asset

[roberthstevenso]

Hi,

We have assets in a table, where each row is one or a group of items. For instance, I might buy 10,000 nails from a hardware vendor and store them as one asset in one row.

These 10,000 items are kept as a group by PO number. If someone needs 1000 nails for a project, we make a new record, duplicating the row in the app (i.e. data entry, field-by-field), then update the original row to number 9000 nails, and making the new record for 1000 nails. These are now two different rows in the table, with different keys, but they still have the same PO number. So when I group by PO number, I can always see 10,000 nails, even though they may eventually be split over many lines.

I haven't been able to work if its possible to duplicate the row (i.e. have a button somewhere that copies the entire record to a new line with a new unique key).

If I could do this, I would only need to change a couple of fields in each row (e.g. quantity and location) and everything else would be identical.

How would I best achieve this functionality? I'm a newbie at this, so I'm very happy to hear if there is a better way to handle this (e.g. using some kind of child record or something) to make the same functionality work.

Thank you!

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the following action type.

Actions: The Essentials - AppSheet Help

[roberthstevenso]

Thank you - will take a look.

[roberthstevenso]

Worked perfectly - easy too 😃

Thank you.

[AleksiAlkio]

Another way to do this is to add a child table where you collect all usages. Then you would not need to have the same data twice. The child table would contain just the ID, PO, location and qty.

When you have the child table, system generates a list column to your parent table like [Related usages]. Then you could calculate the inventory value as [Quantity]-SUM([Related usages][Qty].