Assistance with Custom Attendance Report in Zoho People

Assistance with Custom Attendance Report in Zoho People

Hi,

I created a custom report in Zoho People 5.0 to track employee attendance according to our specific needs, as the existing reports do not include all the required details. However, I’ve noticed that the report doesn’t update continuously or on a daily basis. Instead, it seems to align with the pay period, where the smallest available interval is a week.

Is there a way to ensure the report updates daily with the latest attendance data?

Thank you in advance for your guidance!

Best regards


    Access your files securely from anywhere


            Zoho Developer Community




                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day



                                          Zoho Marketing Automation
                                                  • Sticky Posts

                                                  • Team Zoho People in your city!

                                                    We are back with our next series of community events to meet you at your city! We are delighted to invite you to join us for a day of insightful sessions, interactions with other Zoho People users, and one-on-one sessions with our product experts. This
                                                  • Come, join our HR Community!

                                                    Hello everyone, We are delighted to invite you to join the HR Community, an exclusive forum for HR professionals around the world to collaborate, learn and grow together. In the HR community, you will be part of a tight-knit HR group, wherein you can,
                                                  • Ask the experts: A 5-hour live Q and A session on Zoho People

                                                    We are back with the 'Ask the experts' session of the month! Your platform to get instant answers to your questions on Zoho People is now open. Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions. What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions.You can start
                                                  • Ask the experts: A 5-hour live Q and A session on Zoho People

                                                    The awaited 'Ask the experts' session of the month is here to give instant answers to your questions on Zoho People.  Our team of experts is here, on a continuous 5-hour stretch, to answer and give expert solutions.   What to ask? Your questions, doubts or any hiccup revolving Zoho People. If you do not have any questions, you can follow the post to add it to your knowledge.   Where to ask? Simply use the comments' space of this post to type in your questions. You can start posting your questions
                                                  • Webinar: What HR should be doing during this pandemic

                                                    These are testing times for organizations, especially for Human Resources. From the reallocation of resources to finding new ways to manage a remote workforce, there are so many things that HR should be focusing on right now. Now is when expert advice can help. Join us for a free webinar and hear it from one of the leading industry experts, Nick Holley, on what HR should be doing during this pandemic.  This will be a partially interactive session where Nick will answer your questions once every 10


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • geographic search filter in map view

                                                                                                    Hi, I have a recruiting and timesheet system built in Creator. The client wants to enhance the search for candidates based on their location and filter by job skills - currently they look on the Map View which uses the geo location or post code of the
                                                                                                  • Execution failure when fetching a Name field from another app

                                                                                                    In creator I have one app [Employee Directory] with a form [Employees]. One of the fields is a name field called [Name]. Here is a sample that works, if executed from the Employees app: test_Employee = Employees[Name.first_name == "Alex"]; info test_Employee.Name;
                                                                                                  • Zoho Payroll US?

                                                                                                    Good morning, just reaching out today to see if there's any timeline, or if there's progress being made to bring Zoho Payroll out to be available to all states within the USA. Currently we're going through testing with zoho, and are having issues when
                                                                                                  • Sort By Date - Deluge

                                                                                                    I have the following code, which normally works to sort calls by created time. Every once in a while, it doesn't work and something sneaks through in the wrong order and I can't figure out why. calls = zoho.crm.searchRecords("Calls","(Owner:equals:" +
                                                                                                  • Zoho CRM search not working

                                                                                                    The search bar is not showing any results in our CRM installation. We have a lot of items and can not search them by using the navigation each time. Can someone please check this asap.
                                                                                                  • Reload page with widget

                                                                                                    Hi all, I hope I can find some help here. I developed a small widget for Creator that is integrated into a page as a component. The page contains other content as well. When the widget is sent, the entire page should be reloaded to apply the changes to
                                                                                                  • Tip of the week #37 - Manage all your Telegram business conversations directly from your shared inboxes.

                                                                                                    Tired of switching between multiple apps to manage your business conversations? With Zoho TeamInbox's multichannel inboxes, connect your Telegram channel to a shared inbox. This way, your teams can easily handle c View, reply, and collaborate on them
                                                                                                  • Tags on notes aren't syncing correctly on Android

                                                                                                    I've created notes on the desktop version that have several tags assigned, but on both my Android devices those notes only have ONE of those tags instead of all of them, despite the actual content of the note being correctly synced, and I'm also starting
                                                                                                  • Reports - custom layout - duplicate report

                                                                                                    Do you also have this problem and what is the possible solution? I duplicate a report that has a "custom layout". Unfortunately the custom layout is not duplicated. To be improved for a future release by Zoho. I export the custom layout and import it...
                                                                                                  • "Copy Field Values from one Module to another" how to use?

                                                                                                    Hi everyone! I'm sorry if this question was already asked, I didn't find it! So let me explain:  In my Tickets module, we have the custome field "customer type" where we indicate if it's a lead, user, etc... In the Contact module I used the "type" field with exactely the same entries. I would like when in the tickets module an operator choose an option that it automatically update it in the contact module. I found the "Copy Field Values from one Module to another" custom function which seems perfect
                                                                                                  • How to map a global picklist from one module to another

                                                                                                    Hi there, i currently have a new field that is called sales office which we use for permission settings between our different offices located in different countries. It is a global set picklist with three different options: MY, SG and VN. I want to be
                                                                                                  • Schedule meeting monthly on a particular day

                                                                                                    Suppose I wanted to schedule HR meeting every month on the first Tuesday with each employee separately for 20 minutes each. How could I automate these type of meetings? And if Sunday occurs on the first Tuesday I would like to shift that meeting on next
                                                                                                  • Pageless mode needed to modernise Writer

                                                                                                    When we switched from GSuite to Zoho, one of the easiest apps I found to give up, was Docs. In many ways, Writer has always been more powerful than Docs, especially in terms of workflows/fillable forms/etc. However, I went back into Docs because I notice
                                                                                                  • Is it possible to Select Item Serial Numbers from a Sales Order?

                                                                                                    Our accepted estimates are converted to Sales orders for our warehouse staff to pick.  How can my warehouse staff select the serial numbers for an item when editing a Sales Order?  Logically when staff pull an item and have the serial in front of them they update the Sales Order and select the serial. I understand a serial can be added when creating an invoice but how can accounts team know the serial if the warehouse staff can't select it! A basic flaw!
                                                                                                  • MORE BUGS: Client Script, Deluge and Widget JS SDK don't work as expected when trying to retrieve a record that has been "rejected" as part of an approval process.

                                                                                                    Client Script $Page.record is null when accessing a record that has been "rejected" as part of an approval process. Deluge zoho.crm.getRecordById(moduleName, recordId) returns {"status":"failure"} when recordId is a valid, but rejected record. OK... I
                                                                                                  • Zoho CRM Widget not displaying 2 related lists (JS)

                                                                                                    Okay so I basically have 2 relatedLists that I want to get and render: ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity, RecordID: data.EntityId, RelatedList: "Notes", page: 1, per_page: 200, }) ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity,
                                                                                                  • Zoho Books and Zoho Projects Task Status Update

                                                                                                    How can we create an automation using custom functions for the following scenario. When our zoho books invoice status changes to paid. I want a task in Zoho projects to change to completed.
                                                                                                  • Zoho Books Estimate to Zoho CRM quote?

                                                                                                    I'm not sure why this isnt automatic, but maybe I'm missing something. When we create a quote in zoho books we have a custom function that pushes the contact into a deal within the CRM. I can not for the life of me figure out how to push an estimate from
                                                                                                  • Different content per social media account..

                                                                                                    Is there a way to add different content per social media account on one post?
                                                                                                  • Assigning Tasks and Requests to Groups... how do I?

                                                                                                    Guys, I've spent many hours exploring Zoho Support and we are generally satisfied with the system.  I'm trying to understand how a system that has so much to offer can be missing GROUP assignment and queue functionality.  I am hoping that there is a way
                                                                                                  • Parsing of SQL query failed. Please check the SQL syntax.

                                                                                                    I am trying to have Zoho Analytics recognize that if the a Deal is in Stage "Need Docs" it should also be counted as a Deal in the Stage "New Lead" /*New Lead*/ SELECT "ID" 'New Lead' AS "Stage" From "Deals" Where "Stage" = 'Need Docs' Union All Error
                                                                                                  • Where is the setting to enable/disable 2FA?

                                                                                                    The following links show where enable/disable 2FA is supposed to appear, but neither appear for me: https://help.zoho.com/portal/en/kb/zohosites/faq/account/articles/how-do-i-enable-or-disable-two-factor-authentication-for-my-account shows Security >
                                                                                                  • How to Assign Record Ownership in a Custom Form via API?

                                                                                                    Hello everyone, I’ve created a custom form in Zoho People and I’m using the API to manage its records. I would like to know how I can assign ownership of these records to specific users via the API. Is there a specific parameter or field in the API request
                                                                                                  • Customer Statement Template not matching when sending

                                                                                                    Hi everyone! So when I send statements to our customers via Zoho Books, the message that appears by default does not match what I have written on the template Under settings -> email notifications -> sales -> customer statement We have a single default
                                                                                                  • Creation of Path and subpath

                                                                                                    In order to improve the structure of the website for better organization, I would like to consider that when publishing a page, it can be within a section and sub-section. For example, if I have an events option in the menu, I can put past events and
                                                                                                  • Working with keywords

                                                                                                    Hello everyone, first time here so I will try to be brief. I am working on my company's data set. I have a table with all the images we have on line. For each image we hava a cell tha contains all keywords related to that image. I would like to explore
                                                                                                  • Emailing lookup field but placing this as an ID or number rather than text

                                                                                                    Hi there, First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code. We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form. In
                                                                                                  • Unlocking New Horizons: A Year in Review

                                                                                                    As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,
                                                                                                  • Using AVG in SQL Query

                                                                                                    My current SQL Query is: SELECT "Client Info", avg("Revenue") FROM "Funded Deals" GROUP BY "Client Info" The current table that this is creating: Client Info avg(Revenue) Previous 4175 1st - New 3411 1st - Old 3013 Renew 3069 While this works as I had
                                                                                                  • Peppol Malaysia API

                                                                                                    Hi Zoho Books, my country Malaysia will going to implement "Peppol" (E-Invoicing), starting 1 Jul 2025 for all businesses. The government intends to provide API for accounting app. The workflow involves creating an invoice from accounting app, triggers
                                                                                                  • Re-emitir facturas con nueva dirección de facturación

                                                                                                    Hola, necesito saber si es posible que las facturas ya emitidas, pueden ser re-emitidas con el cambio de dirección de facturación, realizado el día de hoy 02-01-2025, para efectos contables. Espero su ayuda, Gracias
                                                                                                  • Zoho Learn vs. Trainer Central

                                                                                                    Hi, I'm currently using Zoho One with a WordPress-based website and WooCommerce to manage my online courses. I would like to know what is the difference between Zoho Learn and Trainer Central and if it's possible for these two platforms to replace WP
                                                                                                  • Map Plan to Different Income Account for Some Subscriptions via API

                                                                                                    We have a plan that has a default Plan Account of "Sales". Can we override the account for a specific subscription via API? In some instances the same exact plan should map to a different income account. When we create stand-alone invoices in Zoho Books,
                                                                                                  • Flow with CRM

                                                                                                    Hello, I have a simple flow that uses a web hook to enter data into a Sales Order. I have the web hook sending Flow data which has a PO field. If the PO has a special character like - or / or \ the task fails. How can I get the flow to be okay with the
                                                                                                  • Enter dates in tasks with just "tue" or "+10" or "5d" ???

                                                                                                    Is there any way to enter due dates in tasks without typing the whole date or making time consuming clicks in the calendar? I don't see anything online in the help or third party videos.
                                                                                                  • Chrome browser issues. Anyone else?

                                                                                                    I am suddenly having multiple issues with Chrome browser interpreting the Zoho Mail interface.  Anyone else?  Any known problems? Thanks, Todd
                                                                                                  • Set another Layout as Standard

                                                                                                    We created a few layouts and we want to set another one to standard:
                                                                                                  • Set up multiple IMAP email addresses

                                                                                                    Hi, I just started using CRM and its great, but I just found out I can only add one imap email address for incoming mail in the included salesinbox ...this is ridiculous. All companies have different email such as sales@domain, info@domain , personal@domain
                                                                                                  • Function 58: Custom calculation in item table of invoices (2 fields)

                                                                                                    Hello everyone, and welcome back to our series! In Zoho Books, the Item Amount in invoices is calculated by multiplying the Quantity and Rate fields. Previously, we shared a function to include a custom field in this calculation. Today, we are taking
                                                                                                  • Tracking new lead response time

                                                                                                    Hi, I have a team of Sales Development Reps, who have a KPI of responding to a lead within 20 mins or less once it hits the system.  I seem to recall that Zoho CRM had the capability to track this in a previous version, but don't see it anywhere.   It's
                                                                                                  • Next Page