Bulk add sample results (asbestos surveys) | Features

Bulk add sample results (asbestos surveys)

Paul King

As a dashboard user, I'd like to add multiple sample results at once, so that I can save time when entering results from the lab. At the moment, adding results for large jobs can be time-consuming since results must be added individually.

May 24, 2021

Paul King

If you can obtain results from the lab in a spreadsheet format, they can now be added in bulk using our new 'Import Data' feature.
Import Data from Spreadsheet
We are also exploring ways to extract sample results directly from the PDF Bulk Sample Sheet using Artificial Intelligence.
Sample Capture from Bulk Sample Reports

Paul King

I think the best solution for this would be:

Tabular data entry where you can "tab" to the next row (like a spreadsheet).
Ability to import data from a spreadsheet.

The first approach would be my preference here, since it keeps everything within Flow. It would also be an improvement on

any

section with multiple items. e.g. it could speed up data entry in lots of places.

Stacey Fordham

Paul King: I can see that the tabular entry could speed up the process as i assume the sample id etc will be there and i just need to amend the fibre type?

Paul King

Stacey Fordham: Hi Stacey, yes that's right, but we have a separate feature request for the type of cross-table foreign key lookup you're referring to:
Lookup sample ID's in register when adding sample results
You already have a +1 vote on that feature.
The "lookup sample ids" feature combined with this one will speed things up considerably when adding sample results!

Mark Malone

Feedback from David King

I think the best solution for this are the following:

auto-comboboxes
spreadsheet uploads

I think the auto-comboboxes will be a huge improvement for data-entry so should be high-priority :)