Tip 22: How to allow employees to check in and out, and then automatically calculate their total work hours
Hi everyone, Keeping accurate track of employee hours is crucial to smoothly running business. So this week, we wanted to go over how you can automate this whole process using Zoho Creator. With this tip, you'll learn how to set up a page that will make it easy for your employees to check in and out, and help you track their work hours on a daily basis. To do this, let's create a sample application called Attendance App, and show you how you can use it to track the total work hours of each of your
Functionality Issue in Zoho Creator - While opening the Deluge Script Editor
Namaskaram Zoho Creator team, Refer below image. Whenever opening the script editor from workflow editor [ref:Image 1], It should open the script editor page [ref:Image 2], Instead of that, it shows the 'Add New Action' page[ref:Image 3],. if we tried to close it by tap on the cross symbol 'X', It shows an dialog box with two options as 'Close' And 'Cancel' [ref:Image 4],. If we choose 'Close', it's not performing any action. while selecting 'Cancel' the dialogue box closes. To go back, we
Tip 8 : How to dynamically add rows to a subform via script.
Hi everyone, A fortnight has gone by, and we are back with a new tip that would help you dynamically add rows to a subform via script. To understand how to do this, let's put ourselves in the shoes of an event manager. As an event manager, we need to regularly keep track of on-going events and the number of registrations received for each of the events. For this we need to create a form to record the details of all our events. Let's name this form as Events. This form would have the following
Tip 18: How to add scrollable Add Notes field to a form.
Hello folks, In Zoho Creator, the Add Notes field is commonly used for providing instructions or additional information to users, like to display "Terms and Conditions" or other important info. But how do you add lengthy text to the Add Notes field without making the form too long? The answer is to use HTML to add a scroll bar to the Add Notes field. Follow the steps below to add a scroll bar to your own Add Notes fields: Step 1 Drag and drop the Add Notes field into the form builder and click
Stepping into 2020 with a new series — Functions
Hello everyone, We hope everything is going smoothly with Zoho Creator. We are now officially in 2020 - a new year, a new decade, and, a new series to look forward to. Yes, that’s right. A brand new series on Functions in our Creator Community Learning Series. Every month we will take you through a different function that you could create on Zoho Creator to automate a workflow or get a task done faster. We'll pick from a list of functions that our users usually execute on Creator, and each post
Report Output in Creator
I am told by Zoho support that it is not possible to move sections so that they appear in a custom order that might be more productive. If I create a report and realize that I left out a section entry, when I do enter it, it appears at the end of the report. It might be more useful to be able to sort the order of sections appearing in a report in a manner that might be more efficient for the user. This is an almost perfect tool. But if you forget to add something and need it to appear toward the
Introducing InteGreat: A dedicated series on Zoho Creator Integrations
Hello everyone, We hope everything is going smoothly with Zoho Creator. As promised, we're back with another helpful community series, InteGreat. In this series, we will take you through the different steps involved in integrating your Zoho Creator application with any other service, be it a Zoho product or a third-party service like QuickBooks, Zapier, or PayPal. We'll pick from a list of popular integrations, and each post in the series will focus on a different one. If you have any suggestions
Tip 17: How to add an image to the pop-up that appears on successful form submissions.
Hello folks, In Zoho Creator, any time you submit a form or add a new entry to a form, a window appears with the message—"Data Added Successfully". It's the default message shown to all users for all forms that you create on Zoho Creator. In this tip, we'll show you how to add an image along with that default message. Using a Page to add the HTML script Step 1 First, let's create a dummy form and upload the image we want to display in the pop-up window. Now go to the report, right click on the
InteGreat 1: Integrate Zoho Creator with Zoho CRM
Hi everyone, Today, we'll look at how to integrate your Zoho Creator application with Zoho CRM. As you might already know, we offer pre-built integrations that you can use to integrate with most of our Zoho products and other third-party services. So that, you don't have to spend a lot of time writing code to integrate them. Also, you always have the option to use REST API to connect all your favorite apps, if you don't find a pre-built integration defined for it. Understanding the Integration field:
[Webinar] Schedule work orders directly from Zoho Creator
Hey folks, This Thursday at 12 PDT we're hosting a demo of our SmartScheduler, which was previously featured in a Zoho Practitioner webinar. Since then, we've made some enhancements to it to support both appointment and work order scheduling. Chief Solutions Architect James Converse will demonstrate it all, including: Scheduling from a CRM button or from a Work Order in Zoho Creator Scheduling individuals, crews, and equipment usage Easy drag-and-drop interface Google Maps & Calendar integrations
Tip 16: How to mask customer data to ensure privacy.
Hi folks, As users, we often hesitate to share our contact numbers or email addresses, as we don't want to be bombarded by newsletters, promotional messages, or sales calls. In this tip, we'll talk about how you can mask data entered in Zoho Creator applications with just a few clicks! What is data masking? Data masking, in simple terms, is a process used by businesses to hide or replace real data with random characters. Names, addresses, phone numbers, and credit card details are examples of data
Product Image Url
Hi; I did not find a way to add Image Url to crm with deluge script When I add new record to Products. Are there a way to add image url with script ?
Join us in Singapore for a Zoho Creator Community Meetup!
Hi everyone, We're hosting our first ever community meetup in Singapore and we'd love for you to be part of it! Whether you're a long-time customer looking to sharpen your skills, or a new customer looking to learn more about Zoho Creator, this meetup is the place to be. We will walk you through some of Zoho Creator's most important features while sharing tricks and hacks to help you get the most out the platform. At the end of the session, there will be plenty of time for questions and conversation.
Tip 11: How to extract the time from a Date-Time field.
Hi folks, Over the last few months, many of you have been asking for a Time field in Zoho Creator. We realize how important this field is to you all, and we promise to support this as soon as possible. In the meantime, here are a couple of workarounds that will help fetch the time from a Date-Time field. 1. Using the in-built String functions The easiest way to extract time for display purpose is to use a toString() function with preferred time format we need. We shall get the 24 hours format or
Ask the Expert 5: 5-hour live discussion about integrating payment workflows to your apps.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be connected with other services — be it a Zoho product or a third-party service like QuickBooks, Zapier, or PayPal. In this upcoming Ask the Experts, we would like to address all your questions related to integrating your Zoho Creator application with a payment gateway like PayPal, Razorpay, Authorize.net, and more. In this session, we would cover the following topics: How to configure payments using
Tip 1: Avoid the most common error while using a Lookup in Deluge.
Hi everyone, Today, we'll look at how to compare different data types. Like other programming languages, Deluge supports seven different kinds of data types -- String, Bigint, Decimal, Timestamp, Boolean, List, and Map. To perform particular actions, we often try to compare or match two different data types. Let's look at a simple example: In the below given IF condition, we are trying to check if the left expression which is a text field is equal to "Jack". if (input.name == "Jack") { alert "Hi
Date-Time Error on record update,
Hello I have this simple loop script to update a date-time field with a date/time specified. I have the variable being passed in as a DateTime, but im receiving and error that the timechange variable needs to be datetime? It already is? Can you look and see why this is erroring out? //Define the query to locate all the records that match a zip code. query = "Zip_Code:equals:75056"; //Create the list col_leads = zoho.crm.searchRecords("Leads", query); //Date-Time for the record update. timechange
InteGreat 02: Integrate Zoho Creator with Clickatell
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Clickatell. Many of you need to regularly send SMS notifications to your users when a Form is submitted, or based on a specific set of criteria. For example, you might need to send a reminder for a task, or update the customer about an order status, or alert your customer when a payment is due. The solution is to either use the default SMS connection provided by Zoho Creator or create a new connection with any of the
Tip 5: How to dynamically view filtered data on a page.
Hi everyone, A fortnight has gone by, and we are back with a new tip that would help you dynamically create views based on the data entered in a form. The Page builder is one of the most powerful features of Zoho Creator. It helps to represent important information graphically on a single screen. You can create different types of pages that can include various components like panels, charts, reports, snippets, buttons, forms, and embedded links. Now let's look at how you can dynamically filter the