Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Tip 27: How to upload files to Dropbox using the Dropbox API in Zoho Creator
Hi folks, It's been a while since our last tip. Hope you're all safe and doing well! This tip will talk about the Dropbox API that helps you upload files to Dropbox. It's one of the most common actions that you can perform by integrating Zoho Creator and Dropbox. To understand how this works, let's create a sample application called File Management App and learn how to upload files to DropBox by adding the Dropbox API to a workflow. Application flow The end user will upload a file to the file upload
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
Auto populate to subform by row
Hi Good day I have a Loan Product form in Zoho Creator And it contains more than 10 decision fields. And it's associated with Deals in CRM. Now I want to get the field names of the selected fields. And populated into the subform of the associated deal
Troubleshooting in Creator #3: Deluge execution limit optimization
Dear developers, A Deluge statement execution corresponds to each line of code executed within a certain script. The total number of lines executed to complete a certain task on an action like on success is associated with a Deluge execution limit in
[Community Webinar] Using HTML with Deluge in Zoho Creator | April 29th, 2020
Dear developers, HTML can be an easy way to expand the capabilities of your Zoho Creator applications. From dynamic pages, record summaries & emails, to providing that extra oomph on your forms. On our previous webinars, we have received requests for
information about web site www.WeAreSinging.org
Please send me information about the plan we have on our web site www.WeAreSinging.org ? How many members we can have in member portal? What are the limitation for link the member portal with the database made in creator?
Zoho Creator Bug (Urgent)
When using report filter, the time filter "after" is not correct when used with "toStartOfWeek()". It actually is ">=" the date found instead of ">". Try that with "StartDate_Time after zoho.currentime.toStartOfWeek()" and it will include the Start of
First Working Day of the Week in Australia
Is there a way to change the default First Day of Week in Zoho Creator? Currently it defaults to Sunday but in Australia it is a Monday. This is going to be a huge problem if there is no way to change this for Australian customers dealing with Factory
[RECORDING: Community Webinar] | Build complex reports and documents with a Zoho Creator & Zoho Writer integration | March 23, 2021
Dear developers, Report generation is an essential activity to ensure decision makers have the best information available to be able to monitor and improve performance. Enterprises may need to generate and distribute stakeholder specific documents in
java return statement returns {"output":"TestData","log":"[\"Log Data\"]"} how to get exact return as a output?
import java.math.BigDecimal; import java.util.ArrayList; import java.util.Collections; import java.util.HashMap; import com.zoho.cloud.function.Context; import com.zoho.cloud.function.basic.*; public class JavaCurToWords implements ZCFunction { public static String convertToIndianCurrency(String num) {
Tip 15: How to schedule a task that runs at specific time intervals
Zoho Creator lets you schedule most of your routine tasks, to help you focus on the important stuff. You can automate things like: Generating invoices once a customer places an order. Generating monthly revenue reports. Setting up acknowledgment emails for users or customers. With Zoho Creator, you even have the flexibility to schedule jobs that run multiple times a day, or at specific time intervals. For instance, you might want to set up workflows to send out a project progress email on a daily
include all sub form rows in a workflow email?
Say I have 3 rows of data in the sub form entry. How do I include all 3 rows of data in an email workflow using deluge script? At present it’s only including the first row for me Thanks David
Increment update record in report
Hi everybody i need your help I’m creating an app on zoho creator i would to insert a bouton in a report who will increment updaterecord in my report with the button +1
Tip 30: How to perform Google search from Zoho Creator
Hi everyone, Hope you all had a chance to try out our last tip. This month we have another interesting one for you—how to perform a quick Google search from Zoho Creator. This tip can be useful for redirecting your users to Google to find relevant information
[Community Webinar - VIEW RECORDING] Zoho Creator as a geospatial database | Feb 3, 2021 | #DevInsights
Dear developers, Hope you had a happy new year! I'm happy to announce that we will be continuing our Community Webinar series into 2021 as well. This year we're inviting several of Creator's veteran developers to share their knowledge and experience with
Troubleshooting in Creator #1 Tracing Missing Records
Tracing missing records in your database In large applications that handle data across departments, vendors, staff, and many similar stakeholders, it's important to have a clear mapping of the data, its owners, and users with access to modify them.
How to track repeat customers?
I own a food business and every order is entered into Zoho with: a unique Customer ID total order amount date of order With this information, I want to be able to see a list of my "best" customers. In other words, descending lists arranged according to:
Tip 29: How to automatically trigger messages from Zoho Creator to Zoho Cliq
Hi folks, Hope your holiday season has been a good one! We're back today with our next tip—how to automatically trigger messages from Zoho Creator to send to people and channels in Zoho Cliq. What is Zoho Cliq? Zoho Cliq is a business messaging app
Community Webinar: Integrating Zoho Creator and Zoho People | October 27, 2020
Dear developers, Thank you for your support and encouragement towards this initiative. We hope to continue our efforts in creating an extensive knowledge base for our developers. Next up is a session on "Integrating Zoho Creator and Zoho People". Date:
Community Webinar: Working with Zoho Creator’s v2 API: Examples and Best Practices
Dear developers, Our next webinar is a much awaited session on Zoho Creator's v2 API. Developer APIs are a core pillar of Creator’s extendability. They allow third-party applications to exchange data with Creator enabling a holistic and unified approach
Community Webinar: Bring your own code to Creator with Java functions | Nov 10, 2020 [Completed]
Hello all, Our next webinar is a session on using Java functions to Creator scheduled for 10th November, 2020. APAC/ MEA 10 AM IST/ 2 PM ACST Register here Americas and Europe 9.30 AM PT/ 5.30 PM GMT Register here Third-party programming languages will
Sub Category
Hi guys! How can i make subcategories in zoho? I tried many ways, using the normal options and script. I couldn't select the values for one specific "category", For example the options of Category and Sub Category, How can i restrict the Sub Categories's values using one values of Category? Its exactly the same options bellow this form!
How to manipulate CSS from Forms inside Zoho Creator?
I want to embed a FORM inside a page, but I want to make the CSS prettier.
Zoho creator workflow Issue
Hi There, I am trying to create a workflow to one of my inspection forms. The flow should be as follows; The user creates a form and send it to the approver Approver checks it and signs the form (or reject it) From what I can see once the form is submitted to the approver, the approver can't sign on the actual form. Is this something you can incorporate to the form? Or once the form is approved, is there a log to show who signed the form and on what date? Regards, Lou
[SESSION ENDED] Ask the Expert 6: 5-hour live discussion on launching multi-device applications and Customer Portals in Zoho Creator
Hi everyone, I'm happy to announce that the Zoho Creator #AsktheExpert initiative is back this year with a new session focussing on "Launching multi-device applications and Customer Portals in Zoho Creator". Every application built on Creator is automatically available for access on our native mobile apps for Android and iOS - no re-coding required. Creator also provides developers with tools to customize, extend, rebrand and distribute applications as they see fit in a device specific, and stakeholder
Zoho Creator , attachment in email and send to multiple
Hi All, Using creator I've created a simple four field form. On Submit it goes to a specific id but without the atatchment. I clicked on Properties in Design In Set email notification, in To : How can I add a list? I want on submit the mail should hit 12-12 people in a department The checkbox for 'Include user submitted data' is checked. I get all enteed dat other than the atatchment. Also I see a template slection , but not able to see or edit this. Thanks in advance
Tip 20: How to autopopulate values in a subform
Hey folks, We know that many of you use subforms extensively in your applications, as it helps you get the job done more efficiently. In this tip, we'll show you how to autopopulate values in the subform using a special syntax called "row." Let's look at an example. Consider you have an application where you need to automatically display the price of the product in the subform field based on the choice selected when a user clicks Add New in the subform. Let's say you have a form called "Mainform"
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
Tip 24: How to generate a file preview in a report without downloading it.
Hi folks, This month we will teach you how to preview a report file before sending it to someone or sending it for approval. While viewing reports in Zoho Creator, users cannot access or preview files uploaded through the File Upload field without downloading them. In this tip, we'll show you a way to do this. Key concept: The best way to achieve this function is to preview the uploaded file's content using the Add Note field in a stateless form (pop-up window) based on the record ID. Use case:
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
Tip 12: How can you customize the display name while sending emails from Zoho Creator.
Hi folks, Usually when you send emails to your users, the display name defaults as your From email address. Most often, you would like to set a custom display name to represent your organization or the context of the email. You can mask or customize the display name (From Address) using Deluge script as long as the From email address has been verified. This would be very useful to you if you want to send bulk emails to a large audience. Let's say you have a Student Registration form for your dance
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:
Next Page