Google Sheets + Ubiqod + Formatter by Zapier + Filter by Zapier
Track working time in Google Sheets when new Ubiqod QR codes are scanned
This integration can save you a ton of manual data entry work. If you want to track worker arrival and departure times in the field, this Ubiqod-Google template automatically adds a RAW file at arrival and updates the file at departure.
This integration can save you a ton of manual data entry work. If you want to track worker arrival and departure times in the field, this Ubiqod-Google template automatically adds a RAW file at arrival and updates the file at departure.
- When this happens...New Data [UBIQOD V1]
Triggers when an IoT button is pressed or when user submit data from a Qod.
- automatically do this...Date / Time
Work with dates and times to change formatting or add/subtract time (with line-item support).
- then do this...Only continue if...
Set up rules to specify when this Zap can continue running.
- then do this!Update Spreadsheet Row
Update a row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Ubiqod
Ubiqod is a traceability platform for tracking field activities with IoT, static and dynamic QR codes.
Related categories
About Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
About Filter by Zapier
Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.