How to share data between multiple sheets

With Data Sources, you can pull information into multiple sheets from one master sheet of products, SKUs or items.

On scan, the app will search the data source for a match and if a match is found, it pulls the data down to the device and saves the new entries to the child sheet.

Let’s go through how to set one up.


1. Open Integration settings

Click on the 'Integrations' button at the top of the sheet
Click on the 'Integrations' button at the top of the sheet

Start by opening the Integration settings on the sheet you want to add the data source to.


2. Select Data Source

Selecting a master sheet as the data source
Selecting a master sheet as the data source

Then click the drop-down icon and you’ll see a list of all the sheets available to you. Pick the ones you want to query on scan.


3. Match the column names

Ensure that column names in both the data source and the child sheet are identical
Ensure that column names in both the data source and the child sheet are identical

Lastly, make sure that column names in your data source are identical to the column names that you want to pull data into.

In the image above, the VIN and Make columns match, but the Model and Model Year doesn’t exist in the child sheet. As a result, only the data from the Make column will populate on the device when a matching VIN barcode is scanned, and the remaining fields will appear empty.


4. Save the changes

Click save to confirm the changes.
Click save to confirm the changes.

Finally, save the changes and you’re done.


Questions about the Data Sources?

We’re always happy to help, chat with us live or drop us an email.

Ready to start scanning?