Use Zoho Analytics tables as data sources for Creator apps
I am currently using Zoho Analytics to create reports using data generated from a 3rd party web-based case management system. It would be very helpful if users in my organization could create applications/forms using data from the Analytics tables and
Issue with Fetching Data from Zoho Creator using Custom Outlook Add-in
Hi Team, I am encountering an issue while trying to fetch data from Zoho Creator in a custom Outlook add-in. The goal is to retrieve origin and destination information from a specific report, but I'm facing CORS-related errors and failed requests. Error:
Zoho Creator Widget Update record error 401
This is a widget project, I try to update record.value1 with a popup page, I can fetch data from ZOHO.CREATOR.API.getRecordById but when I try to update record, it show 401 error code with { "status": 401, "statusText": "error", "responseText": "{\"code\":2945,\"description\":\"EXTRA_KEY_FOUND_IN_JSON\"}"
Set Lookup Field to Top Option
I'm trying to set the lookup field to the top option, but I get this error... Is there any way to get around this?
true and false invertion in my script ?!
In the following script to send emails, the true and false condition seem to work inverted. The emails with "false" condition receive email when "true" is in the script, vice versa. Any explanation ? CourrielFerme = "info@fermerondine.com"; Demain = zoho.currentdate.addDay(0);
Gantt Chart in Zoho Creator
Is it possible to create a gantt chart in Zoho Creator? There is one old posting which does not quite answer my question. Here is an example of a Gantt Chart:
Filter Lookup Field by Most Recently Used
Hi, Is it possible to sort a lookup field by most recent? Like, I want items that I recently selected to show up at the top of the list.
Add a MATRIX field to the forms creation
Same as Zoho forms, we need a Matrix field in Zoho Creator forms, is very usefull
is it possible to adjust the date field to show Monday as a first day
Hi, Is it possible to adjust somewhere the date field, so the first day of the week is Monday (instead of Sunday)? Thank you! Ferenc
Ajust multi-line inventory sub-form upon submitting form
Hello, Just need a good start on a script. I have an order form with a sub-form for every line items ordered. That subform source, with a lookup, product details, including actual inventory. Upon submitting the order, I want the quantities of every item
escape new line character
Hi, I would like to check if a string contains a \ character (backslash) I try this: if ((input.invoer).indexOf("\") > 0) { found = true; } But the I get the error: Error at line xx : Script contains new line character, kindly remove it and try again. I have tried ("\\") but that doesn't work So how do I do this?
#Zoho Creator - Button Click Function in Page
Hi, I have created a button in my page .I want to perform button click operations. Is there any way to call the functions in the application when the user hits that button?? If anyone have alternative solution for this problem, please help to resolve it.
How can I access the extra properties for "Formula field"
This is a formula field property image. Here, you can see properties like 'Field Type' and 'Display Format in Report.' How can I access this? Is there a way to do so? My question is: Do I need to enable these properties?
On User Input - Display Image in Subform
Hello All, I am creating a Form for Creating multiple product orders I need assistance in displaying the Image of the Product on Lookup Input of Product Name Field
Trying to get the pdf of a form record on button click in a deluge script
I'm trying to send a notification on whatsapp of the pdf version of a form record, for this I need to generate the pdf of a record using a record template in deluge, so i can pass it on to the API to push whatsapp notification. What is the way to do
How can I get the Image or File URL from Zoho Creator to insert into another application?
I've tried retrieving the image URL from my Zoho Creator application to insert it into another application. However, I'm facing issues as the proper image URL isn't being obtained. The same problem occurs with file uploads. I can upload a downloaded image
Date format changed when appended to list
Hi, I have a dropdown list whose choices depend on user input of another field. The following code works fine. However, in our original data, the date format is dd-MMM-yyyy, but when the following code runs, the items in the list become yyyy-MM-dd. Clear
Can I make a client portal so that they can upload/download documents?
Hello Experts I would like my clients to access a portal using some kind of authentification (their email address?) so basically access to their own secure client/customer portal and let them securely upload documents in a folder related to them. so my
Add and Delete Customer Portal user via Deluge
Using Creator to build an app involving a customer portal. I'm trying to integrate the customer portal for the first time and it is raising questions, mainly because it's new territory. Is it possible to add a new user to the customer portal via deluge? For example, if an existing user invites/refers another potential user to try our app, is there code to automate via deluge, setting up an account ready to go for them? The referral would include their email address, and a workflow would set up the
Is Zoho down today?
I can't do a single thing. I tried changing some views and reports and got "undefined" - then I tried editing a form, got "undefined' - started a new form and can't add any fields as when I drag and drop it also says "undefined." What is going on? HELP.
Passing the image/file uploaded in form to openai api
I'm trying to use the OpenAI's new vision feature where we can send image through Api. What I want is the user to upload an image in the form and send this image to OpenAI. But I can't access this image properly in deluge script. There are also some constraints
How to Display Formula Result as Currency?
I have been searching this topic for an hour now. The best I can find are posts from more than 2 years ago with no solutions. Is this still not possible? The formula field does not allow for a format option. The report does not allow for a format option. My formula is based on a currency field with basic addition, multiplication and division. Why would the result not maintain the currency format? From the (outdated) Help section (https://www.zoho.com/creator/help/fields/configuring-a-formula-field.html)...
Sort a Multi-Select Lookup Field
I have a multi-select lookup field coming from one app to another. Currently that lookup data is being sorted on the printed report based on the added time of the form that's being brought in. Problem: I'm ideally trying to sort the lookup data by a field
New Gantt Chart Extension problem with relationLinkName in Creator
I've burned a few hours now trying to solve this one, but no luck and there aren't any posts in the knowledge base yet: Anytime I try to include "subRelationName" the Gantt chart fails (invalid subStartdate and subEnddate). Works if I exclude the "subRelationName",
Developer access
Hello, how can I limit the developer role access level? I want to remove access to all reports.
Integrate with Power BI
Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
Simple way to add Support Contact to CRM Leads/Contacts on New Ticket
Case Scenario: Support WebForm is used as contact form on company website. Visitor is not yet customer of company, and is not listed in company CRM. When form is completed, Support is updated with contact information, but CRM is not... therefore potential customer cannot be located in the CRM for follow up or automated responses/workflows etc. I've been looking through the documentation and there does not seem to be any automated way to create a CRM Lead based on a new support ticket creation (by
Suggestions to Enhance Translation Features in Zoho Creator
The localization capabilities in Zoho Creator are great, and as a partner who heavily relies on them, I’d like to suggest a few improvements. These changes would streamline workflows, save valuable development time, and enhance the customer experience.
Creator Simplified #4: Modifying the app structure using the Application IDE
Hey Creators, Here’s this week’s Creator Simplified post with a tip to enhance your app development skills. Objective Modifying the app structure using the Application IDE. Use Case Assume a scenario where you have to make trivial changes to your application
Custom Domain for Customer Portal
Hi I have a personal domain that I want to use for Customer Portal on Zoho Creator I have follow all instruction including updating the DNS but it still does not verify. Zoho Support has not been able to assist with getting this resolved
connect zoho creator with google drive
Hello everyone, I need to connect to a folder drive. The idea, is that google drive loads a text document with some data, I must read that text document to be able to autofill a form that I have in zoho creator with that data. I also attach PDFs and place
Insert field data on each row of uploaded and parsed content
Hi, On the upload and parse content below, I want to insert data into each row that I need on the parsed input to the other form so the data can be grouped by this field, but it can't be on the uploaded .csv. How can I do this? fileContent = input.Cruise_Sales_Upload.content;
Offline mode for pages based app
Hi community, I have a request for creating an app where users can enter data into multiple forms. Those forms I plan to embed into creator pages. The users navigate throw the pages and can access the forms to enter their data. The use case of the app
Embed detail view of a report in a page layout?
I have a form that allows one entry per user, and a report that only shows the current user's report, so there will only be at most one record. I'd like to display the detail view because it shows the related records. Is there a way to force the report
Update field from second form based on Lookup value on first form.
I'm sure this has been asked a zillion times. I am using Lookup field to obtain a value from a second form. Based on the choice I want the corresponding value for another field on the second form to be input into the field on the first form. I know this is a set value action of some sort but am new to Zoho Deluge and cannot see how to do it or see any build functionality on the field properties to achieve this. Basis stuff but how?
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
Improper statement line 31 (Highlighted in red) pls help
// Fetch the current record from the AMER form previous_record = AMER[ID == input.ID]; info "Previous Record: " + previous_record; // Fetch the record from the AMER form by its unique ID previous_status = previous_record.Status; // Get the old status
Is there any way to fetch records in ascending order by Name Field?
for each userItem in User [ ID != null ] sort by Name.first_name { }
Creator Offline Form from Record
Hello, We have a list of records that need to be viewed offline. When a mobile user opens the detail view of a record we'd like for them to click a link or button to open a form. For instance. A list of work tickets. The user opens a work ticket offline
Prevent Enter Key From Submitting Form
I have a client who really likes the Zoho form but doesn't like how using the Enter key (Return key on Mac) submits the form instead of moving the cursor to the next field. I am personally used to this so I only use the Tab key but perhaps this option would be nice functionality to add. From what I have seen on the web there appear to be ways to code this alternate functionality. Unfortunately I am not a programmer otherwise perhaps I could do this myself using your scripting functionality. Thanks
Next Page