Zoho Creator - Development
Dear all, I'm new to Zoho. This is in regard to Zoho Creator and Extension development. 1) In the Zoho Marketplace, there are many Extensions (and custom apps) available for sale. I'm wondering what programming language is used in Extension development?Designig Page: Is it possible to use ZML and Deluge to create a Panel dynamically?
Hi. I want to create a Page with a panel for each record in a Form. I tried to use 'for each , but get get only 1 panel containing the first record. Is it possible to create a panel dynamically? This is my code: <%{ for each rec in Contact[ID != 0]Zoho Creator
Hello, I have app in zoho creator, and have invited my employers .. but when my employers open invitation link .. it redirects to blank page! Screenshot is attached.Adding values to a multi-select field with deluge
Because subforms will only create new rows, I'm using deluge to recall information from a form into the subrows to mimic the behaviour of updating a row rather than creating it. I have a multi select field called "locations" that is a list of locationsAPI Greater Than (Zoho Creator)
If I make this request, it works, returning all records for 12-Jul-2022 https://creator.zoho.com/api/v2/xxxxx/certification/report/Rapport_d_taill?Date_field=12-Jul-2022 But I then add a > https://creator.zoho.com/api/v2/waterprotec/certification/report/Rapport_d_taill?Date_field>=12-Jul-2022How do I resize the forms on my site?
Hi How do I resize the forms on my site? How to reduce your size? Etc. .. ThanksImage size issues in Zoho creator, can we compress and resize somehow before upload or even after upload
Is there anyway we can resize the images being stored in Zoho creator.? We have a number of reports that utilise the photos and images we store and that report produces PDF reports. These pdf reports are getting to larger with the huge images being storedHow To Set Report Column Width in Creator 5
In previous versions of Creator, report design included the ability to specify specific field widths for each column in a report (browser). That capability seems to have gone away in 5. I have a report in which one of the columns may have a lot of textDefault report filter
It's something that gets asked for regularly, the ability to set a default filter for a report that can then be cleared by the user once the report loads. Or alternatively an ability to set a custom filter as the default report when opened. Please addQuery Parameters for "Today"
How do I put Query Parameters equals to "Today" for date field in page when we put Open Report as action?Options to re-filter report
Greetings, I hope find all doing well and safe. I have a report that list All Customers. There is a field "status" with values Active or Inactive. The report is filtered to load only with Active status. I would like to get an option to the user see theHow do I change (error) display messages
Hi! I would like to edit display messages like "invalid entries" and "enter a value for Nome" and so on into Italian language messages. How can I do that? Already tried on Validate on form submit. Where I am failing? Thanks in advance.lock some records at a subform
Zoho support told me there is no way to disable for editing some records on a subform, based on field's value of that same record. Can someone think of a workaround to achieve this? Thank you!Commission Calculator
I am looking for some help with calculation commission for my business. I have a Form called Policies and a form called Renewals For each policy, there will be 1 renewal each year, and commissions are paid on the total premium of the renewal. However,Sum value from Json response
Hello, is there a way to get the sum of all qtaconsumption values in the Json response below with a function like sum() instead of having to do a for each loop to sum each value? Can't figure a way to do it with sum(). {"historyQuota":[{"time":"2022Error code 2930 : unmeaningful message
Hello, I wanted to get a specific record from a report in Zoho Creator with a function in Zoho CRM. I have created a connection and used a simple zoho.creator.getRecords(with arguments). The response a got from that was a : {"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."} Function executed successfully Is it possible to understand where this error comes from so I can efficiently correct the source code? ThanksCan you create confirmation messages in Zoho Creator?
Hello, I would like to create a confirmation message that asks the user to confirm that information they have added in a field is correct when they attempt to submit the form, and gives them a "Continue" or "Cancel" option. Is this possible, and if not, is there a workaround? Thanks!Logging task time in Creator
Using Creator I want to be able to log in task time. For example: If you are assigned Project A to work on and in Project A you have Task 1, Task 2, and Task 3 to complete. You're going to work on Task 2 so you log in your date/time and at the end of working on that project you log off your date/time. It will log that time and put it in that particular task. Then the next day you come in to work on Task 2 again and once again will log in and log out the hours you worked on that task that day.Vertical images displayed as horizontal
Some pictures that originally are in vertical position are displayed in horizontal after the upload. It seems that system rotates them by 90 degrees. How can I fix this issue?How create audit logs or history of report ?
How create audit logs or history of report ? I know there is logs option for the same and check with selecting form; but we need in report. How ?Multiple criteria in searchRecords
Hi, is it possible to search with multiple criteria in zoho.crm.searchRecords? I have tried several variations of the following without much success. CustomerRecord = zoho.crm.searchRecords("Contacts", "(First Name|=| lee)" && "(Last Name|=| spencer)"); Thanks. ChrisHow to get a image url
Hi, This is Surya, 1. I want to get the URL of an image that was uploaded to the Zoho creator using image field (uploaded through local storage). I referred [https://www.zoho.com/creator/newhelp/forms/fields/image/understand.html#File_download_URL] to this link but i didn't get the solution. I followed the instructions in the above link.and when i click the button I get an error. Refer to attachment for error. 2.I am trying to integrate with Facebook and i want to post an image to Facebook from thePOS system of Restaurant
Hi Team Is it possible to create something like POS for an Restaurant management providing access for reservations of table, keeping track of reservations, and adding orders for the reserved tables using existing Restaurant Application of Zohocreator.I keep getting this Error message
Error details: Error in executing On User Input script of the field, Items. Null value occurred while performing Addition operation. Line:(18) this is my script. it will be something simple i know //Link the Item_Name field in subform to the Item_name field in Items Form; selected_item = Items[ID = row.Item_name]; //Set the quantity of the selected product to 1 by default, if no quantity is declared if(row.Quantity = null) { row.Quantity=1; } if(row.Quantity > selected_item.Quantity) { alert "PleaseFunction Inputs in Report Filter
Is it possible to pass a field into a function in a report filter? I have a use case where employees are broken out into different branches based on geographical region, however there are certain regional managers that reside over multiple branches. I'dcan we add deluge code in condition
Hi, can we add here the dyanamic date, before 1 day Day of Interveiw start date in condition ,... ?? function as a filter criterion works in some reports and not in others
In several reports I use the same filter that is the value returned by a function.It worked fine until recently. Suddenly now in some reports it works and in others the criteria of the type: "thisapp.MyFunction ()" has been replaced by "<FUNCTION ()> " and does not let me change it.I have already contacted the technical service and they have been checking it for days but at the moment no solution. If anyone has any ideas, help is appreciated.Cancel Button Not working when editing a form opened from openUrl
I have a custom function to edit a form which I use in a button on a related report. It uses the "openUrl" task to open the form with the correct record id, and it sets up the View Link and and Next URL. Here is what that URL looks like: https://app.zohocreator.com/myloginid/myappname/#Form:Record_To_Edit?recLinkID=3208680000009414047&viewLinkName=Record_To_Edit_Report&zc_NextUrl=#Record_To_Edit_ReportZoho Creator Programming
Dear all, I'm new to Zoho and I'm keen to find out more about Zoho scripting. 1) This is related to the extensions displayed at Zoho Marketplace, were extensions developed using Deluge alone? 2) Is Deluge powerful enough to do anything for you withinSend mail to every e mail address in a subform with the respective information.
Hello, I am creating a form in order to report happenings in a company. The main form is to collect data from the person who reports the happenings and the case. There is a subform too, in which the person who reports should describe al the different happenings he found for that case and who is reponsible for it and his/her email address. I would like to send email notifications to every email address in the subform with the respective information. How can I do this?Report based on subform entries
Can anyone help me with how to create a report which shows data from a subform please, which I can export to a spreadsheet? When I do it, it only shows that there is a subform rather than the data within it. Thanks.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. ThanksZoho Creator SaaS app with multiple client AND multiple users
I am close to finalizing a Zoho Creator app that will be used by different companies to manage sale info, and each company can have multiple users using the app. Things were going perfectly until I tried a search on a report. I use a database field in each table to separate the data for each company, which works great. BUT when I do a search, I get to see ALL the data. This means that Company A could easily see the data from Companies B and C via the built-in search. Is there a way to set up theTrying to create a ZML snippet to show a forecast of revenue
I am trying to create a ZML snippet to show a forecast of revenue based on a count of records from a form from a different app. The app name: latxoperationslivedispatch The form name: Today_s_Truck_Assignment Date and Time: MMM dd.yyyy /12-Hour These@mention in comments no notification
Hi, hope someone can help. When we @mention someone in the comments in Zoho Creator, how is that user notifed as we don't get anything on email or in the app notifications.Possibility to create and send ICS file
Hi, I'm looking for a possibility to create an email which outlook can read. Discovered some, but don't know how to implent this into my script. I need to create a ICS file like this: BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN CALSCALE:GREGORIAN METHOD:PUBLISH BEGIN:VEVENT DTSTART;TZID=US/Central:20071214T210000Z DTEND;TZID=US/Central:20071214T230000Z SUMMARY: TEST SUMMARY DESCRIPTION: TEST DESCRIPTION UID:tpn1456-33432 SEQUENCE:0 DTSTAMP:20071207T151700Trying to pull a owner name (and other data) from CRM in Creator
Hello guys ! With the help of this great community I was able to pull some data from CRM "Contacts" into my Creator Form. As you can see below, it's working like a charm but I now need help to be able to fetch only the name of the owner (my "commercial"Url filter Report date (pivot chart)
Hello. Is it possible to filter the data in pivot char using parameters in the url? I'm trying but I should not doing very well. Something like: https://creator.zoho.com/.../....../#Report:MyPivotChartReport?MyDate=01-Jan-2012;31-Jun-2012;MyDate_op=58 SaludosUpcoming Updates - February-March 2022
Hi all, Greetings from the Zoho Creator team! A new year is here and we're looking forward to bringing in new features, improving performance, and delivering on all the exciting updates we previously announced. In this update, we'll go over the: 30 newmulti-select fields and report builder
Hello, Is there a work around (via deluge script or else) to allow data in multi-select fields be grouped or filtered in the report builder? We have activities that are participated by multiple participants that we input via look up -multi-select fields. We need to make a monthly report for each of the participant vis-a-vis the collective activities they have participated. How can we do this here? Its a feature we commonly used at dabbledb. Thanks, EdithNext Page
Announcements
Creator roadmap for the rest of 2022
Hi everyone, Hope you're all good! Thanks for continuing to make this community engaging and informative. Today we'd like to share with you our plans for the near future of Creator. We always strive to strike a good balance of features and enhancementsTip 26: How to hide the "Submit" button from a form
Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in. Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and thenUpcoming Updates - February-March 2022
Hi all, Greetings from the Zoho Creator team! A new year is here and we're looking forward to bringing in new features, improving performance, and delivering on all the exciting updates we previously announced. In this update, we'll go over the: 30 newIntroducing Blueprints
Hello App Creators, Greetings from Zoho Creator! We're happy to inform you about a new feature called Blueprint—Zoho Creator's process management tool. This feature enables you to customize every detail of every process you design in your Creator application.Upcoming Updates - May-June 2022
Hi all, Greetings from the Zoho Creator team! We're looking forward to delivering on all the exciting updates we previously announced for you. In this update, we'll be going over: Revising developer permissions API limitations on workflow looping Standardizing
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho Desk Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Most Discussed Topics
Can't fetch data from JSON response
I'm connecting to an external API with a postURL and saving the result to a 'result' variable. I'm getting the correct response, as shown in the screenshot below, but I'm unable to extract data from it with get(), getJSON, etc. If I manually copy andDynamically adding sorted record IDs to a multi-select Lookup field
I can dynamically add IDs (on User Input of another field) to a multi-select Lookup field, but I can NOT add sorted IDs. IDs = Form1[Criteria].Lookup.getAll().distinct(); IDsSorted = Form2[ID in IDs] sort by SortField; input.MultiSelectLookup = ??? I'veInvoke URL With Zoho Creator and Multi Part Form Data
Hi, I have been trying to get an external API working with Zoho creator, I have managed to get loads of different API's working fine over the past few months but I have a problem getting the syntax right for this specific API. I think this is the firstHow to use link in message of sendemail task
Hi, I am trying to use a tag and href for link inside the message, but it is not working. like sendmail [ from :zoho.loginuserid to :client_email subject :subject message :""<p><a href="https://www.w3schools.com">Visit W3Schools.com!</a></P>"" ] i haveHow Download Attached Files from the Email Templates?
Hello, I have a new form which has attached files field. After summit the form, this one send an email with email layout indicate the "link" to the attached files. But when the user press the link for download the attached file, says the follow lines: You
Sticky Posts
Introducing Zoho Creator's v2 APIs
Hello App Creators, Welcome to Zoho Creator's v2 APIs! This post will serve as the central point for migrating implementations of Creator's current APIs (v1) to v2. Improvements that v2 brings OAuth-based authentication, which is more secure than theJoin our developer community!
Dear developers, To improve communication and transparency with you, we started a developer-focused newsletter in early 2021. To expand the scope of our outreach, we are looking to create a go-to database of our developer community across professional[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will beZoho 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 onCommunity 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
Top Contributors
Damien Cregan - bcCloudTech.com
Jose Vilches A
Gordon Mankelow
Sriram U
Ashish