---
title: How to file a reviewed job into your own SharePoint folders
description: Connect Stratum Track to your SharePoint or OneDrive once, and every job you review sends its reports, documents and photos into your own folder structure without anybody downloading or filing them by hand.
published: 2026-09-01
updated: 2026-09-01
---

# How to file a reviewed job into your own SharePoint folders

Your quality system says the job pack lives on the server, in the client folder, in the
year folder. So somebody reviews a job, then downloads the report and the photos and
files them by hand. That filing takes about ten minutes a job, and it gets skipped when
the week is busy.

Stratum Track connects to your SharePoint or your OneDrive, and files the job for you
the moment you review it, into the folder pattern you set.

This takes about half an hour, most of which is your IT person doing a one-off setup.
You do it once for the company.

## What you need

- A manager login, and someone who administers your Microsoft 365. You will not need them again after the connection is made.
- The integrations feature switched on for your company. Ask us and we will turn it on.

**Nothing leaves Stratum Track until you turn an automation on.** Making the connection only lets us reach your folders.

## Step 1: Make the connection

Go to **Settings**, then **Integrations**.

![The Integrations page in Settings, with one connection and two automations](/assets/screens/integrations-01-settings.webp)

Press **Add a connection**. One connection covers OneDrive and SharePoint, and it serves
as many automations as you want, so you set it up once.

![The Connect to Microsoft 365 page, with the details an IT person supplies](/assets/screens/integrations-03-connection.webp)

The details on that page come from whoever manages your Microsoft 365: a **Directory
(tenant) ID**, an **Application (client) ID** and a **Client secret value**. They need
to register Stratum Track, create the secret, and grant access to the site or the
OneDrive you want it to use. Press **Read the guide** and send it to them. It walks them
through the setup in about ten minutes. Your progress on the page is saved, so you can
close it and come back with the details they give you.

The secret is stored encrypted and is never shown again. To change it you paste a new
one. Record the **Secret expiry date** they give you as well, so Stratum Track can warn
you before it lapses.

Under **Where are the files?**, choose **A SharePoint site** or **A person's OneDrive**
and paste the address. Then press **Test connection**, which signs in and reads from the
place you chose.

## Step 2: Add the automation

Press **Add an automation**. Stratum Track asks what it should do.

![The New automation page, with the two automations Stratum Track offers](/assets/screens/integrations-02-what-should-it-do.webp)

- **Create jobs from a spreadsheet.** Watches a spreadsheet in your system and creates a job for each new row.
- **Send a reviewed job to a folder.** When a job is reviewed, sends its reports, documents and photos to a folder in your system.

Pick **Send a reviewed job to a folder**, give it a name you will recognise later,
choose your connection, and press **Continue**.

## Step 3: Choose the folder

Stratum Track lists the folders in the place your connection reaches and asks you to
pick the one everything goes under. It makes a folder inside it for each job.

## Step 4: Choose how to file it

Now tell Stratum Track how to arrange the folders inside it. You write the pattern using
the job's own details in curly brackets, and it fills them in per job.

![The folder pattern screen, with a live example of where one job would land](/assets/screens/integrations-04-folder-pattern.webp)

Type `{` and the list of what you can use appears. It includes the job number, the
customer order number, the drawing number, the designation, the material and serial
numbers, the customer name, the mine site, the workshop, the template name, the job
type, the report number, who reviewed it, and the date in a few formats. The screen
shows you what one of your own jobs would produce before you save.

If a job has no value for one of them, Stratum Track writes `unknown` in its place, so
every folder gets a name and no job pack is filed into another job's folder.

## Step 5: Choose what to send

![The Choose what to send screen, with the document, photo and conflict options](/assets/screens/integrations-05-what-to-send.webp)

**Documents**: every document the template produces, which is the reports, the job
safety analyses and the worksheets, or just the main report. Tick **Send a PDF alongside
each document** if your clients cannot open Word files.

**Photos**: as one zip file, as separate files in a folder inside the job's folder, or
not at all. One zip is easier to send to a client. Separate files are slower to send on
a job with a lot of photos.

**If a file with that name is already there**: **Keep both**, **Replace it**, or **Stop
and tell me**. Choose **Stop and tell me** if the folder is a controlled one, where
overwriting a file needs a change control decision first.

Stratum Track then shows you where your next reviewed job would go, and offers to put
three throwaway files in the folder so you can see the pattern before you turn anything
on.

## Step 6: Turn it on, and choose who is notified

![The automation settings page, with the summary, the on and off switch and the recipients](/assets/screens/integrations-06-settings.webp)

**Notification recipients** is the list of people it emails when something goes wrong.
Nobody off that list gets the email, and if nobody is selected no email is sent at all,
though the failure still shows on this page and on the job. Put whoever would otherwise
be filing the job by hand on it.

Then press **Switch on**. From then on, Stratum Track files every job you review. Switch
it off later and it stops checking, and keeps everything it has already done.

## Worth knowing

- **Review is the trigger.** Nothing is sent while a job is in progress or for a job that never gets reviewed, so the folder holds finished work only.
- **The other automation creates jobs.** If your work already arrives as a spreadsheet somebody keeps in SharePoint, **Create jobs from a spreadsheet** watches it and opens a job for each new row. You tell it which column holds the job number, which workshop and template the jobs use, and how often to look: every 15 minutes, every hour, every 4 hours or once a day.
- **You choose what happens to the rows already in the sheet.** Leave them alone, so Stratum Track only creates jobs for new rows, which is what most workshops want. Or create a job for every row, which suits a spreadsheet you have just started.
- **A ready column is optional but worth it.** Name a column that marks a job as ready and Stratum Track waits for it, so it does not turn a half-finished row into a job.
- **This is not a client portal.** The files go into your own system. Whether your client can see that folder is set up in your SharePoint.

## Common questions

#### What exactly can Stratum Track see in our SharePoint?

What your IT person grants it, and nothing else. They register Stratum Track and give it
access to the specific site or OneDrive you want it to use, using your own Microsoft 365
controls. The sign-in secret is held encrypted and is never displayed again after it is
saved.

#### Can one connection serve more than one automation?

Yes, and that is how it is meant to be used. One connection to your Microsoft 365, then
as many automations on top of it as you need: one automation creating jobs from a
spreadsheet, another filing reviewed jobs into a folder tree, and a second tree for a
different client. You only involve your IT person once.

#### What happens if the folder is unavailable when a job is reviewed?

The job is reviewed either way. Marking a job reviewed never waits on your file server,
and never fails because of it. Stratum Track retries a connection that was briefly
unreachable, and when it gives up on a job, or switches the automation off after
repeated failures, the people on that automation's recipient list are emailed. It emails
you once when something breaks and once if it breaks again after recovering, so repeated
failures do not send repeated emails.

#### Will it overwrite a report we have already filed?

Only if you tell it to. **Keep both** adds the new file beside the old one, **Replace
it** overwrites, and **Stop and tell me** sends nothing and waits for you. Choose the
last one if the destination is a controlled folder.

#### Is this switched on for everyone?

Not yet. Integrations are enabled per company. Tell us you want it and we will turn it
on, and we will sit with your IT person for the connection if that is easier than
sending them the guide.