How to download a file from deluge?
I have a function in deluge that downloads a packing slip from Zoho Inventory where the return value is a pdf file. parameterMap = Map(); parameterMap.put("package_ids",/*id*/); PackingSlip = invokeurl [ url :"https://inventory.zoho.com/api/v1/packages/print?organization_id=473837261"
In the Map view of reports, can the color of the pins be adjusted based on a variable/dropdown?
In the Map view of reports, can the color of the pins be adjusted based on a variable/dropdown? As an example, if a record has a status of x the pin would be blue or y could equal yellow..etc... or is this something that needs to be tied to Zoho An
How to access inventory API from javascript?
I'm trying to create a button on a page in creator which when pressed does an API call to packages in Zoho inventory. Here's my code in deluge. print = invokeurl [ url :"https://inventory.zoho.com/api/v1/packages/print?organization_id=849303927" type
Automatically create email accounts from Zoho Creator
We have an esablished Zoho Creator site and create email accounts for our clients to sign in with. Is there any way of automating the process to automatically create a new email account when details are added to a form in Creator ? example : We have a
Automatically number subform lines, starting from 1 evertyime one is made
So i am currently working on a subform in an app. Like shown below the numbers in #Run should automatically populate. So when i add my first row the number should be 1. Adding a new row would mean that #Run would be 2. This should continue to whatever
Creator JS SDK SubForm items manipulation (ADD/GET/DELETE/UPDATE)
I want to ask for help from anyone who's worked with JS SDK on Creator widgets, as I am not clear and I can't get it work the following manipulation of SubForm items. So in my widget I want to be able to Get,Update,Delete,Add Subform items, so far I am
Simplest way to convert XML to a map?
I've reviewed the help info and some great posts on the forum here by Stephen Rhyne (srhyne). At the moment I'm using XPath to generate a list of xml nodes, iterating through that to fetch the field name/value pairs and adding them to a map (one map for each record in the data). I then convert the row map to a string and add it to a list. Here's the function: list xml.getRecordListFromXML(string xml_data, string ele_name) { result = List(); // get list of record nodes rec_list = input.xml_data.toXML().executeXPath("//"
Zoho Creator - Deluge Script - Non Distinct Count in Lists/Collections
I have an issue I am hoping to find a solution or reason to or for. To make it very simple, or to attempt to, I will use the metaphor of a Book Recommendation App. It includes two main forms: ReadersForm (perspective readers) and BooksForm (book collection).
Calculated Field on CRM Entity
function setupGridRefresh() {
var targetgrid = document.getElementById("NAME OF SUBGRID");
// If already loaded
if (targetgrid.readyState == 'complete') {
targetgrid.attachEvent("onrefresh", subGridOnload);
}
else {
targetgrid.onreadystatechange
Automatic Refresh on Page?
Hi everyone, We use a page as a dashboard which shows data for the laboratory and tasks pending etc. Is there a way to set the page to automatically refresh on a X time? Many thanks TOG
Deluge Script Version control system
G'day, can you recommend an online source code control system (over the web) for the retention of older copies of Deluge script???? Liam.
How to auto populate fields based on CRM Integration lookup
Hello, I have scoured the forms and tried multiple solutions but I can't seem to figure this very simple task. I am a beginner and am just learning Deluge so any help would be much appreciated. I have a form (Add_Warehouse) with an Integration field set to the Deals module in my Zoho CRM account. I would like to auto populate the following fields, from the Deals module, based on the users response to the field 'Import Details from CRM field' (Creator field link name: CRM_import). The module is
searchable field
I need to create a searchable field in my project. Here when I insert data in this field it'll provide options to display the data in separate tab. Here I've attached the file How can I create like this I was so confused. Plz help me Thanks in advan
How can I get quantity number for each item from collection ?
How can I get quantity from sub form in another form when I fetch data get it in collection
Subform JS SDK - Creator
Q1 I have a need to use an array data type in my widget, and most suitable seems to use a Subform. As multi select requires predefined fields. What other field could I consider when I need an array in my record? Also I have trouble working with SubForm
Nested IF function
Is it possible to do a nested if function in ZOHO creator? I want to be able to perform an action based on two criteria. Does ZOHO have an if and/ if or function?
Grammarly no longer works.
Grammarly chrome extension or firefox extension is not working and I am sure that there were changes made to the text box. Both Windows and Mac same issue. The third point in this support article is the issue https://support.grammarly.com/hc/en-us/articles/115000090392-I-do-not-see-the-G-icon-on-a-certain-web-page-or-in-a-certain-text-field-but-see-it-on-other-web-pages- And it worked before, major issue. Any views?
Zoho Creator and Zoho Doc Scanner App - Integration
I think it would be amazing, if when I added an image field in my Zoho Creator App, that I could choose from Zoho Doc Scanner. https://take.ms/qLVnO Then, instead of taking pictures, we can use the app and scan and attach as a pdf.
IF statement on a field
I have to give a value to a field (let say FIELD1) according the following criteria where FIELDXs are type float if (FIELD2 != 0) { FIELD1 = FIELD2; } else if (FIELD3 != 0) { FIELD1 = FIELD3; } else if (FIELD4 != 0) { FiELD1 = FIELD4; } else { FIELD1 = FIELD5; } where I should put it. I tried on Form edit/validate ! form edit/Load but seems not working. the same on the Field /input ! field/validate find in the attachment the right if statement applied. Thx
Publish Zoho Creator Application to Clients
I made a zoho creator application in zoho creator itself and I want to now change the ownership of the application. However when I search for how to do so I find this answer: https://help.zoho.com/portal/en/community/topic/changing-application-owner.
With forms for Intagrated Zoho CRM Account, how add functionalities?
Hi, We would like to change the text field for the parent account to search and select an existing account. At some point, when we use the Accounts Report to edit, we would also like to be able to navigate to parent child accounts. Maybe add kinda cards
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
Capture GPS location field
When using a mobile phone to complete the form, I need to capture the GPS location. When this field going to be available? Same question for taking pictures with mobile phone and capturing that picture automatically. Thanks
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
Next Page