Error details: log messages Invalid client task found corresponding properties Line:(3) Mismatch of data type expression. Expected BIGINT but found STRING Line:(3) (GET RELATED RECORDS)
viewinfo = Map(); viewinfo= zoho.crm.getRelatedRecords("Contacts","Contacts",input.First_Name.toLong()); input.Full_Name = viewinfo.get("Full_Name"); input.Email = viewinfo.get("Email"); alert viewinfo; i AM GETTING ERROR IN GET RELATED RECORDS API AND i WANT TO FETCH THE INTEGRATION FIELD DATA INTO THE OTHER SINGLE FIELD INPUT (YOU CAN CHECK BELOW ATTACH FILE )Zoho Commerce Scopes
I'm creating an app that needs to connect to the Commerce APIs, but the scopes aren't available. Can they please be added? Thanks, BryanHELP! Re-Order Blocks on Report Detail View
Is there any way to simply re-arrange the order of the blocks on a record's detail view? I'm showing that you can re-arrange the FIELDS however you'd like, but the blocks can not be re-arranged. This is a VERY BIG MISSING piece. Any possible update coming on this?Updating a field in another form when changes occur in current form
I have two forms that are linked via a lookup field. One of the forms is called Add_a_Class and the field is called "Students". The other form is called Add_a_Student and the field is called "Enrolled_Classes" In my Add_a_Class form, I also have a fieldHow 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)...Save our custom Forms to templates
As long as i know this feature is not exists right now and can save a lots of time. For example: on my customers projects the Customer Form looks the same the most of the times and if i could save the Form as a template for using it across my projectsFeature Request: Add the ability to reorder item rows in Subforms.
It is currently not possible to change the order of items in subforms within Zoho Creator. It would be ideal to be able to use drag/drop for rows in the subforms to reorder them.Basic Deluge script to copy 1 field to another
I have a set of address boxes for street city state & zip to identify a job location. I have a duplicate set of boxes to identify the bill to address. I have a radio button to select to copy the job location address information to the bill to address.How to Update multiple records from a Multi-Select lookup field
Hi Everyone, Ive got a form built to intake information on incoming samples. This goes to factories. Ive got a second form for my employee who is supposed to select a Date, a Shipping Carrier, input the Tracking Number and the multi-select all the samplesSegregate Data from subform of Form-A and fill data in another subform of Form-B.
Hi, this is my Subform "Assign Items to Existing Supplier" of Form-A Now each supplier should see their details only, so we have Supplier Form (Form-B) which has subform called Quotation-- For Supplier A subform should look like Deliverable QuantityCan you use a CC field at the send invitation to the customer portal?
Hi, we're developing an application with customer portal and we need to send the invitations to another email in carbon copy but we can't see how to do that or even if that is possible.Translate to new language saving only the last translated section
Hi, I found a very annoying problem with language translation. When i translate my app to different language (in my case Hebrew), i have to translate a section, save it (window closed) and open again the translation menu. If i don't save after each section,openurl methond on ios/iphone
we have a portal that are planing to release as an app for android and Ios. we have some panels that use the open page or open form, also a report that use a deluge with the openurl method, on web and on the zoho customer portal for android app, everything works as intended, but on iphone the open form/ open page/ openurl , any method that workd fine in the other plataforms, try to open the url in safari instead of using the zoho customer portal app or shows the web version inside the app insteadSending Image to external API from Zoho Creator
Hi there, My scenario is: I upload a photo to a report by using the file upload field in a form. I have created an action button which calls a function to send that photo to an external API I am having issues using the invokeUrl function to get the photoHow can we clear a signature field with deluge?
I would like to clear a signature field in the Edit -> On Load. I have tried input.signature = ""; input.signature = null; clear input.signature; None of the above is working. is there any other way I am missing?Integreat 04: Integrating Zoho Creator with Zoho Desk - Part 1
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Zoho Desk. Before we dive into this integration, let's quickly look at what Zoho Desk is and how you can use it in your organization. What is Zoho Desk? It's a cloud-based platform that helps businesses assign, track, and manage customer support tickets efficiently. Integrating with Zoho Desk With this integration you can push data automaticallyFormula Field + .sum() Function
Dear support, It would be life changing if you allowed us to use the .sum() function in Formula Fields, especially to sum row values in Subforms. I'm aware of how to do it via deluge/workflows, however, this would save a tremendous amount of developmentGenerate a QR code from Form data
Hi everyone, Simple function from which I can't seem to find other people in the same case. I want to create a form with a few fields (client name, product name, date). Whenever the form is filed up, a QR code is automatically generated from the data filled in and available for printing. Is that not possible? Looking much forward for your help! Cheers.Record Summary Has Multiple Pages
I need to export multiple records to a summary template, but when I do the export each record is on a new page. These records are just line items for a single sale. Is there some way to merge all selected line items to one page?If field is empty - clear another field too
How would I add to the below scrip to say: if Enrolled_Classes field is empty (ie all classes have been deselected) clear any value in Type_of_Student field? if(Enrolled_Classes.Stream == "Cheer Advanced" || Enrolled_Classes.Stream == "Cheer Elite" ||Creator Customer Portal Language
Hi, We use customer portal for zoho creator. Is it possible to change the language on customer portal login form?Select/Deselect in succession does not work!
Hey guys, I managed to find a bug. It has to be a bug. I did loads of testing and can see no other reason this does not work. With my app I am trying to select a corresponding checkbox in another field when a user chooses its equal in another field whichIntroducing 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.Simple getRecordById deluge -> {"message":"Invalid Ticket Id","code":"4834"}
Hello, i have a big problem with the deluge integrated CRM functions. Every Call like zoho.crm.getRecordById("Contacts", xxxxxxxxxxxxxxxxxxx) returns {"message":"Invalid Ticket Id","code":"4834"} This works fine on yesturday, but today all of our CRM Functions are Broken!!! The ID definitely exist!! NEED fast help, we have over 200 customers on our Portal!!{"4834":"Invalid Ticket Id"} as response of ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials");
Today all fetchs to zoho crm give me the error {"4834":"Invalid Ticket Id"} All calls that I made are of the style ACCOUNT_POTENTIALS = zoho.crm.getRecords("Potentials"); crmResp = zoho.crm.getRecordById(("Accounts"), input.Cuenta_ID); etc. I have found some post with this issue and it seems that it's related with the auth token.... but i don't know what i need to do to fix this issue. Could you help me?Zoho Creator and CRM integration Error
Hello, I am using Zoho Creator to create an app that integrates with Zoho CRM data. I am using the following code: leadslist = zoho.crm.getRecords("Leads",1,10); for each leadDet in leadslist { info leadDet; } And getting the following output: {"message":"Invalid Ticket Id","code":"4834"} The documentation says this error is an API authentication error, but I am writing a deluge script from within Zoho Creator Please advise. ThanksScript Troubleshooting help
I have form called “Add a Student” with a multiselect field called “Enrolled Classes”. I have another form called “Classes” with a field called "Max number of students” and a field called "Number of Students Enrolled” which counts how many students areInteGreat 06: Integrate your Zoho Creator app with Whatsapp using Twilio
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Whatsapp using Twilio. Before we dive into this integration, let's quickly cover some basics.URL to form redirecting to app on mobile
I have an app which has a few forms publicly accessible by guests to our organization; they are provided a link to a form-perma in their email. When most try to open the link on an iOS mobile device, the device first asks them to download the app - if they choose Continue to mobile site , it routes them to a login screen instead of the public form. Is there a way around this, or just a quirk of the iOS browsers?Group Invitation Expiration
It appears that Group invitations expire after a certain period of time. But I haven't yet been able to discover within the Creator documentation what that period of time is. Does anyone know?Why zoho's deluge platform does not include any asymmetric encryption functions?
Asymmetric Encryption uses two distinct, yet related keys. One key, the Public Key, is used for encryption and the other, the Private Key, is for decryption.The Private Key is intended to be private so that only the authenticated recipient can decrypt the message.As of now zoho only allows developers to encrypt the data with only one key with AES encrypt function which is symmetric Encryption which intern uses only one key but when dealing with banking and other service's the providers expect theirIs it possible to have a confirmation message during the form submission?
Hello, We have some forms and all the fields are not mandatory. Sometimes our clients when they add something then they hit the Enter button from the keyboard by fault. Of course then the form is submitted. Is there any way to create a confirmation messageZoho Creator Pivot Report - buttons are hidden on smaller screens
On Pivot Reports, the Refresh, Sort, and Export buttons are not visible on smaller (13 inch) screen sizes. Even when the screen is extended to the right, it doesn't show. This is a critical feature for us. In the screenshot below, this should normallyFIREFOX will not show ZOHO database but EDGE will
I've been unable to work on my several (12+) ZOHO Creator database for some time. Now when I try - FIREFOX will not open any database. So I switched to EDGE and they work perfectly. I have no idea what browser my viewers will use so need all to workUsing data in Creator as a "Lookup" in CRM
I am using the UI power of Creator to enhance my user's overall experience in CRM. How can I use data in Creator as a form of "lookup" value in CRM? Looking for some general or specific ways to implement this connectivity.Learn Try Catch
Hi, I am just starting learning Script Deluge. I am taking the course "Learn Deluge" and i got stock here. can somebody help me?Referring to Zoho user groups in Deluge?
Hello, I am wondering whether it is possible to refer to Zoho user groups (with whom the application is shared) in Deluge. I currently restrict records to be viewable only if the login user created the record, but I would also like to make all records viewable if the login user belongs to group X. Thank you.Lookup fields in subform demanding unique values?
I have a form for our program sessions that includes a subform for the purpose of listing participants. The subform is a separate form, and includes three lookup fields: Name of the participant Sponsoring organization Occupational institution For someSearch with barcode on pages
Hello, When creating a Page (not a form) is it possible to set a search field to act as a barcode scanner similar to how it is done in the form pages? In other words I want to create a page whereby when I click the search field it activates the phonesHow do I unpublished components?
How do I unpublish components? Is there a way to unpublish components from a deleted application? Is there a single place to find a list of all my published components?Next Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
Integreat 04: Integrating Zoho Creator with Zoho Desk - Part 1
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Zoho Desk. Before we dive into this integration, let's quickly look at what Zoho Desk is and how you can use it in your organization. What is Zoho Desk? It's a cloud-based platform that helps businesses assign, track, and manage customer support tickets efficiently. Integrating with Zoho Desk With this integration you can push data automaticallyIntroducing 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.InteGreat 06: Integrate your Zoho Creator app with Whatsapp using Twilio
Hi folks, We're back with a new post in our InteGreat series, and this time we're going to walk you through how to integrate your Zoho Creator application with Whatsapp using Twilio. Before we dive into this integration, let's quickly cover some basics.IMPORTANT: Restriction on Public Access, to control phishing.
We already have processes in place to detect fraudulent usage of Zoho Creator. We never permit storing of sensitive information like credit card details, passwords, social security numbers, etc., on our apps. But as we are sensing deceitful usage of applications, mostly in Free subscription and Trial period, we have decided to disable the option of making an application as Public. Henceforth, all the applications that are created will be Private and only a shared user will have access to the applications.[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 be
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly 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
Most Discussed Topics
[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 beScript help
I am trying to input a field in a subform depending on whether or not another form (Complete_a_Waiver) has previously been completed with the same first name, last name and DOB as the row in the subform. If yes, then it will input as yes, if no then itUpdating a field in another form when changes occur in current form
I have two forms that are linked via a lookup field. One of the forms is called Add_a_Class and the field is called "Students". The other form is called Add_a_Student and the field is called "Enrolled_Classes" In my Add_a_Class form, I also have a fieldAny idea for loading animation workaround?
On my application i have page with ZML <image> which has attribute action='Function'. when the image (icon) pressed a function get called and sometimes the function takes some time (API Calls). For making a reasonable UX i would like to show a signLookup field filter
Does anyone have any advice on what I am doing wrong here. When testing separately, the first part of the filter (Head Coach) is working, but the second part (Day/s) is not.
Sticky Posts
[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. CustomizeIntroducing 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 theCommunity 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,
Top Contributors
Laura_se
Gordon Mankelow
Gautham P
AP
Damien Cregan - bcCloudTech