How to Create a Duplicate button for Records ...

(Julie Norton) #1

How to Create a Duplicate button for Records

How can I create a duplicate button? Example: While placing items in inventory, the user creates a record with all the fields completed - for the next 100 items he needs to inventory,

all the fields will be the same. The only thing that will change from record to record is the serial number. In the app how can this be achieved without creating all records 1 at a time?

(Reza Raoofi) #2

You cannot add multiple rows to a table at once, but you could have create an action button and set its Do this parameter to: App: copy this row and edit the copy

This will save you a lot of data entry in all fields.

(Marc Dillon) #3

In addition to what Reza said, change the form’s submit behavior to activate that action.

Also, how are the serial numbers created? Is it a formula, or incrementally? If you use linktoform() expression instead, you can set an expression that can increment from the previous record, or create a uniqueid() for each serial number. So a user would just have to press save 100 times.