Where is the reference page of all applications, reports and fields?
In the link here, it says that we can find the link name of application, reports and fields at this URL. However, I have no luck with that. It seems to be pointing to a wrong URL. PFB the screenshot of the same. I know there are other ways of getting
Is there any way to hide a row in a subform?
I have a subform on the main form which is a service ticket. The techs enter their time on the job on the subform for each trip. The seem to keep deleting the previous row on the form by mistake. Any way to prevent this? Thanks in advance.
Adding Script for a Button in a stateless form
Hi, I have added a button to a stateless form. But I am unsure about how to add a script for when the button is clicked. Can you please let me know? PFB the corresponding configuration
Generate a single Custom Report PDF with multiple records
Hi, I have created a Custom Print & PDF Template for a Report. I would like to know if its possible to select multiple records and export them under the same PDF (rather than having a separate PDF for each record as the system does by default) For instance,
Is it possible to http post to a form or html page?
I would like to post the incoming messages to Twilio into Zoho Creator form. Twilio allows to specify a webhook url to post the message data when an incoming sms is received. Is this possible? I do not want to use any intermediate php or any code.
How to specifying the encoding format as UTF-8 when using MD5 encryption.
Hello everyone Has anyone encountered this situation? Data interaction between zc and other platforms through api requires md encryption. Corresponding to the encryption format that needs to be specified as UTF-8. So ,How to specifying
open *existing* record for editing via Deluge or embedded in page
I have a page with embedded reports showing different views of a single record. The built-in Edit function opens in tiny panes where only a few fields are visible at once. To improve usability by making more of the field visible, I want to open the form
"Lead Management" built-in app
I'm trying to understand how the built-in lead management app works. For example, I can't figure out the relationship between "Leads" and "Accounts". Are you able to convert a lead to an account? Does anyone have any documentation on this built-in app?
Change Form Width
Hi Zoho Community, I am facing an issue with respect to Form Spacing. The below is the normal spacing of a form. However, for one of the forms, the two columns have a big gap in between. I am new to Zoho Creator. So, I am unable to debug. Please let
Subform: On Delete Row - For Each Record still accesses deleted record
I have a main form called Invoice which contains a subform called Alterations. The subform Alterations basically contains line items of my invoice which the dollar value is added up on a currency field of the form called Alterations_Total. I created the code below for a "subform: on delete row" event. The issue I'm having is that the record just deleted on the subform still gets accessed by the loop "for each record". That is causing my Alterations_Total to still take into account the last deleted
UPS Tracking API Certificate Change
Hello, I received the following email from UPS about a change to their API certificate. We use invokeUrl in Zoho Creator to track UPS shipments through the UPS API. My question: Is this something I need to worry about, or is it handled between Zoho
Reverting changes for invalid rows
On the form validation I can check the old value of a form row and compare it to the new value. However, I can't find a way to generically revert all changes on a row to their old values. This is what I'm trying, but I can't find the right function for
Custom Domain?
I just don't find it anywhere.... followed the instructions as on this page: https://www.zoho.com/creator/help/general/zoho-creator-for-your-domain.html There is no way for me to add/edit my custom domain. Please can you clarify as I am testing the system and upgraded to paid version and still no luck.
Bulk email limits
Hello team, In my Zoho creator application, We created two forms one is to create email groups (Each group contains many number of emails) and another one is to send emails to the group of emails that we already created. We are using send email function
Open & edit linked record in report
I have created an 'archive' custom button in an 'orders' report. On click of 'archive', I want to open the record of the CUSTOMER that this order relates to. Customer is a lookup field and therefore has a link to view the customer record in the report,
Passing Parameters to a View via URL
I need to pass a variable from a "passive screen" to a View screen. The data is to be used in the evnt that a user wants to "ADD" a record via the view screen The value that needs to be passed is not a constant (like 1234) - the value will not be known so the openurl can not have a constant passed through. How do I use the openurl command with a variable to be passed - not a constant. http://creator.zoho.com/zchelp/employee-manager/#Form:Employee?Employee_ID=<variable name> Here is the instruction
Creating a stateless form to have a supervisor sign an employee filled out record
My goal is to have an employee fill out a request form, sign it, and when submitted an email will be sent to their supervisor (one of the fields the employee enters is supervisor email), with a record template filled with the record information, and a
How to view Record ID in front end of a report?
Hi, I would like to see the Record ID of a record in the frond end of the application (May be in the detail view of the Report). Where and how can I see this information? (I know how to fetch it in the back end)
Workflow not evaluating Checkbox value
Hi, I have a checkbox with just one option as shown below. Checkbox with value Based on whether the checkbox is checked or not, I would like to show the fields. I have configured a WF based on the same. PFB the configuration. WF Condition However, on
Username required to filter report as HTML snippet
Hi, can anyone help? I want to filter a report in an HTML snippet, however even thought the article I found is useful, I can't work out what is my username to use in the url. My username is my email address used to logon to Creator Developer Custom Solutions
For each : Skip if field is missing
I've created a set up that will allow my users to import a spreadsheet and via a Function it will run through each row in the imported daa and update matching records in a chosen form/report. It's strange that Zoho Creator doesn't have this function as
java return statement returns {"output":"TestData","log":"[\"Log Data\"]"} how to get exact return as a output?
import java.math.BigDecimal; import java.util.ArrayList; import java.util.Collections; import java.util.HashMap; import com.zoho.cloud.function.Context; import com.zoho.cloud.function.basic.*; public class JavaCurToWords implements ZCFunction { public static String convertToIndianCurrency(String num) {
V2 API: What is the status/response code and message when hitting the 50-per-minute rate limit?
The documentation states: API requests are limited to 50 per minute, per API endpoint, per public IP address. Two questions: what is the specific error code/message that is returned when that limit is hit? I don't see anything specific to that here: https://www.zoho.com/creator/help/api/v2/status-codes.html
Export Creator Share Details?
Looking for a way to export "Shared Details" for my Creator application. I've ~180 reports and views for which I need to see who currently has access. Manually opening each and copy/pasting who's has access is proving very time consuming.
How to check if image upload field is empty?
I have a form that has an image upload field. I want to be able to check if there is no image in the field. I have tried: if Image_Field = null if Image_Field = "" if Image_Field = empty But can't seem to crack it. Any help would be appreciated.
Workflow - on user input deluge function - issue with combining Boolean expressions
I want to fetch records from a Contacts form based on condition where Contact in a campus and Contact may be a 'Controller' or 'Both'. I write the expression like this in the deluge editor. It updates it without any errors. controllerList = Contacts[((Campus1
auto adding brackets to my if statement
I'm using free-flow scripting and have a reasonably complex if statement being used to filter a whole bunch of criteria in a search form. It was all going along ok, until I added the tenth criteria. As soon as I did that, Deluge decided that I had the brackets all wrong and has added in 5 more sets of brackets and completely broken the logic. So to the Deluge developers, please leave my brackets alone - I know what I am doing here. My If Statement if (((Item_Type_Rec = input_ItemType) || (input_ItemType
Grouped record filter criteria losing brackets
On one of my HTML pages, I am displaying record counts based on filtered sets of records from forms. e.g. number = Form[A == B && (C ==D || E == F)].count() What I've found recently (I've not noticed this before a few weeks ago) is that on save and reload of the page editing screen, the brackets around the criteria in the OR statement are disappearing. Is this a bug? Thanks.
IOS Apps not working - URGENT
We've got several IOS and Android app live through the app store from Creator. They've all worked fine up until the most recent version done a few days ago, the IOS app was re-codesigned and uploaded to the app store, approved by Apple and made live. This now appears with only a blank screen when a user clicks on it. Some slightly older devices seem to work fine with the newest version of the app when it's downloaded for the first time onto the device, however any devices which have previously had
Data upload after creation of the pages
Salutations. I have created a form using creator and uploaded some test data from our sql server. I am able to open the app from mobile, system etc. And manually keyin new values. My question is: Since I have uploaded only a test data during the creation,
is it possible create a zoho app in every customer has their own data
Hi everyone. before starting learning with zoho creator apps i'm insteresting if it's possible create an app with this features: every user/cliente (obviously every user has their own login user and password) get his data (imported from google sheet or
User restriction
Hi I have two fields Project Name and Name of site Incharge. While creating project i have to assign Site Incharge to each project. The output i want: When Site Incharge login's with his credentials he should only view Projects assigned to him. Need
Getting Special email tags in CRM
Hello, I want to get the values like page url in CRM. How could I do that can you please help me with that?
Adding a report using information from 2 forms and a subform
New to Zoho Creator 5. I am trying to create a report using the data from a form and a subform. Is that possible in Zoho Creator and if so, does anyone have any tips on how it can be done? Thanks in advance,
How to view most recent order from same customer
Am running into trouble with conditional formatting in Record View. And I think it's because what I want to do isn't possible in Record View and I should add some kind of status to the Form itself which automatically updates with some code. I want to
Tip 15: How to schedule a task that runs at specific time intervals
Zoho Creator lets you schedule most of your routine tasks, to help you focus on the important stuff. You can automate things like: Generating invoices once a customer places an order. Generating monthly revenue reports. Setting up acknowledgment emails for users or customers. With Zoho Creator, you even have the flexibility to schedule jobs that run multiple times a day, or at specific time intervals. For instance, you might want to set up workflows to send out a project progress email on a daily
APIs - what is the file upload limit for pdfs ?
I have created a function that uploads pdf documents from a url so that I can effectively move from an old system to Zoho. I read on this page : https://www.zoho.com/creator/help/api/v2/upload-file.html The image and signature fields can accept an image
Variable Fetch Records Criteria
Trying to create a dynamic list that as users select the various other dropdowns on the form the the list displays all the records from another form that match the selected criteria. Since not all the dropdowns will be selected I can't just use the standard fetch records method r = FormName [Field1 == input.Field1]; Because it would try to match all the blank dropdowns as part of the criteria. Is there any way I can create a variable criteria based on which dropdowns are actually in use?
How to set value of dropdown based on another field?
Hello, I'd like to set the value of a dropdown when I can determine certain formats in a string field. Specifically, I am entering shipment tracking numbers and I want to set the associated carrier based on the string's format. The best example is probably UPS because their tracking numbers usually begin with "1Z". This is my first Deluge script so I'm probably way off. It has no syntax errors but it doesn't do anything. The workflow I setup is "on update" and states that it will be executed as the
help with coding multiple pages fetching data from forms
I am new to using deluge, figured it would be easier than building a database and etc from scratch, however I haven't been around html/scripting since 2005 so im a little outdated and not picking it back up as expected. I'll try my best to break down
Next Page