Workaround to follow both physical stock and project-related expenses.
Hi All, I built an Asset Management App in Creator and now want to exclusively use this app to keep track of the physical stock as well as the related expenses on associated projects. I do all that through deluge scripts using the api's. Each asset is
Stumped by OpenUrl when trying to open a filtered report with the click of a button.
I have two Forms, Accounts (parent) and Jobsheets (child), with their respective reports. They are related in 1:N relationship. I tried adding a button in the Accounts report, as a column labeled "View Jobsheets". The intent is for the on-click action
Spacing between fields
how do you control spaces between fields? I have a lot of fields to put on a form and want to put the fields more closely together. It seems like the spacing between the fields are automatically set and I am not sure where I can change this if possible.
Free version
This has been discussed elsewhere but I can't find a specific answer relating specifically for Creator. I have signed up for the free version (I think), at least I did not enter any payment details. As I have invested quite a lot of time and effort into developing (quite a good) app, I want to know exactly what will happen when I hit day 15? Will the app behave any differently or will I be forced to upgrade my account to keep using the app? Thanks
Subform properties
Hi, I need to understand the behavior behind a subform. If I create a form called "subform" with some fields and workflows related to each field (e.g., enabling fields, setting values, etc.), why can't I inherit that behavior when I use my subform within
Change the File Name before Downloading the file ?
I need to change the filename before downloading using deluge. Is this possible?
Please share the steps to done it.
Can I get page variables when I execute a button in a report which in that Page?
Can I get page variables when I execute a button in a report which in that Page?
Find next available integer in sorted list
I have a custom function that finds a next available integer and creates a part number. The function currently takes a sorted list and loops through each item to find the missing number in sequence. On some part numbers I run into an issue where statement
how to calculate difference between time?
hi there is Added_Time and Modified_Time how can i calculate how much time between Modified_Time and Added_Time Modified_Time - Added_Time = time_X ? in days, hours, minutes, seconds
How to get the request object on zoho Creator API.
Hello, I'm trying to create a Deluge function that runs on an incoming webhook. I made a custom API on Zoho Creator and connected it with the custom function, but I can't get the request object in the function. I found an article that shows it can be
2MFA in ZOHO Creator Portal User
How can I implement 2FA (Two-Factor Authentication) for Zoho Creator portal users?
Help me! Error {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"}
Hi, Good mornig , I have a problem with add data to creator API and I don't understand for why. The same process be have correctly excute the last week. {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"} I need your help. Thank You
How to update a Creator form record checkbox value to be true (checked) or false (unchecked)
I can't find the answer to this... I have page which is successful pulling record from a Form, and now I am making a custom function which will update a checkbox when it loads. My function is: dataMap = Map(); dataMap.put("Company_branding", true); otherParams
Prepopulate a field name based upon a zipcode table
I have a created 2 forms, an application that people will enter their information. Once they enter the field zip code I want to pre populate a field in form 1 with the city information. Form 1 is the application Form 2 is the zipcode with city and county fields Pls help I am new with building scripts
Kaizen #136 - Zoho CRM Widgets using ReactJS
Hey there! Welcome back to yet another insightful post in our Kaizen series! In this post, let's explore how to use ReactJS for Zoho CRM widgets. We will utilize the sample widget from one of our previous posts - Geocoding Leads' Addresses in ZOHO CRM
Creator Form - Form Submission Confirmation Popup not working
I have a form in Creator, and in the Form Properties, I have selected the checkbox for "Open form submission confirmation popup when Enter key is pressed". However it doesn't seem to work. When editing my form, if I enter a new value and press enter,
Change name of PDF download
Hi! Is there a way to change the file name of the PDF to the input of a field before downloading it? Ex: When I download the PDF of a record, I want the file name to be the input of " Date_of_Event". So it will download as 1/1/2017.pdf
Checking Expiry Date
Hi, Im new to Zoho creator, i need to create a function or query for my report to show records expiring in the (x) days. I have a expiry_date field and i try using Expiry_Date.toLong() / (1000 * 3600 * 24)) <= 30 Im getting an error " Invalid Search Criteria" Thanks in advance
Resize Signature field dynamically
On the tablet, it is perfect. But on smaller mobile devices and PCs, both web and application, it is too small for people to sign. Is there any plan to make the signature field size dynamically in the future update?
List report with totals for Group and Subgroups
I have a List Report with Groupings of Division, Department I total some numeric column Now I get Totals for Department and totals for the whole report (the whole company for all records included in theForm. How can I show a row of totals at the end of each Division?
Regarding Multiple user dashboard
"I have created a dashboard that includes information on the number of students who have joined and the number of colleges, among other details. There are two portal users, Tharun and Abi, who are adding records to the form. I would like to track which
SUM a field with related record and update in another form
Hi, I have one form called Record form for portal user and admin user to add record accordingly. In this Record form, there is one Amount field. There is another Profile form where each portal user will be prompted to create their Profile upon first login.
How to change chart color
Hi In Creator, when you add a graphic, you can choose a color template, but you can't choose the exact color for each element of the graphic. Is there a way to do this? Thank you :)
Calendar view - All-day with date-time fields
Hi friends, I have a calendar view that is showing records based on e.g. start-time and end-time, both of datatype date-time. I couldn't figure out of to show "all day records" in the all-day section of the weekly and daily views. Trying to set start-time/end-time to e.g. 15-10-2012 00:00:00 was not helpful. What else should I try please? Kind regards, Idan
Unable to create new Zoho Connections in Power BI
I am no longer able to add new connections into Power BI for automated refreshes. Existing connections appear unaffected as they are still functioning.
Does Zoho have a feature to create virtual membership cards for clients? Or any ideas on how to achieve this?
We are establishing agreements with companies to obtain discounts for our clients. We want the clients who wish to participate in these agreements to have a type of membership or affiliation card that they can present at these companies to receive the
Access Uploaded Files for Printing via PrintNode?
I'm trying to set up an automation to print uploaded PDF files via PrintNode upon submission. The problem I'm running into is that the URL for the files (shown redacted below) cannot be accessed directly with the call to PrintNode, at least when using
Zoho Creator - Multi Select Options as a New form
I have a form in Zoho Creator with a multi-select field named Software. For example: Task: Task A Software: Software 1, Software 2, Software 3 I need to create a new form called TaskSoftware that will store each Software entry as a separate record along
[Free Webinar] Creator Tech Connect series - Mobile SDK in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
SubForm Custom Sort - Deluge Workflows
I have been experimenting with the Custom Order function of Subforms, it works beautifully within the subform itself and retains the sorting order. However, I need to be able to iterate through the records in Deluge using the sort order (The usage case
zc_LoadIn=dialog popup window size
Hi Zoho, I'm using zc_LoadIn=dialog in my href link string to open a window in popup. How can I determine the popup windows size? it comes up really small and inconvenient. Ravid
Workflows be triggered on Import?
Hi, Please let us know when will this option be available in Zoho creator. Thanks
Adding an element to the Creator Canvas will automatically adjust its dimensions.
I designed a report with fixed dimensions using Creator Canvas. However, whenever I add a new element, the system automatically adjusts the dimensions, even if the new element fits perfectly within the set boundaries. This is quite frustrating. Has anyone
Multi Select list as new report
I have a form in Zoho Creator with a multi-select field named Software. For example: Task: Task A Software: Software 1, Software 2, Software 3 I need to create a new form called TaskSoftware that will store each Software entry as a separate record along
Make signature field larger Zoho creator
Dears, I'd like to make the signature fied larger on PC web. How do I achieve this? Any help would be appreciated!
Configure postUrl() to follow redirects
I am trying to request JSON data from a Google Apps Script (GAS) I've developed. As the GAS ContentService does not serve content from the script URL i need to configure the postUrl() in Zoho Creator to follow redirects. Is this possible?
Checkbox not displaying correctly in subform
Greetings: I have shared my app (wv) with support. I am having problems with a checkbox field not displaying correctly in a subform. The main form is called volunteers and the subform is called volunteers_subform. The field in question is called roles. When you access the subform by itself the checkbox lookup displays as checkboxes. But when you view it in the main volunteers form, it displays as a multi-select dropdown instead. I have attached jpegs showing the difference. Any thoughts?
Labels in Custom Layout Report Quick View + Report bg colour
Hello, Actually two questions, slightly related. 1. I make pleasantly use of the custom layout feature for Report Quick Views. It's easy to add fields, however can't find a way to add labels to the field. Either the form field label or a custom label. I would be happy even with a custom text element, but even that does not seem to be there. See screenshot attached. Eg field Date of Birth has no label option. 2. And can we give a custom colour background to reports? I tried this in a page, you can
Dividing a Creator Form between tabs
Hi all, In a youtube video titled "Deluge 101 - Part 1, a Zoho Developer Community Learning initiative" (https://www.youtube.com/watch?v=7PW3SM04Fiw&t=360s), from 2:50, there is a creator app where there is one Form that appears in a page, but not as
Unable to Rollup Calculations
I have data related to several forms in my system. "Raw Material" is Form 1 and is the name of the item I want to roll up totals for with related forms. I have a lookup field in Form 2 "Production" that relates the record to "Raw Material". I will have
Next Page