The app allows sending data from your phone to your Google sheet quickly. After that you can make any future manipulation with data on your Google sheet. Perfectly fit for inventory, track attendance, finance and tax purpose, collecting QR codes to spreadsheet and beyond
This is how the process will look like in Spreadsheet data entry:
List of input types opens up. Each input field has specific data type (Text, number, QR code scanner, date, geolocation, etc)
Fill the data
Launch form
1
Tap send
2
3
Data saves to the spreadsheet on your Google Drive
4
5
You can do the record any number of times. [Repeat it if needed]
Launch form
List of input types opens up. Each input field has specific data type (Text, number, QR code scanner, date, geolocation, etc)
1
Fill the data
2
Data saves to the spreadsheet on your Google DriveДанные записываются в таблицу на вашем Google диске
3
Tap send
4
5
You can do the record any number of times. [Repeat it if needed]
How to configure the app?
To be able to write data into spreadsheet:
Set spreadsheet URL and sheet name
Then add input field
Set data type for that input
You have to create form
1
2
3
4
For example, we need to do inventory by scanning QR codes
5
Data saves to the spreadsheet on your Google Drive
6
Choose QR code as a data type for the input field
Set column - A
7
8
Scanned QR code will be written to the first available cell in column A
You have to create form
Set spreadsheet URL and sheet name
1
Then add input field
2
Set data type for that input
3
Data saves to the spreadsheet on your Google Drive
4
5
For example, we need to do inventory by scanning QR codes
Choose QR code as a data type for the input field
6
7
Set column - A
Scanned QR code will be written to the first available cell in column A
8
Also, you can select a form template from the library
Open library, select template "Inventory with QR/bar code" and tap "Add to my forms"
Added form will appear on My forms screen. Template's spreadsheet will be added to your Google Drive. If need you can edit spreadsheet and form, for instance add or rename column in Spreadsheet
To make app work, you need to connect your Google account in the app. Save data would be possible only into spreadsheets which you can edit access
Added form will appear on My forms screen. Template's spreadsheet will be added to your Google Drive. If need you can edit spreadsheet and form, for instance add or rename column in Spreadsheet
To make app work, you need to connect your Google account in the app. Save data would be possible only into spreadsheets which you can edit access