Add new products = Copy the key fields and continue add more products

Hello Everyone,

In our company we are developing an inventory tracker, I already setup a basic and simple tracker, however there are times that they need to add more product.
I made it work however the spreadsheets would have to have a long list of Product #2…Quantity #2… and etc…

Is there an easier method to get this done?

Rather than a repetitive column, i though a conditional rule instead, if “Yes” is selected to Add more, to copy the previous field already added such as PIN, Patients Name, 1st Product added and Quantity, then add new row to just ask them for the same question, therefore it already copied the previous selection and its like they are adding a new record without leaving the current view.

Thank you in advance!

0 1 93
1 REPLY 1

Steve
Platinum 4
Platinum 4
Top Labels in this Space