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.
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
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
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
Is it possible - when we invite user from portal user , then using deluge add that user into report using deluge ?
Hi, Is it possible - whenever we invite user from portal user , then using deluge add that user into report using deluge ? Please let me know if have questions. Thanks and Regards, Sidhant A.
Calendar report focus
I want the calendar report to display in a month other than the current one. Can I do it by passing a parameter in the URL? I want to put the focus on a specific month.
multiple threads of api request? merge getAllRecords?
in widget development we use this JS to get all records of report: ZOHO.CREATOR.API.getAllRecords(configg).then(function(response) this is a "thenable" function that runs when a response is resolved. if i have more than 200 records i would like to join
Can't get QuickBooks integration to work.
Grrr... I'm nearly at my wits end trying to get QuickBooks to work with Zoho Creator. I have followed the instructions on the Deluge Reference Guide:Integration with quickbooks:Search records in Quickbooks page (https://www.zoho.com/creator/help/script/quickbooks-search-record.html ) and it just does not work. To begin with, the response I get from QuickBooks is not the same format as it is shown on that page. Here is a sample of the response I get from QuickBooks: {"time":"2016-01-26T15:00:46.904-08:00","QueryResponse":"{\"Customer\":\"[{PreferredDeliveryMethod=Email,
How can i export user in old UI ?
How can i export user in old UI ? As there is only import option is available not seen export option. Use case- i want to copy all emails and store into other report , so i can work from report directly. Thanks and Regards, Sidhant A.
Alphabetise field names in "Refer Fields" section of deluge
When using the "Refer Fields" section of deluge to view field names in various forms they are in no order so it's a nighmare trying to find the right one in a long form. Please can these be in alphabetical order ?
Autopopulate subform field based on lookup field in that subform
Hello. Im trying to make quotation app in the creator. I know very little about coding so I code based on what I find in the web. I cant figure this one out tho. I created a form with which I add my services to the list. Each service has its name, cost,
Zoho Sites and Creator Integration
We have Zoho Sites which is an awesome drag and drop web builder and then we have Zoho Creator which is an awesome drag and drop database builder with a feature to build html pages. Why do we not yet have these two awesome apps integrated? Why are we still writing 100's of lines of code just to display information in an html format? This integration would be such a huge game changer it would be an unfair advantage over other site builders or low code app builders. Is this in the Zoho road map?
Zoho Creator App Code Sign Error for iOS devices
Hi everyone, I'm trying to download Zoho Creator Application for iOS. I fill the form with certificate.p12 file, Provision profile and APNS p12 file . After clicking "Code Sign" button the process of generating the mobile app seems to be started but I
Url for a Records Payment Gateway page
Hi Is it possible to write code that will fetch the exact url for a particular records payment page? So for example this here: I would like to use it so that I can send it to the customer if they exit out of the page before making payment or if their
Any ZOHO builds for the Promotional Product space? Specifically PromoStandards, ESP integrations?
I know a few companies in the Promotoianl product space using Zoho CRM only. Is there anyone on here who has experience in this type of unique build dealing with PromoStandards and or ESP APIs.
Subform code help
In my application, I have a list of students for each class. I input all student names from the class to a roll to be marked via the script below. Each student in the list has their own record and I am trying to find a way to input each students photo
Subform help
I have a plan of what I want to do but no idea how to do it! If anyone can tell me if its possible and how I would go about doing it would be really helpfull. I have a form called "Mark_Class_Roll" which has a subform in it called "Student_List". To
Disable Fields in a Spreadsheet Report
I am VERY new to Zoho, and I am trying to create a spreadsheet report to allow me to update multiple reports in a grid. I have figured out how to include and exclude fields, and how to limit the report to only allow edits, but I can't figure out how to disable some fields, but not others. I want to be able to assign a "follow-up type" (mail or fax) to a record, but I don't want the user to be able to change who the record is assigned to, only change the "follow-up type". Is this possible? Thank
Pop-Up "Close" & "Cancel" Buttons disappear after Cancel Submit
I have a Pop-Up Form. In the validation workflow, I have a Cancel Submit for when I client doesn't submit the correct information on a SubForm. The Alert and Cancel Submit return to the Pop-Up correctly. If I hit the "+ Add New" to add a new row, the
Order Form price sheet best practices
I am creating a project/order tracker for a Solar/HVAC installation company. Materials costs have been changing multiple times per year, So I need a layman to update the price 6-7 times per year. My question is, what is the best way to accomplish this?
NodeJS Functions: Add multiple files
As the title states, how do you upload large libraries all in one go to NodeJS functions?
What is syntax to get data from an Integration with CRM?
Please see videos which show two related questions. https://workdrive.zohoexternal.com/external/472ac1aa2c361ced8bc678d40db810f004ba18a3da7992311c25ec73bee1ac5e https://workdrive.zohoexternal.com/external/b1f8b571f82fe8b4d79cbc8bea7214910cf5a110c4c2
Zoho Creator filtered by prameter passed
Hello, Is there a way to pass a parameter for filtering a report (no a page) in Zoho Creator ?
Next Page