Hide 'Add' button on a report
Hi All I have created a report using the summary view for use as a settings page, where I have added decision boxes for things like notifying users by email when a record has ben added. If the field is checked, an IF statement checks the condition of the decision box before sending the email (email is sent if decisionbox is true/not sent if decision box is false). I have limited the number of records in the report to one, however, my question is, can i disable or hide the blue 'Add' button on the
Image field preview and download are broken
Something changed recently (rights-wise?) in which my non-admin users are presented with a broken image icon when trying to view images in a report's Quick View or Detail View. When they click on an image, they receive the following error message: "Something
Can I connect Creator to a user created module in CRM
I want to be able to create a trigger which, when actioned, will add an item to a custom module i created. Is that possible? In the conenction setting between creator and crm, it only has a few modules. Thanks
Sample code for passing parameter to a widget. And code for fetching record in a look up field.
Hi! Im trying to create a widget but I didnt know how I can pass paremeter? There isnt much documentation avaialable? If I have the widget in a page and this page has parameter. How can I pass it to the widget? Also how can I get record from a look up
Rename the attachment from record template pdf in the sendmail deluge script
Hello Zoho, I urgently need a feature to rename record templates that I send via the sendmail feature. The program I created sends emails to clients with an invoices that have been created in the invoice database. If the user selects 3 invoice numbers,
Feature request: Zoho Creator - Zoho Writer integration for mail merge
Hi, I've set up a purchase order template on Zoho Writer and I want to have the fields in my template linked to the fields in a report in Zoho Creator. So far I was only able to achieve this by exporting a CSV file from ZC and importing it into ZW through mail merge. Is there anyway to automate this process? Will Zoho consider integrating both apps?
Is it possible to disable add entry feature when clicking on date grid in calendar report
Hi, I am having a calendar report. The event records are added using deluge to the form associated with the calendar report. Basically, I want to use the calendar report only for viewing. But, clicking on the date grid brings up the corresponding add
Zoho Developer Creator Privately Published app, cannot remove clients?
When creating an app through the creator developer space and publishing it privately to a client, is there no way to remove clients? View clients from the developer dash shows the clients but no way to remove them? Deleting the app to effectively “remove”
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 this
Zoho 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
Multiple 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? Thanks
Error 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 am
Fetch 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, Larry
Deluge 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 errors
Pivot 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 can
Form 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 new
Reducing 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 null
Single 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 will
Recent 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 thoughts
Need 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 in
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 and
Trigger 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) - Steps
Zoho 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":"Error
Customer 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. Thanks
Help 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 PowerShell
Zoho 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 businesses
iFrame 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 in
Tip 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 module
500 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 having
Hide 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 certain
Update 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 applications
Next Page