Dealing with Custom Fields in Deluge
Greetings I'm trying to add expenses from my creator app to zoho books, in zoho books i have some custom fields for the expenses that i'd like to set when creating the entry. but i'm unable to get it to work. i've checked the docs https://www.zoho.com/books/api/v3/expenses/#create-an-expense
Total on hand issues
I have a subform where I add quantity distributed or quantity returned in inventory. The total on hand is part of the subform and I have it populated with the queantity on hand. The workflow formula is if(SubForm.Quantity_to_Distribute != null) { x
How can we share a Creator public form using QR code?
I would like to ask you if there is any way in creator to share a public form as QR code (a public form not the entire application). The concept is, in a meeting room if the clients scan the QR code then to open the Creator public form to them to fill
Missing parameters when trying to fetch logs from zoho projects
Greetings in a function, i'm trying to fetch log records from zoho projects, but i keep getting "Input Parameter Missing" error error code is 6831..it seems i'm missing some sort of parameter but i have no idea what it is. what am i required to give when
Can't Add Developpers (Users) to Zoho Creator App
Hello, I've been using creator individually for a little while now, Recently, I wanted to add one of my co-workers as a developer on our app so that they could also help with troubleshooting, development and scripting. However, whenever I try to add
Help with custom function
Hi all, I'm not a coder and need some help to create a script. I'm using ZOHO FLOW to integrate two apps and need to build a custom function to convert values from a previous step (a webhook) to the next step. The previous step is displaying field NAMEs
Generate Acronym
Hey all, question - anyone have code to generate an acronym? For example, Form1 has input.Agency_Name and input.Acronym. I want to add an "On User Input" workflow to generate an acronym from the input.Agency_Name field. Input: input.Agency_Name = "The
Add DateTime and location upon successful form submission
I am doing a check-in and check-out form. How can I automatically add the current datetime to the record, upon submission of a form? And is it possible to also add the location of the person submitting the form?
Report Customization
Hello, I am a complete newby with Zoho Creator but have managed to start a relational database. Now I have a problem with the 'Report Customisation'. The first view is as it should be with 'Quick View' and 'Detail View' available. But in some Reports
Escaping a line break
I'm currently struggling to escape a line break. I have a script that's outputting a string that I am writing to a file. This file is used by another program and it needs to see the line break to display what I want it to display. The issue is I can't
Installing/Using Python Package in Zoho Creator
Hi, I have a Python function in my ZC application that depends on a specific Python package. If I was running this on my own server, I would just install the package using pip (e.g. pip3 install stripe). Is there a way to install the package in my ZC
Multi line field on ZML remove spaces and new lines
Hi, Is there a way to show the multiline original text on ZML? Here is an example of the fields input: This is the result on the page when using the 'text' tag
Cant add subform columns to detail report view
Hi I keep trying to add more than one of my subforms fields to view in a retail report This is what is looks like when i go into it so then i add another row, and it looks ok but if i close this and go back to here, then its back to being like this ive
How do I use getUrl to get specific data off a web page?
Hello, I've figured out how to place the string data from getUrl into a variable but once I save the URL to a variable, how do I actually extract JUST the exact data field I want from the webpage? For example, if I use either one of the two links below, how would I get the last trade price from the webpage? http://www.google.com/finance?q=aapl OR http://finance.yahoo.com/q?s=goog I know the price is somewhere in the resulting string from getUrl, but I don't know how to zero in on just the price data.
Need help autofilling form when using Kanban Report
Form 1: Add_Job Form 2: Add_Before_and_After Kanban Report: Mobile_Dispatch 1.5 minute Video: https://www.loom.com/share/e20422765ce84be29bf83d307048c6af The Kanban Report "Mobile_Dispatch" is used to manage Form 1 submissions. Within the Kanban Report
Exit Sub
Hi Everyone, I have some script that evaluates multiple conditions, using some nested if statements. If any of the conditions evaluates to true, there is no reason to continue the running through the other conditions. Is there an Exit Sub command in Deluge? Thanks, Leo
Apply Criteria To Creator Pivot Charts
Can you please put on your roadmap the ability to pass criteria to Creator Pivot Charts? This would be a huge enhancement for the system. Please advise. Thanks.
Mobile App & Style based URL's
Hello. I am trying to remove flagged icons in a report inserted via an html widget on a page. I haven't found any option to do it with the style based URL's. In the PC application they are hidden but I can't get it on the mobile. Does anyone know how
How to upload an image from Zoho Creator to Zoho Desk?
Im trying to wrap my head around how I can upload an image from creator to desk. Im currently creating tickets with no problem through manual deluge functions on creator. However, there is no clear documentation on how to upload an image through the API.
Add upload file button on custom actions
Is it possible to make a button as upload file in custom actions ?
Referencing product fields in sales order fields
In the Zoho Creator app and have created an app in sales management. Wanting to reference a custom field I've added under Products in a Sales Order. The field is Hard_Cost and want to multiply by the quantity under the Sales Order, but it can't be found.
InvokeURL variables from another form
Hi, I'm hoping the answer to this is easy and I'm just being dumb... just can't get the syntax right I have an InvokeURL task that works, but instead of making the same task for each company lookup, I want to substitute values from another Form. ie. I
How to filter Values in a Dropdown List
I have a form to collect equipment category name. eg. Dryer, Heater, Cooler etc.... Form Name - 'Add Equipment Category" Field Link Name - "Equipment_Category" Then, I have a form where equipment names are being collected and each of them are being mapped
How can I compare data from two reports into a third report?
I'm using zoho creator to make a simple interface for me to manage a client database and the services I provide. I have two forms: Student form - has a numeric field where I record the number of minutes that student is allotted to receive
API calls and security
Hi All, This is really just a call for general advice about security I make API calls to grab info from an external resource into Creator for say 6 companies Each of these API calls requires a username, password and token, and they are all different.
Zoho Creator Upcoming Updates — October 2022
Hi all, Greetings from the Zoho Creator team! We've got some interesting updates for you today—and rest assured, there’s more to come! In this post, we'll be going over the following features and improvements for this month. In-app notifications Backend
Unable to select save "Print" of PDF" Option in Page
Hello, Today I attempted to enable the print or pdf option on a page in creator. When I hit the Gear icon in page edit mode, creator shows me the options: I am able to select the option to print and enable pdf. When I exit, nothing changes. I am still
List all portal users
Hello ! Is it any possibilitie to list all portal user by application in Deluge task ? Thanks Aurélien
Sorting the records using a date Field
Hello all, I have an income expense application and I am trying to show the last 15 days spending in my page. While trying to fetch the records from my expense report I am trying to sort the records based on the date field. I am trying to set the range
FORM in edit mode not visible?!
Any idea what can cause the FORM for which I have a VIEW not to be visible in the edit mode but can be seen in the Data Entry mode? Thank you.
Zoho creator + zoho books integration
So been given this recent task, create a form for new customers and integrate it with zoho books. I know almost nothing about Deluge or zoho platform. anyway this is what i have achieved so far: 1-Create the form ✅ 2-On form submission->create new contact
C5 Dashboard with embeded report has strange page break
I'm just using a creator pivot report from within the same application but I can't get it to show full length on the left hand side. Instead theres a grey page break in the panel itself.. it's not the end of the panel, just seems to be the end of the
Zoho Inventory Integration - Zoho Creator app
HI , We have started on a custom app from Zoho Creator and made some customizations into it and now want to integrate it with our Zoho Inventory . Please let me know if this is posssible?
Dashboard to be sent as email attachment
Hi, I can send view in PDF format via email to users using the following code: sendmail [ from :zoho.adminuserid to :"user@email.com" subject :"Report Summary" message :"Report Summary" Attachments :view:Report_Suammary as PDF ] but is it possible
Publish/Deploy app (ROI calculator) to any visitor
I built an ROI calculator as a marketing tool for my SaaS company. It is a multi-form based app that asks users to input certain values, then the app will calculate how much new revenue my company can help drive. I want to publish/embed this app within
HTTP 429 - Too many requests
I'm trying to add multiple rows using v2 Creator API method https://www.zoho.com/creator/help/api/v2/add-records.html Unfortunately after 100 requests (done in aprox. 20 seconds) I'm receiving response with HTTP code 429 Too many requests (which could
Empty a field when clicking submit in a stateless form.
I am trying to null a field on the submission of a stateless form with an alert but it's not working. if(input.Time_Slot == null) { alert "Date slot cannot be empty"; input.Type = null; input.num = null; } Its working on user input of a field. if(input.Type
Add Record with info from separate form
Hello. I've looked through some of the documentation and other posts but need some help. Please see the info below and I've also created a 1 minute video of the process. Thanks for your help! Video: https://www.loom.com/share/665825740aad46d5993172e6ec6c0c49
How To Prevent User from Adding or Deleting a Row in a Subform?
Is there any way to prevent a user from adding or deleting rows in a subform? I preload the subform tables with just the rows I want the user to update and I don't want them to add or delete any of the rows. The number of rows in the subform will depend on data in the parent, so I cannot use the feature that limits the number of rows (and that feature doesn't help me in preventing the user from deleting rows). Jon
I can't push the uploaded image from the app zoho creator to crm
How can i push the uploaded image to crm? I already created the code for it but its not working. newEmployeeInfo = Map(); newEmployeeInfo.put("Name",input.Name); newEmployeeInfo.put("License_or_ID",input.ID1); response = zoho.crm.createRecord("Employees",newEmployeeInfo);
Next Page