Rank records
I have a report of paid invoices including the field 'customer name' and 'total'. Is there ANY way, either with a report or a page that will let me know who my highest paying customers are?
Show same entry field in multiple rules
Hello, I am wondering if what I am trying to accomplish is possible. I currently have a dropdown field with numeric options (1 through 5). Based on which option is selected, I want to show that many additional fields. I have set up a rule that when 1
Open another form to edit a field directly through a report
Hi, In my app I have a report (let's call it "Actions") that shows comentaries from another form (let's call it "Comentaries"). Sometimes I need to modify what's been written in "Comentaries". It bothers me that everytime I need to edit a field I have to go to another relatory, find the register and edit it. My question is: Would it be possíble to call, directly from the relatory "Actions", the form "Comentaries" which contains the field I want to edit (in edition mode), edit the filed and submit
Add Workflow/events to Reports.
It would be good if Reports can have Workflow events to control what happens before a report is loaded so that only specific records based on user's request parameters can be presented before Report starts. This report parameters can then be saved as
Using ZC to send sms with an alphanumeric sender id via Twilio
Hi, I want to create an api to send a sms from zc via twilio. I want to send a sms with alphanumeric sender id, in that way sms receivers will not see a number, I can customised any sender name in that way. such as i can send a sms with my company name
Form Field Not appear in Lookup !
I have two equal forms, same characteristics, same drop menu, etc but one of them does not appear in the lookup. Is it a zoho bug? Has it happened to them? Have they solved it? Thank you !
Location of the data being stored
Hi, I would like to know where is my data being stored when I use zoho creator to build my apps? Is it being stored on public cloud like AWS/Azure or it's being store in zoho's own server? Would like to know where is the location of the servers,
Possibility to hide column
A query, there is the possibility of hiding a column of some report by URL parameter https://creatorapp.zoho.com/<workspace_owner_name>/<app_link_name>/#Report:<report_link_name>? hide report column parameter
Minutes Rollover
Hi, we are trying to create a minutes rollover because the support uses an allowance system (allowance varies from client to client). We have a form where minutes get stored for the course of 3 months because we allow minutes to roll over as far back
Show a Percentage on Panel in Zoho Creator Page
Ola party people, I am wondering how I could achieve a 'Percentage' that automatically calculates based on a count two seperate forms on a panel on Zoho Creator Page. I dont know any code, but im assuming it would be something along the lines of: Variable
building a custom Auto Number
I would like to create a deluge that will populate a field with a "work ticket number" That number I would like to build off of the last ticket done per "driver." So, what I would like to see is perhaps the last 4 digits of a driver's record ID followed
Map report isn't showing all records at one time
It seems that map reports only show X number of records at one time. Has anyone else experienced this? Does anyone know what the record limit is? (I've contacted Creator Support about this and will update this post when I get a reply.)
INVALID DATA when Create Record
I have a form to create new deals with a lookup multiselect´s field in other form. The field looking up is Contact_Name The script for submission is: **************************************** for each alum in Lista_Alumnos { var_map = Map(); var_map =
Add Data via API in Custom Subform of Custom Module
Hello everyone, I'm writing a custom function in Zoho Creator to create a Record in a custom module in Zoho CRM "On Success". So far, so good, the Custom record is created but when I try to add data to the subform within it, I get an error message : {"code":"NOT_SUPPORTED","details":{},"message":"the
Stored image field paths are incorrect resulting in not being able to view or downloaded the image
We have users who are adding images to records in our app using the Image field. There have been a number of images added recently that we are not able to access. Looking at a working image link via the API shows: "Commissioned_Photo": "/api/v2/<PORTAL_NAME>/<APP_NAME>/report/<REPORT_NAME>/<ID>/Commissioned_Photo/download?filepath=1623879656874_Commissioned_Photo.jpg"
Add prefix/sufix & custom text to Report Quick View custom layouts
In Report > Quick views, we can create custom layouts, which is absolutely great. This allow for nice customization. But we can't add any dummy/custom text. Meaning we can't add a "#" or "$" or "Quantity:" text any where in the layout. It really is a
Add Color filter feature to Report column buttons also in Page buttons too.
Adding Color filter feature to Report column buttons to show that the button is turned on or off just like an electric switch with a red light indicating the switch is on or off will be greatly useful and powerful. Better still if you could allow changing
Deluge Debugger??
Are there any support or plans for a more sophisticated/powerful Deluge debugger to be developed? Or is there an existing Deluge debugger only for Certified Deluge Developers? A powerful debugger that would allow breakpoints to examine and change variable
How to calculate the distance between two addresses?
Hello!! Is there any way to calculate a distance in km between 2 addresses and add the km result in a field? I think that there is a way using the Google API Distance Matrix (which is paid if I am not wrong) but I am asking you if you know a more easier
On Edit Record - Two separate Forms with Attached Sub Form Record Need Record update
On Edit -(Successful form Submission ) In Form A and From B both Sub Form Record would be Match on Edit some Record in Form A ( Sub Form ) Also Create Unique ID in Both Sub From but the Issue is Who to write Script Part
Restore function not working, Search & Filters in Pages behaving differently.
Hi, I am unable to restore my backup from last week. My pages with the search and report filters are behaving differently which prompted me to restore last weeks backup when it was working then. I notice there seem to be some changes to ZC since last
Can postUrl be used to make a POST that contains a JSON body?
I am trying to make a POST to a Google Calendar API and I need my POST in the following format: URL TO POST TO https://www.googleapis.com/calendar/v3/calendars/someone@example.com/events?key={YOUR_API_KEY} HEADERS Content-Type: application/json Authorization: Bearer MyTokenMyTokenMyTokenMyTokenMyToken REQUEST CONTENT (BODY) { "end": { "dateTime": "2014-04-19T17:30:00.000+05:30" }, "start": { "dateTime": "2014-04-19T16:00:00.000+05:30" }, "summary": "Trial Event" } Here is the ZOHO Creator code
Using Pivot Tables with Bi-Directional Relationships
Dear All, The context - I have 2 forms (VOWD, and Project) the relationship is 1 to many (1 Project, Many VOWDs) - I have created a Pivot Table based on the Project form - Using this Pivot Table (Project) I want to access the data from the VOWD forms - To do so i have created a bi-directional look-up field (Multiselect) in the Projects form the result is that I amnot able to view the VOWD form entrys in the pivot table! If i change the lookup field to "dropdown" instead of "multiselect" then it works
Weather forecast function or API
Hello all, Has anyone been able to integrate a weather forecast in any way for Creator? With all the events management and planning and calendar / booking applications, I think it would be an excellent idea and fairly simple to have a weather forecast
Can I embed an "edit mode" form on a HTML page?
I want to embed a form on a HTML page passing an ID as parameter so I can edit the given record. Is it possible?
How to pass values from Zoho CRM to Creator address field
Hello, Maybe it is an easy question but I have some issues of how to pass address values from CRM to a creator address field. I wrote something like the below and it did not work.... This is a sample of the code, in general I can pass all the values except
Android - Cannot close popup window following a openUrl call.
Code: // grab cstomer name and create list for current customer's old log popup CustName = Input_form [ID == input.Customer].Customer_Name; openUrl("#View:Popup_Logs?Customer=" + CustName,"popup window"); Problem. Using the Android App - when the Customer popup window appears there is no way to cancel it. The iPhone app has a cancel button to continue on to the main form. Any suggestions? Thanks,
Additional Components / Widgets / Controls
I am evaluating Zoho Creator as a potential replacement for an old Delphi program, but Creator seems to be missing a number of controls and components that are to be found in other development tools. In particular, I'm looking for: A "Tabbed Notebook"
How to remove an uploaded file
In my app TradeMaster (I have shared edit to support), there are many uploaded file fields. An example - "Picture_image_temp" in "SKU" Form. Sometimes, my users want to remove a picture. We have not found a way to do so. Please advise how to handle this request. Thanks.
Calculating Hours between 2 Time Fields in Zoho Creator
Note this topic is regarding the newly introduced time fields in Zoho Creator and NOT the Date-Time Fields. Consider there are 2 time fields in the form 1. Morning_Start_Time 2. Morning_End_Time In order to calculate hours between them, add the following script on user input of both the fields. if(Morning_Start_Time != null && Morning_End_Time != null) { mst = input.Morning_Start_Time.getHour() * 3600 + input.Morning_Start_Time.getMinutes() * 60 + input.Morning_Start_Time.getSeconds(); met = input.Morning_End_Time.getHour()
unique id for students
Hi, I want to create unique Id on load for every new form. Based on old record value I need to create.. for example: 1 ) If I created one rec with EEE-0001, 2) Next record need to show on load side with EEE-0002 Can any one help me in doing this
Deprecating Support for Authtokens
Hello! Zoho Creator's APIs enable you to access your Zoho Creator account and includes an authentication process to secure your data. The v1 APIs use authtokens, while v2 APIs are based on OAuth verification, which is much more secure. To enhance the security of this process, we are now deprecating our v1 APIs (that will reach their end-of-life on February 3rd, 2021) and disabling new authtoken generation in an effort to use only Zoho OAuth authentication. Existing v1 API users If you are using
Community 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
Single Lookup Field with Multiple Forms Relation
Hello, I am trying to create a new proposals tracking & sales incentives calculation application for my small-insurance business where sales persons sell different types of products (Life Insurance, Health Insurance, Motor Insurance etc.) and earn incentives
How can I fill in an address field with a lookup field's address field in Deluge?
I am trying to allow my user to create a job and select a customer from a lookup field. When the user selects the customer, they have the option to select a decision box "Job Address Same as Customer Address." If this value is true, the customer's address,
Any update on the V2 Bulk APIs?
I have a use case where I need to regularly request all records from a given form, where the number of records is in the tens of thousands. The V1 API allowed me to request and receive all of these records in one pull. The V2 API is restricted to 200
Zoho Creator app without a Form
Is it possible to create a Zoho Creator app without a Form? I'm looking to create a Zoho Creator app that will pull in info from Zoho Books, do some calculations on some of the bills and then create a Journal entry back in Books. The Zoho Creator app
Pre-fill field on the "New Value" popup form
I have a form which has a "Course Category" Lookup Dropdown and a "Course Title" Lookup Dropdown. They are "cascading" meaning that the "Course Title" list will be filtered based on the selected "Course Category". The "Course Title" dropdown also has a "Add New Value" option selected so that I can add a new Course if I want to but when I click that link it opens the "Add New Course" popup but without the "Course Category" selected. Since the user already has selected a "Course Category" in the initial
Embedded report not loading when using HTML/CSS in a page with a toggle switch to view 2 reports in a page based on toggle right or toggle left
I have a requirement to load 2 reports using a toggle button created using Html and css in the page section . I embedded the report like <div elName='zc-component' viewLinkName='All_Orders' params='zc_Header=true'>2 Loading View...</div> .I using this
Automatic Fill Using 2 or 3 Forms !
Hello, does anyone know how I can do an automatic field filling using two or more forms, as a source of information? I have this code, and it works perfectly for a single form search (In my example: Student1) but I want 2 or 3 more forms. I hope someone
Next Page