Working With Google Sheets
Ventipix Asset & Inventory Manager platform supports three interactions with Google Sheets.
You can choose to have the platform sync a copy of your data as it is at the current moment. This only works whilst you’re logged in to your account.
From the tables, go to Options > Sync With Google Sheets.
You will then be shown this prompt.
Fill out the form accordingly, then click on the Sync button.
This type of syncing works whether you are logged in to your account or not.
Any data that you create is automatically synced to the nominated file.
Note – the nominated file should not be edited manually as the platform will not be aware of the changes you made and may overwrite your data.
From the Apps page, click on the Settings button.
Fill out the form.
- File Name – Choose the file that we should sync to.
- Services to be logged – choose the type of services you want to be synced. Each chosen service will be created as a worksheet, on the chosen file, and whenever you create data on the platform, the same data will be synced.
- Status – indicate whether you want the syncing to be active or not.
Sending barcode scans or NFC tag taps directly to Google Sheets
Tap on the Scan to Spreadsheet button, on the pages that display it.
On the new page, choose Google Sheets from the dropdown options.
On the prompt that appears, fill out the form with the relevant details.
Scroll down that pop-up, to continue filling out the required details.
Refer to the notes beneath the input fields.
Once you click on the Start Scanning button, the paired device will be ready to scan or tap NFC tags.