Approval Process
Hi, I am not getting approval process on my Development Portal. Is it a problem with Creator Version or something else. Please help. Thanks, Milind Manohar
Converting Inches to decimal
I am trying to figure out how to create a form field that I enter in inches but it converts that input to decimal. I.e. I put 6 1/2 x 6 1/2 and the output would be 6.5 x 6.5. Thanks for any help
Subform report not showing related fields
I have a "Notes" subform containing the following fields: Job ID Time Notes It is linked to a parent form called "Job" by the lookup field Job ID. I want to create a report that contains fields from other the parent form and the subform. Parent form fields: Job Number Invoice Number Customer Subform fields: Time Notes I created the report with the above fields, but none of the parent form fields show any data. I created the report based on the subform. I'm not sure if I linked the forms incorrectly
Deluge Push Notification Error
Hi, I am unable to create a push notification to mobile apps using the following deluge scripts: notification = zoho.pushNotification("myemail@email.com", "New Request", "Variable", "Report_Link", input.ID); Error return "ID" is not defined. I am not
open url issue
Hi Everyone, Could anyone help me, please with my issue? I have three forms: Partners, Form1 and Form2. Both Form1 and Form2 has a lookup field with Partners form>>>Partner name field. If Form1 is submitted it opens Form2, and I'd like to populate Partner
Import/transform data from one application to another and preserve record ownership
I am upgrading an application, and for various reasons it has been necessary to do so by creating a parallel application with the new forms/tables, reports, pages and permissions. I now need to move data from the old application into the new one. I created
Custom function for each row
I am still new to deluge and have never made a custom function. I am creating a custom function that totals the price field in subform entries. I have tried using "for each," but I can't grasp what the arguments are supposed to be to make it work correctly.
Filtering Drop Downs in Zoho Creator
I have a very simple app. I have a table of organisations and a table of contacts. Contacts are a subform of organisations. So I can easily create contacts specific to an organisation. As you can see in my screenshot my organisation Great Orthopaedics
Execute a function or call a function as a specific user?
Since we are not able to explicitly set Added_User (record ownership) in script, is there a way to execute a function or to call a function and have it execute as if it was being executed by a specific user?
Adding Subform row when adding new row in deluge
I am still new to deluge, but I have have trouble locating information on this. I have an online order form for my website. I would like to have a button to move that record information my main order form. I created a button in that report view of the
How to OpenUrl to print a report that's filtered w/ a collection variable
I want to open a filtered report in print summary mode to print a series of barcode stickers for inventory, here's what I'm doing, but it's not working: stickers = myForm[Added_User = zoho.loginuser] sort by Added_Time desc range from 1 to input.Qty;
Append Sorting
Hello Everyone! i have been going through how to sort or filter my DropDown based on selected DropDown in the Main Form, The DropDown works as expected where i fetched the Data from Subform of another Form and it works. my Problem now is only sorting,
How do you add buttons to a form?
Hello, I am new to zoho creator and I would like to add several buttons to the form But i can't see where buttons are for the same
Export Zoho Creator Report By the API
Hello Team, Problem Statement:- Is there anyway we can export the Report in Excel or CSV Format by the API inside the zoho creator. if anyone have knowledge in this area please help with the API. Thanks & Regards Piyush Goyal +91-8619164837
insert multiple records from a number
The reason I write is that when the user enters a numerical value, this value performs a mathematical operation, for example, that the final result was 7, what he wants the system to do is insert a new record in another module depending on of the amount thrown by the mathematical operation, for example 7 e system creates 7 records for that record. I know that in other programming languages I only use a FOR (i: 0; i <7; i ++) and inside I specified that I wanted it to work. In this case, how can we
Can you change how reports are filtered with deluge?
Hi all. I'm using C6. I have a list of records that categorize upcoming events by the sport played, with several lookup fields to other forms. While using test data, the reports are functioning as desired (I have kanban and list reports, and a calendar).
Report - image - custom action - button
I'm looking for info or codes to integrate an image on a "custom action" button in a report and not just text. Is it possible? In the report custom action "Etapes" ( workflow = Etapes show action in view header = true show action in edit record menu =
Transfer portal users to new application?
I've had to set up a new application in order to do some major changes to an app. I'd like to move the existing portal users to the new app. Is there a way to do that?
How to deny access if accessed from Mobile Devices/Tablets
Hi, I'm currently developing an attendance tracker application. Is there a way to disable the application if accessed from other device aside from PC/Laptops? Or is there a way to disable access from other device? Thanks
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 Desk to Zoho Creator
Hi Zoho Team, Do you have a sample code to link ticket records from Zoho desk to creator because our team is trying to automate the form and one criteria that we would like to test is by a trigger event - input by user. Example: Ticket Number search then
How to display hyperlink field value as a word/title rather than entire address in report view?
I have a hyperlink field in a form populated with: https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3. How do I display this value in my report view simply as "Audio"? https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3
Add Rows to a SubForm Using Deluge
I got a form called Invoices with customer data and a subform that contains the fields: product, qty, price, subtotal. I also got a lookup field on the form used to lookup a quote number, so when I choose the quote number, the Invoice form is filled with the customer data and the subform is filled with the products data (product,qty,price,subtotal) present on that quote. I had read (post of 3 years ago here) that is not possible to fill data to a subform because only the first row is filled (in fact
Fetch, Update and Delete Subform records using criteria in Deluge
Hello Creators, While using standalone subform (not linked to other form), to find a particular record, we have to iterate through all the rows manually and this is definitely is cumbersome, instead it would be great if we can fetch, update and delete the sub form records just like form For Eg: Form_A is the main form and Subform_A is within Form A, it will be great to have a function like record = Form_A[Subform_A.ID==id]; (this should return only subform field collection not Form_A field collection)
Deactivating Enter in Creator Forms
Is it possible to deactivate the submit command when hitting the Enter key inside a Creator Field?
Is there a system variable for the base URL?
If I promote an app from development to production, the base url changes, from https://app.zohocreator.com/ to https://{org name}.zohocreator.com/. Is there a variable available that will return the base URL for the application in the environment it is
Create a ZML component/snippet that can be used on multiple pages?
According to Zoho's docs, "Snippets are stand-alone, re-usable code pieces." Is there a way to create a ZML component that can be used in multiple pages?
Zoho Creator 6 in Zoho One
Hello, Is there any ETA when Zoho One users will have Creator v6? Thanks!
Does anyone experiencing issues with downloading uploaded files?
My clients (different accounts and apps) getting this error when trying to download uploaded files.
Auto Document Number based on Dropdown Input
Hi Guys, I am a newbie and I am trying to automate document numbering based on user input from a dropdown or lookup input. For now, I used a long dropdown list and was following some youtube videos to create this code. The code seems to work, but it keeps
How to add portal user as approver?
Im struck in the process of creating a Approval Flow . I want to make portal user as approver but approval page is not showing to portal users . so, how do i add portal user as approver?
Displaying an image from a subform on a record template.
I'm trying to display images from a subform in a record template. It is working however I would like the images to shrink to fit on a the A4 page which I've set the record template to show. I'm pretty sure I need to edit the HTML on the record template
Need a solution to navigate or create dynamic links for long forms
Novice coder. I am using creator to customize an app for a particular project. The forms required are extremely long. How can I shorten the forms or make them easier to navigate?
Validate form based on subform fields not working
Can anyone tell me why this doesn't work? It runs on validate of my Projects form, which has the subform Tasks_Subform. An equivalent workflow run on validate of the Tasks form itself works perfectly, but the below code just seems to do nothing. The Projects
Pivot Charts in HTML view
Is there a way to create pivot charts through html without using javascript since zoho creator does not support javascript and I since I am also unable to use the pivot charts in the reports since the data I would like to display is inside a subform.
Export buttons to an html page
Hi All! I'm triying to add an "Export to Excel" button to my html page. anyone with a suggestion for this? I ran through the forum but did not found anything... Ravid
Explain About Parameter In Zoho Creator Custom App
Hello, Please Explain Me About Parameter. Any Custom App > Open Any Page,Form, Report or Anything. > Click On Setting > In Setting In Last Module Is Parameter. So Explain About This & Explain How To Use This. I Attach Screen Shot For Where Found Par
Does thisapp.portal.profileForUser work for demo users? i.e. in an environment
I am developing updates and have set up environments under Creator 6. I am attempting to test code that should react based on the permission set of the logged in user, however when I call thisapp.portal.profileForUser I get an empty string: userEmail
Portal User: error adding user
When I attempt to add a portal user with an email address of the form <base>+<discriminator>@<domain>, I receive a message that there was an error adding the user. If I specify an email address without the '+' character in the local part of the address,
Incorrect Documentation AGAIN
This is frustrating...Seems the documentation is wrong again here. How can I add a developer to Zoho Creator 5 application? This does NOT work: https://www.zoho.com/creator/newhelp/app-settings/add-developer.html Thanks for your help.
Next Page