How to update multiple records simultaneously in the specimen bulkloader

Go to Browse and Edit

Screen Shot 2019-04-19 at 8 29 53 AM

Select the recordset that contains the records of interest

Screen Shot 2019-04-19 at 8 30 13 AM

Choose the SQL option.

Read this; it’s important.

Screen Shot 2019-04-19 at 8 31 55 AM

If you need additional filters, use the top pane.

Screen Shot 2019-04-19 at 8 33 05 AM

After clicking “filter” and waiting for the reload, records are now filtered for MVZ:Mamm (from the initial selection) AND a particular user (copied from the data).

Use the bottom pane to update individual fields. This will update ALL records in the view below. You must choose a column and provide a value.

Screen Shot 2019-04-19 at 8 35 15 AM

Doublecheck, triplecheck, click “update.”

Screen Shot 2019-04-19 at 8 35 58 AM

All records have been updated.