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
About 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.