Conditional script for whether a user is currently logged in
I have a table in my app that holds records my organization's users. I want to write a function that will set an Available field to false if they are logged out, and to true if they are logged in. Is there some way for me to do this in deluge?getYear() function not allowed in criteria - what's the alternative?
In my form1 I have a dateField and salePriceField. In my form2 I have a yearField and totalSalesField. I'm trying to insert records into form2 like below, but getting the "not allowed in left side of criteria error. dateList = form1[ID !=0].distinct(dateField);Open URL to a report record to edit from public
I have a form set up that my customers will input their full name and DOB to see if they already have an existing record. If they don't, then a new blank form will open for them to complete a record. However, if they do already have a record for thisZoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continueMultiple Instances of the Same Application
Can I have multiple instances of the same application and update each one from a master application. For example I build an application called Test, I know I can duplicate that application, let's say I create two copies called Cust1 and Cust2. Cust1 and Cust2 are now used and data is entered by my users into these two applications. I continue to develop the Test app with new tables, new views, charts etc. Now I want to copy these updates to Cust1 and Cust2 - how do I do that?Make A Different Row for each Multi-Select Item Selected/Submitted
I'm trying to get each item selected in a Multi-Select field added to a record, but have each selection be it's own row on the spreadsheet instead of all the selections be inserted into one row as a list. What can I do to achieve this? ThanksError message
I am trying to add field actions to the ORDER_TYPE field in the NEW TELCO ORDER form at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder. I have tried in both the old & new script editor When I add some code, I get the following error Error at line number : 10 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression When I remove the new code & try to save, I still get the error It relates to this row of code if (input.ORDER_TYPE != null) Why amFetch data from form and put in list !?
I want to fetch all the data in a form and put it in a list (or array) for further handeling. How can this be done easily? "Values = FormName" That only give a list of ID's for each row, not containing the actual values stored in form. An alternative is to make a loop with For each x in Values ...., That seam like a lot of work for something there might be a function for. Any suggestions, something similar to toJSONlist() or other? Thanks, LarryDeluge script for inserting url into image field
I want to insert a url in an image field, looking like this test value record.photo="<a href='https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_92x30dp.png' target='_blank' title='test'>Test</href>"; The value is inserted into the table with the script with this line: photo="<a href='https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_92x30dp.png' target='_blank' title='test'>Test</href>" I'm using a custom script for this. The script itself runs without errorsPivot tables stuck on regenerate
Quite often, I will regenerate my pivot tables in Creator and they will get 'stuck' on regenerate. i.e. they are not pulling through the entire dataset and the regenerate button is stuck on and out of use. This can go on for days and the only way I canForm fields in an email are not popultaing
Hi all, I am having a bit of a problem with form fields not populating when I send emails. I have the following code that runs when a form is submitted: from :zoho. to :zoho.adminuserid bcc :EmailAdd subject :"New Production Added" message :"<div>A newReducing Image File Size Using On Added or On Edit Deluge Script
Is there currently a way to reduce the size of an image upon upload using deluge script? If not, is this something being considered for the future?Function specified in criteria has returned null value and it cannot be evaluated
Im trying to evaluate if a variable is null. It doesnt matter if i use .isBlank() or .isNull() the line always returns: "value cannot be evaluated". I dont know how to handle this type of scenario. Error: Function specified in criteria has returned nullSingle select dropdown field to match selections from a multiselect lookup field
Is it possible to input the selections from a multi-select look-up field to be the only choices available in another field (single select dropdown field). Please see the below image for further explanation.Help with Deluge implementation - accessing reports variables from Sales page through code
Hello all, I have been struggling with the implementation for an app that I am working on and I would appreciate the assistance of the community. Brief Overview: The app is a Quote calculator/display page for on-site service sale. The sales agent willRecent UI Change in Zoho Creator's Application Sections: A Step Backward?
The November 10 update to Zoho Creator's Application Sections, introducing drop-downs for single-component sections, seems to add unnecessary complexity. This change slows down user interactions, leading to a less efficient experience. What are your thoughtsNeed help in ZML
Hi, I've design new page in ZML. I'm having an issue with the buttons, is there a way to reduce the button width? I can't find an option, is there some code I can copy? I appreciate any help... here's a screen shot - to make it neater. Thank you inCan'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 andTrigger Actions on Customer Portal Sign Up in Zoho Creator v5
When a customer signs up in the Customer Portal in Zoho Creator v5, how can I trigger actions, such as filling in a form field with their sign-up email address?Beware: Formula fields not triggered when dependant value updated via script
I wanted to warn application developers of a fundamental issue with formula fields. Formula fields do not get updated when the value of fields they refer to are updated via script. Create a simple form with 3 fields: Drop Down list– ‘Drop Down 1’ - with a script on user input to increment a numeric field by 1 - input.Number_1 = (input.Number_1 + 1); Numeric field – ‘Number_1’ - with default value of 1 Formula field – ‘Formula_1’ - with expression “Number_1” setting it equal to the numeric field.Unable to create many-to-many relation between existing subform and form
Hello, I'm trying to create a many-to-many relation between existing subform and form following this guide: Bidirectional relationship between main and sub-form | Zoho Creator Here's the structure. Form 1: Tasks - Task name (single line field) - StepsZoho Creator API - is there a way to retrieve reports of type other than List?
We are trying to sync data between Zoho creator and our dw using the below API; https://www.zoho.com/creator/help/api/v2.1/get-records.html However, we are unable to pull reports that are not of type List. The requests error out with: {"code":2930,"message":"ErrorCustomer Portal - Data Access
Hi there, Is there a way to enable customer portal users to see existing records (created by non-customers app users) ? I want to create a Customer Portal to enable clients to see product catalog, create orders, and see their history (orders, payments, etc.). However, their purchases and payments will be registered by normal zoho app users. The main purpose of the customer portal is to enable clients to see their own reports which will be populated by internal users. ThanksHelp for working with Rest API and Powershell using Creator
Hi i want to start out with that i am new to Zoho Products. and have been using Power Automate and many years work with PowerShell. I am trying to figure out what the approach is to create an app that can do lookup from API calls and maybe trigger a PowerShellZoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 2 - 2023
Hello Everyone, Creator's Release updates - Part 2 - 2023 Frequent product updates continually enhance the overall performance and functionality of the platform, ultimately improving the ease of using Zoho Creator and making it more efficient for businessesiFrame not Showing on mobile phones
Need help why iFrame is not showing on mobile phones. I have iFrame in a html snippet in zoho creator. It does show on desktop but when I tried on mobile phones, it isnt showing anything. It's just blank. Is there anyway I can do to solve this?How to add a new row in the middle of a subform
Dear All, I know that with the buttons in the subform I cannot do it but I was thinking if there is any 'hack' way via deluge. I have a subform and I fill the first 10 rows for example, then I click submit. For some reason I want to edit again this record and add a row between the 3rd and 4th row in the subform. The manual way is to delete all the rows under the 4th row and then add here the new row Is there any way to do that programatically? I know that with the Add Row we can add rows only inUse Zoho Creator as a source for merge templates in Zoho Writer
Hello all! We're excited to share that we've enhanced Zoho Creator's integration with Zoho Writer to make this combination even more powerful. You can now use Zoho Creator as a data source for mail merge templates in Zoho Writer. Making more data fromTip 10: How to fetch data from a custom module in Zoho CRM.
Hi Folks, A fortnight has gone by, and we are back with a new tip that would help you fetch data from a custom module in Zoho CRM and use it in a form created in Zoho Creator. As you may already know the default integration field does not list the custom modules that you have created in Zoho CRM. The current integration task will only allow you to choose from the default list of modules available in Zoho CRM (as show in the below-given image). However, if you want to fetch data from a custom module500 Internal Server Error
I have been trying to create my first app in Creator, but have been getting the 500: Internal Server Error. When I used the Create New Application link, it gave me the error after naming the application. After logging out, and back in, the application that I created was in the list, but when I try to open it to start creating my app, it gives me the 500: Internal Server Error. Please help! Also, I tried making my named app public, but I even get the error when trying to do that.Can regular user and portal user from China access to Creator in US DC (.com)
Hi, We are an American company that register Creator account with US DC (.com). Most of of customers are located in China, also there is a small office team in China. As title mentioned, would like to know will the regular user and portal user havingHide certain columns in a published report/page
I am working on a way to make a report in my app searchable by the public in a published page. A have a search bar that takes user input and assigns it to a page variable that is the filter criteria in my report. This all works fine, but there are certainUpdate adding dropdown menu for only one component
This "subtle UI tweak" results in double the amount of clicks for my users. I was making use of the fact that menu sections with only one component did not have a drop-down, so that those components could be accessed directly. Almost all of my applicationsUnhelpful Error message that could worry portal using clients
In my subform that is in list view I want to show and hide a simple field based on a boolean and it does work nicely and simply. if (row.boolean == "Yes") { show row.thing; } else { hide row.thing; } However if the user has toggled the radio choice andPop up error message window for functions
Sorry if this has been posted before, but I can't seem to find the answer. I have set up a button on each record of a view, when the user clicks the button a function is called to send an email. In the function, before the email is sent, it checks all the required info is present. If it is NOT present, all I want to do is show a message "Please enter missing info and then try again" and then exit the function. Seems simple, but I can't figure how to show the message.BUG?? Search in Page can pass only the Search
Hi, Since the page variables and scripts update, when searching with the Search component in the page, we can pass only the search string to the "Target Page" (Attached Screenshot) For me, it makes the Search component useless. Is it BUG or another stepSubtracting a value from another form
Hi, I have a form called performances which has 3 numerical fields: Number_of_Tickets_Available Number_of_Tickets_Allocated Tickets_Remaining I have another form called Tickets_Allocated. This form pulls the values of the three numerical fields from theZoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 1 - 2023
Hello Everyone, What is Creator's Tech Connect Release Update Series? Regular updates to the product improve the overall performance and functionality of the platform. As a result, using Creator becomes easier and more efficient for businesses of allDoes anyone know any workaround how to use javascript to published pages ?
Does anyone know any workaround how to use javascript to published pages ?Populating a form field from a report button
Hello, I have a form report that has a list of coach companies, and a column that enables users to add a review by clicking a button. (See below): There is an 'Add a Review' button on every line (next to each coach company. When the user clicks add aNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Zoho Creator Upcoming Updates - October 2024
Hello all! We continuously strive to enhance and improve Zoho Creator with new capabilities. Continuing with this journey, we're excited to share the latest developments and progress with you. Now, let's dive into the updates for this month: Widget JSAnnouncing Zoho Creator's 2024 Release Projection 2
Hello Creators! Greetings from all of us here at Zoho! We hope you’ve been having an incredible journey with this low-code platform we all love. And here’s a gentle reminder that it’s that time of the year again—where we open up and give you a sneak peekInteGreat 03: Integrating Zoho Creator with Zoho Books
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Zoho Books. This is one of the most popular Zoho integrations that our customers use. You can use this integration to automate processes like: Creating quotes and invoices in Zoho Books from within Zoho Creator Accessing quotes, bills, and invoices from within Zoho Creator Linking bills and invoices to a project and performing profit calculations With Deluge, you can use the built-in integration task to connect with theImportant updates to your connectors
Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of the[Free Webinar] Creator Tech Connect Series - Directory stores and device management in Zoho Creator using Zoho Directory
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Most Discussed Topics
Adding a customer specific record to customer subform
Hi, Can anyone point me in the right direction I have customers as a form with all their details on it. I also have separate jobs, tasks & assets forms that I can also fill out, now when I create one of these records let say for Customer A - I fill outError creating an XML file
I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} HowCreate list dropdown of all form names
Hi everyone, Can i create dropdown list by all form names? Thank youDesign custom page
When it comes to designing a page, you have basically 2 options either using "Html snippets" which has a limitation of not being able to render JavaScript meaning that you can't call specific action when a user clicks a button or modify the DOM afterHow do I get a hot link to and an updated field to be send via email
So when I new record is created there is a url shortcut to the new added record, thanks :)
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
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
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
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
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. CharlesIntroducing Creator Simplified: An exclusive learning series to enhance your app development skills
Hey Creators! Welcome to Zoho Creator's new learning series, Creator Simplified. In this series, we'll dive into real-world business use cases and explore how to translate your requirements into solutions in your Creator application. You can also expectANZ In-Person Zoho User Group Meetups: Focusing on Zoho Creator & Zoho Flow (September 2024)
Hello, Zoho Community! Calling all Zoho users in Australia! We're thrilled to announce the next series of Zoho User Group (ZUG) Meetups, continuing the success of our previous sessions. These meetups are a great opportunity to learn, network, and engageMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue
Top Contributors
Damien Cregan
Gordon Mankelow
peter.fraser
Sriram U
Muhamad Bilal