Integreat 04: Integrating Zoho Creator with Zoho Desk - Part 2
Hi folks, We're hope the previous post on Zoho Desk integration was useful to you. In this post we will cover the rest of the tasks (task 5,6, and 7) that can be automated once you integrate your Zoho Creator application with Zoho Desk. As mentioned in the previous post, once you've established a relationship between Zoho Creator and Zoho Desk, you can perform the following task: 1. Create new records in Zoho Desk 2. Fetch data from Zoho Desk 3. Fetch specific records using the record ID from Zoho
How To Remove Logo When Printing Individual Records
To ZC team; Is it possible to remove logo from page when printing individual records? Is there an option for it? Thanks, Damien.
Fetch zoho projects via creator widget
Hello, I'm creating a widget for Zoho Creator that serves the client's need UI. The thing is, the requirement is to display all projects and their children e.g. task lists from Zoho projects in this widget. Locally I can make server-side API calls (that
Generate QR code to edit a form entry.
I would like to QR code scan to edit a form entry. I would like to take the URL of a submitted form entry and create a QR code with the URL. Once we have the QR code we would like to print a sticker with the information and QR code. We would then like
Print shipping label on Zebra Label printer from ZOHO Creator deluge
Hi All, Allow me to guide you through the process of printing a shipping label from ZOHO Creator to a Zebra label printer (ZD421D). Step 1: To start, configure the SendFileToPrinter API, which enables the transmission of a file to a Zebra Link-OS printer.
How to make a field conditionally mandatory
I have two fields (Address and City) which are not considered mandatory unless another filed, Amount, is greater than 100. So if Amount is greater than 100, how can I assure that Address and City have values in them? jmc1846-zoho
Criteria for Field Rules Not Working if Criteria is Based on a Disabled or Hidden Field
I have an issue where I have "Field A" that essentially serves as a reference field containing a unique ID. So that field, by default, is disabled. I am trying to create another field rule to hide or show "Field B" based on "Field A" value, but the criteria
How to update decision box field based on two criteria
Hi, I am trying to update a decision box field which will show an assessment record as "overdue" if it has not been marked. I want this to be based on if the due date is before the current date and the marked box is false. I am trying to use this code
Zoho creator form confirm success show message for multi language
https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/manage-forms/articles/understand-showing-success-message#Understand_showing_a_message_on_form_submission How can I setup different language message ?
change font colour of certain items in lookup list.
Is it possible to change the colour of the font of certain items in a lookup list? I have form that allocates tickets. Once a school has recieved tickets, a field called 'Received tickets' in another form(Add/Edit schools) has its value changed to yes.
Getting an error on saving code that there is an error connecting to the service
While working on some bug fixes this morning we are running into an the attached error message. "Error occurred while saving the script. Could not establish a connection to the service." This is while saving the script for a Page
Creating URL in deluge/HTML
Having difficulty adding target=“_BLANK” to a URL I’m creating. I have dispLnk = "<a href='" + i.URL + "'>" + i.Title_Name + "</a>" + " - " + i.Description; where i.URL is a companies site, i.Title_Name is the company name and i.Description is their tag
Passing a value to an "+ add new entries" form
I want to pass a value to an "add new entries" form. Take for instance the forms in the Zoho help example app "Dynamically adding items to a picklist" Back when that example was created it wasn't possible but now we can configure a look-up field to allow the addition of new entries. Let's say I didn't find the state I wanted for the selected country and wanted to add it. Since the "State" form in the example has a "Country" field, I wouldn't want to have to select the Country in the State form when
Passing data to a form invoked by clicking the "create new" button in a lookup field.
Here is the scenario... I have a form called "order". In this form I have a lookup field called "ticket" which creates a relationship with a ticket form. In this lookup field I have turned on the ability to add new entries. What I'd like to have happen is that when a user is creating a new order (using the order form) if they click "add new" to create a new related ticket, I'd like to populate some of the fields in the ticket form from data the user has entered in the order form. Is this possible?
Passing parameters to "add new add entries" form
Hello, It will be great to have possibility to have property for each field in form (checkbox) "pass this to add new entries forms". For example: Form "Clients_Requests" Lookup_field: "Client_ID". Checked "Pass this to add new entries" Lookup_field: "Contact_Person" with checked "Show a link to add new entries in Contact_Persons" property. When you click "Add new" for Contact_Person, new form is loaded and Client_ID is setted to "Client_ID" from "Clients_Requests" parent form "Contact_Persons"
Image field pan, zoom and crop feature
It would be nice to let users arrange the images they input in image fields by allowing them to pan, zoom the image. Nowadays this is a standard input method used in most applications, so I think it will be very useful.
Zoho Creator Upcoming Updates - December 2023
Hello all! 2023 proved to be an action-packed year for us at Zoho Creator. Riding that momentum, we're geared up to conclude the year with a bang! Here are this month's top highlights: Zia Assistant powered by OpenAI Custom APIs Support ticket tracker
Zoho Creator New Function "Focus"
Hello Team So, Zoho Creator has launched a new function called 'Focus'. If you have a Zoho Creator form and want to draw the user's attention to a specific field, you can use the 'Focus' function, which only works in Zoho Creator. For more details, please
Check for Duplicate Date Range
I am trying to update my reservation application to check for units already booked. For a specific property, the unit is booked from a start date to an end date. What I am trying to do is to add code to check if some one tries to add another record where the from and to dates overlap. For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Value in a dropdown should give automatic update in date_tim
Hi I would like zoho automatic to update a date_time field to current time, when a value in a dropdown is set to a certain value. How can this be done! BR Skouboe
Update Subform items based on main form status
I am working on a deluge script to update the status of a subform ( "Samples"). The individual items have a "Status" that should be updated when the main form "Status" is updated. I have set up the workflow as a conditional workflow that executes only
Tip #25: How to add background images to forms
Hi everyone, The world is going through a difficult time right now, and we hope you're all staying safe. We're here with another Creator tip—this time on how to add background images to your forms. Sometimes, to add some context or make your forms look a little better, you may want to add a background color or an image to your form. Let's go over the three easy steps it takes to get the job done. Use case In this example, we have a New Order form, and we'd like to add the company's logo to it, to help establish better
Zoho Creator | Introducing Augmented Reality
We're delighted to announce augmented reality (AR) in Zoho Creator! Now, you can set up your own immersive 3D experiences—combining a glimpse of the real world with computer-generated graphics. AR technology augments what you see, by superimposing digital
Problem with Expenses App
The sub-categories are not populating with the Category selection. Meaning once I click the category, the sub category has the full list to choose from which is very annoying instead of just the subcategories that are associated with the particular category I selected.
What is best method to link or lookup tables with encrypted fields.
I am testing out Zoho Creator for making a HIPAA database to keep track of patients and their appointments. I have two tables: Patients and Appointments that I would like to be related as one-to-many (one patient can have many appointments). Per these
Customer portal users and data visibility on reports
Hi, Suppose I have two companies Rocket Science (RS) and Quantum Politics (QP) as my customers. Both companies access the application through the customer portal. When a customer portal user RS A fills data in a form, the user RS A can view the data in the corresponding report. The same is true for a customer portal user RS B. The user RS A can't see RS B's data and the user RS B can't see user RS A's data on the report. If permission set is configured to "View all", then all the users will see
IF-THEN write formula
I am having trouble creating a simple IF-THEN statement that will yield a text description of a number field. This is a common Excel formula and it may be easiest to show how I'd write in it Excel: =IF(Number_Field<100,"Under 100",IF(Number_Field=100,"Equal to 100", IF(Number_Field>100,"Over 100"))) This formula looks up the number in Number_Field and writes, in another column, whether that number is "Under 100," "Equal to 100" etc. Is there a way to do this using the built in formula generator
Creator Page that Has Charts Filtered by CRM Account
We use Zoho CRM. We also have a Creator application called Reports that captures monthly reports with detailed metrics for each CRM Account. We use the Creator integration widget to pull the Account from the CRM and make it part of the Creator record
Subforms added after main records creation have "null" IDs.
Hi Zoho Community, I added a subform (pre-populated) to my main form. I want all existing records to have this pre-filled subform. When I manually edit an existing record, I can see the subform and the pre-filled values. But it does not show in the report
Implement an API call using Oauth 1.0
Hello Everyone; I am trying to communicate with another web application using an app in Zoho Creator, which happens to use Oauth 1.0... The problem is, i am able to test it using Postman successfully, but i can't write the code in deluge to authenticate, specifically to produce the nonce and timestamp needed in Oauth 1.0 protocol... Has anyone successfully wrote a code to authenticate using Oauth 1.0 protocol? Can you share how to make my code succeed? Thanks in Advance
Kanban doesn't trigger workflows
Hello, Im trying to use a Kanban view of my list, but i'm noticing that moving my objects on the kanban doesn''t trigger any workflow, anyone else having this problem? I have a form edited sucess workflow, and it doesn't work if i edit the "deal stage" trought the kanban view, only if i edit it.
Populating a picklist another form
I am creating an App for ATTENDANCE MANAGEMENT for a School. I have the forms: - Students (Form1) - Classes (Form2) - Attendance Management (where I monitor the ATTENDANCE of students PER CLASS) (Form3) In the ATTENDANCE FORM (Form3) I have the fields:
Get the future date a number of days from the date in a column in a Pivot Table
Hello, I hope that someone can help me. I have a pivot table which has a column with dates in it (Date A), I wondered if it is possible to create a new column that shows the date 180 days from Date A. Is this something I can use a formula for? If so how
iframe code: diff between view-embed and report-embed
Using Zoho Creator to enter local nonprofits and sort them, then displaying them on Zoho Sites. A while back a developer helped our sister site get up and running. I noticed that they were not publishing reports and using the iframe code to display them
Inquiry Regarding Accessing Multi-Select Field in Pivot Chart
I'm currently working on a project and would appreciate guidance on accessing and utilizing a multi-select field within a pivot chart in Zoho Creator. Could you provide instructions or resources to help me implement this feature efficiently? Your assistance
Print Option Accessibility Issue in Zoho Creator
I hope this message finds you well. I'm encountering an issue within our Zoho Creator application where I'm unable to access the print option when combining forms and reports into a single page. As printing is vital for our workflow, resolving this matter
Page - Gauge - Target Values
Is there a way to make the Target and Maximum values say a formula or query? For example, total sales for the month = 109 and I want to make my gauge today's percentage.
Zoho Creator how to publish forms specific to each client in the Zoho Creator App.
Hi I see how you can publish a specific form to be able to access it externally. But what if I had a Zoho Creator App that multiple clients on it and I wanted to publlish public forms that are specific to each client? Such that I can embed those forms
Zoho Creator - [Free Webinar] Application Development BootCamp 1.0 - 3 Day Series
Hello Everyone! We are thrilled to announce the addition of another exciting webinar for all of you, titled APPLICATION DEVELOPMENT BOOTCAMP 1.0. About Application Development BootCamp 1.0 Application Development BootCamp is a dynamic three-day webinar
Passing Data about a record through a custom button
I am trying to pass data from the record where the custom button is pressed. Do you pass them through the arguments of the function, but the function is outside and not linked to that particular record. How do you go about doing that? Thank you for your help
Next Page