Where are the email templates?
I have created a form and there is an option to send an email upon completion of the form. I see a dropdown where I can select a template to use. There is an option for Template 1 and Template 2; where are these templates stored so I can see what they
New field limits on a form (No. fields vs No. characters)
Hi guys, Wondered if anyone could help me clarify something around field limits in a form. Zoho circulated an update in November saying that if we reduce the character limit of our fields, we can squeeze more fields onto a form. See here: https://help.zoho.com/portal/en/community/topic/upcoming-updates-november-2021
What is NOT and OR logical operators?
Hi all, new to deluge. What is this logical example means? Two Conditions with NOT and OR logical operators? ! (a>1) II (b<10) How does this differ from OR logical operator (a>1) II (b<10) The examples in Zoho Help doc text explanation are the same "implying
Storing passwords and api secrets on zoho creator
Hi, I'm fetching information from an external API .the user name and password for the API authentication different for each Zoho user. What is the right way to store user/password information so i can use this for the logged in user? Where should i store
How to call an API with oauth2 in script
Hello everyone, I've a problem and can't figure it out and can't find it here or somewhere else on the internet. I would like to call an external API that requires oauth2 authentication within a custom function in Zoho Creator. How can I achieve this?
Custom pdf file name when using sendmail function
I am using the sendmail function to email a PDF to a customer using Attachments :template:Quote as PDF The PDF is named Quote.pdf Is there any way to customize the file name? Hoping to use something like "Quote " + input.quote_number
NFC Tags readable by Creator Mobile Apps
We have a number of clients that need to be able to scan NFC tags. QR codes and Barcodes are great, but can we also have NFC tags? Many Thanks Simon
logging of the work performed by the administrator
For applications created with ZoHo Creator only regular users' activities are being logged. The work performed by the administrator is not being logged at all. Is there a way to enable logging of the work performed by the administrator?
Default filter in deluge
I have an application with a custom filter for a view. I want the custom filter to be the default filter when the view is opened (rather than seeing all the records, then having to select my custom filter from the filter dropdown). I can't find any reference in help regarding how to set a filter by filter name. EX: View is called 'Property', filter is 'properties in CA'. When a user selects the 'property' view, I want the 'properties in CA' filter to be immediately applied. As a follow on, I'd
Image Upload Field Size Limitations
Like most image uploaders I want to restrict my users to specific file formats and image sizes (eg, .png 256*256) How do I do this with Zoho Creator?
How to pass records from SubForm1 App1 into SubForm2 App2
Hello experts, Cannot figure it out ;o( Seems simple in theory, but becomes complicated in practice - usual story ;o) Problem: two different Apps - App1 and App2: App2 is the "main database" used by multiple teams. App1 is used by small team to update
URL Field - Scripting
hi, The form field type "URL" has three variables: "URL", "Link Name" and "Title" can you use scripting to access and modify these seperate variables? I want to dynamically create a URL field for each record. The reason for this attempt is to create "View this record" link for each row which goes straight to the individual record view. I managed to script this effect for the form using a "Single Line" which has only one variable. But only to find the system automatic URL linking broke the link once
You can use functions in report filters
FYI, I just learned about the attached the other day while chatting with support.
json error using Workdrive API
I get this error: {"errors":[{"id":"F000","title":"JSON_PARSE_ERROR"}]} Running this code parameters = Map(); parameters.put("parent_id","hu1rqabb159824ad8406eb64e8af38c01dfba"); parameters.put("name", "this is the name of the file"); response = invokeurl
Using subforms data for lookup fields
Hi! when I add a lookup field I cant choose as data source a subform from another table. How can I do that? KR, Victoria
disable form button in Zoho Creator
Hello is it possible to disable the enter button in a Form so when a person is entering data and is only partly done but hits the enter button on there key board by mistake which submits the Form I only want them to be able to submit the form with the buttons below the Form not the enter button on the keyboard how would I go about doing this.Thanks in advance.
Page - Panel or Gauge - Formula
Hi, I am trying to get an average on the past 7 days of records. Some days have multiple records, and others don't. Using the simple average calculate the average based on a number of records. I just need to take the sum of data and divide it by 7.
Update Record function Problem
I just got problem about Update Record Function, it change the data field to all records in the report. it just happen today since i use this function very long time ago. Anyone got the same problem, and how i quickly fix this problem by coding deluge
How do I make API calls in Creator?
I'm attempting to make an API call using the node "request" package. Whenever I execute the function, it says it executed successfully but there's never anything in the output. I'm wondering why that is. It seems like nothing is even being run inside
Encode Base64 image
Hi, I have troubles with encoding (base64) an image I uploaded after submitting the form. I got the source from the image, but when I'm encoding this source, I get an encoding string from the src as a string, but I want an encoded string from the image itself. Could you help me? My deluge code: or_image = input.Taken_Image; image = or_image; img = image.replaceAll("/sharedBy/appLinkName/",zoho.appuri); img = img.replaceAll("viewLinkName","Images_Report"); img = img.replaceAll("fieldName","Taken_Image");
Deluge bug? Accessing an encrypted date field
I have an encrypted date field on my form called DOB. Calling this from a report button workflow: info input.DOB; shows: 1018600 //not a date (encrypted text?) Calling `info` on a different, unencrypted Date field from the button workflow correctly shows
Passing encrypted value from Page to New Page
Hi, I am passing an encrypted value from Page1 to Page2 using the following openUrl in Page1: openUrl(...#Page:Page2_HTML?myReceivedID=" + encodeUrl(encryptedID),"same window"); However, in my encryptedID value if it contains characters such as '+',
How to get contact address fields from Zoho Books into Zoho creator form
Hi I have created an app which allows users to record a new retainer contract. The main form for this app pulls data from Zoho books using the Zoho integration functions. I can easily populate a dropdown field in my creator form with a list of all company
Production - Training - Development Copies of the Same Zoho Creator Application
Thanks for taking the time to read my post. We have a project that requires us to keep 3 copies of the same Zoho application. One is for the Production system (which the client will use for their day-to-day operations), the second is a training system (which ideally is a copy of the current production system for use in training their staff and team members, clients, etc. on the Zoho application) and the final copy is a Development copy (to be used by our Zoho developers for making bug fixes, new
How to add a custom node package to Creator?
I'm attempting to call the Braintree API through Zoho creator by making a custom function in NodeJS. In order to run this code, I need to install the Braintree node package but I can't seem to figure out how to do that. I can upload files but not entire
Creator Page- Gauge Minimum Value
How do you set a minimum value on a gauge other than 0? I would like to have a gauge where the target value is zero, and the values range between -20 and +20, for example.
how to show / hide custom action button for user?
hi! made few custom actions and a number of reports with custom actions in report i can show / hide fields for user logged-in how can i show / hide custom actions for such logged-in users? making duplicate of reports (with different actions in) is too complex for this task
Dynamic addition of fields in stateless form
This is with reference to dynamic addition in stateless form , ZOHO PEOPLE, where in a user can click on ADD NEW and a row of fields appears in the same form , LIKE adding WORK Experience more than once. How can we achieve this in ZOHO creator.
From a Widget on a page, how do I open another page when the user clicks on a button.
I have a page where the user can see a summary of all of their bookings in a nicely formatted (will be once it's functional anyway) fashion through the customer portal. We have another page that is dedicated to taking payments for said bookings. How do
New App (Coda.io, Notion.so based)
Hi Zoho Team and Community, I'm currently testing two apps for my business requirements to build apps more easily: www.coda.io www.notion.so This apps have certain advantages compared with Zoho Creator: Databases are easy to deploy Database Views are
How to insert data from subform in to subform
Suppose, I have a FormName1 that has a subform1. after successful form submission, data of FormName1/subform1 should be auto submitted to FormName2 and FormName2/Subform2.
Does Creator support functions been called by outside system in creator 6
Does Creator support functions been called by outside system in creator 6?
Area Calculations
I take in GPS points of an area, how do i calculate the size of the area in creator?
Urgent - open url not working
Hi I can not work out why this URL will not open. Please help. This is urgent. Code: if(Convert_to_Trial_Booking == "Convert this record to a Trial Booking - then archive this record") { insert into Book_a_Trial [ Added_User=zoho.loginuser Age_at_31st_Dec=input.Age_at_31st_Dec
Is there a phone number/e-mail to contact regarding zoho customer service?
I'm looking to talk to a zoho representative via e-mail or telephone for some customer support! Is this possible, or is everything online?
Why zoho's deluge platform does not include any asymmetric encryption functions?
Asymmetric Encryption uses two distinct, yet related keys. One key, the Public Key, is used for encryption and the other, the Private Key, is for decryption.The Private Key is intended to be private so that only the authenticated recipient can decrypt the message.As of now zoho only allows developers to encrypt the data with only one key with AES encrypt function which is symmetric Encryption which intern uses only one key but when dealing with banking and other service's the providers expect their
Zoho Chat Notifications through Creator or API
Any thoughts of having Creator send notifications through Zoho Chat? I think this would be a very helpful feature.
Current User inside a Widget
Is there any way to get the current user inside a widget? We are currently in the process of setting up a Customer Portal where our client's customers will be able to log in to view the bookings that have been made for them. We are currently saving the
I want to translate the form of Verification Code
Hello! Is it possible to code something, or otherwise translate this part: I want to translate the form of Verification Code (enter the characters you see in the picture Above) PIC: Is this possible? Can not add system CAPTCHA code system? It would be easier and easier to understand ...
Form not allowing us to change the name due to strange permissions error
As a Super admin on a zoho instance we have a strange error condition where one of teh forms is not allowing us to change the name of a field. The error message says that I "do not have the permission to rename the column , only workspace admin has the
Next Page