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
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
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,
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
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
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
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?
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
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
Validate and prevent data entry
Rather than using the form validation to revert changes, is it possible to cancel or revert the changes to the original value on the "User input of a field" event rather than waiting until they're done and doing it. e.g. you have an order that has multiple
MYOB Integration?
Can Zoho integrate with MYOB ??
Can't add Application
Hi, I can't seems to able add new pre-built application from the gallery. Please advise. Thanks.
Null Value in Lookup field
I have setup filters in my lookup fields so that only districts and local level government's (LLG's) of a particular province will show when clicked but I keep getting the null value in front of the LLG lookup field. You'll find a screen shot attached
Product Catalog App > Add to Wishlist (Bug on Selecting "No")
It seems the logic used is not properly configured. When clicking "NO" option it will not Cancel the action but will just Loop to Add to List
Can Consolidated reports be created?
Hi I want records of a form to be consolidated and sent to the admin of the Creator Application on a scheduled time is it Possible?
Enable report button based on field
I have added a button to one of my reports. I want this button to do something (open a URL) if there is a value in one of the fields. It fires fine for the records where there is a value in the field "related ticket", but it also fire when there is nothing
Updating selected values of a multi select field via Deluge
Hello, I have a form with a multi select field with a couple of options. My form already has a few thousand entries, and now I need to add and select a third option for that multi select field. This is the code I'm trying to use: //Fetching all records of the form Nueva_venta todas = Nueva_venta[ID != 0]; //Go through each record and select the new option for each entry in todas { entry.Acceso.select ("operaciones@simstore.ec"); } The error I get is: 'Acceso' does not exist in this form I was also
Australian address autocomplete
Address autocompletion is a popular feature on many websites that helps users correctly input a valid address. Here is a link to the vendor's website with a demo of the functionality. https://addressfinder.com.au/ They have extensive documentation and
How to Configure push notifications
Hi Community I am trying to Configure Push Notification in creator but the documentation does'nt help me to navigate through the process. Can anyone help!
SalesIQ- Creator integration
When you guys provides the SalesIQ- Creator integration?
Replacing Dropdown-Field by Lookup-Field
Hello, within my first steps with Zoho Creator I made a form with a dropdown field. Now I'd like to change it to a lookup-field that gets its values from a different form/view. But changing the fields type seems to be impossible (probably to keep data consistent?). I would make sure that all values of the existing field (dropdown) would be part of the new possible seletion (lookup values) but anyway ... I can't change the type. (btw: Starting over is not an option, because there's already too much
Sending last Subform Entry in email
Hi All, I'm new to Creator and trying to sort out some Workflows which automate emails. My form (NCR) has a subform (NCR_Actions), the subform is used to log the actions taken against each record. I am trying to automate an email to an email address in the main form every time an NCR Action is added. So far I have created a Workflow - Deluge Script - Subform on add row. I have created a Send Email task in script and as part of the message I want to include the contents of the Action_Taken field of
Next Page