Is it safe to give out your client id and client secret?
I created a self client api via the API console for my sandbox account. Took me a while to work everything out and then I managed to generate tokens and refresh tokens for my developers to use. I had to step away from my computer for half a day this
Creating Two Column WebForm with Sliders
Hello Creator Community- Thank you in advance for your assistance. I'm trying to create a pretty simple web form that: - Contains 1 sliders - Has 1 calculations field - Has 3 text entry fields - Can be formatted into two columns (So I don't have a 1 page
Count characters in multi line text / Creator
Good afternoon. I want to count the character/letters in a multi line text box to avoid having more than 140 characters into this box. Is there a way to show how many characters are in a text box? I use "on validate" to tell users to stay below 140, but it's never clear how many letters have be deleted to match the maximum. I'd like to display the total of characters used in a separate (formular) box. Thank you for suggestions! Oliver
Widget development settings
This is probably a silly question. But is there any way to connect a widget to an app during development so that we don't need to keep packing it and seeing if it works? The documentation for widget development doesn't seem to be very clear on just how
Same link goes to different Creator databases
I have several Creator databases. All act the same. I MUST go to my dashboard https://creator.zoho.com/userhome/jimdwest/dashboard to get the working link for the database. The IDENTICAL link that I have on my desktop takes me to a different place in
Bug found in zoho api for widget pageSize=200 multiple pages
Hi I think i found a bug in zoho api. when I fetch more than 1 page with pageSize==200 than page1 and page2 will have a duplicate record and an omitted record if pageSize<200 it will be ok. here is an example code ZOHO.CREATOR.init() .then(function(data)
Developer Users don't have access to the Sandbox
I recently found that although my clients are subscribed to an edition of Creator that includes the Sandbox, only the Super-Admin can create/access the sandbox, whereas the Developer User cannot. The Sandbox is a feature specifically for assisting app developers, and my clients are hiring me to do the development and are not doing it themselves, so this limitation seems to defeat the purpose of the sandbox. Because of this limitation, I have two options when working on an existing app: Log in as
Upcoming Updates - November 2021
Hi all, Greetings from the Zoho Creator team! There are a few technical enhancements being introduced in Creator this month—improvements that will take the overall performance of your applications to the next level. This update will elaborate on: the
Suggestion: Modernize UI Themes
Dear Zoho, I have been considering Zoho Creator for our business and I wished the UI was more modern and the themes allowed the ability to at least specify the colors. Other low code apps such as Airtable and Retool look fresh and modern. Canvas for CRM
Split list by new line
Hello, How would I be bale to put text into a list and splitting it by a new line? This is what I currently have but it is not working: scan = input.OCR; scanList = scan.toList("/n");
Populate subform from a Multi Select Field
Hi All Hopefully someone can oush me in the right direction. I have the following modules: Accounts Products at client ( Ours and compititions ) Contracts The contracts modules deals with the ocntracts at the cleint, their can be more than one product
Funnel Chart - Custom order
Hi, Is it possible to define a funnel chart order on zoho creator page? for example, i want to use the funnel for leads conversion. the funnel should represent the lead statuses. I would like to have the "Won" status on the funnel bottom. Thanks
Dynamic Filter for Lookup field
Hi all, I have a dynamic Lookup field. Each record in the "Sites" form has an "AMUser", and the current user sees a filtered list based on this. The lookup is configured like this: must have Site1 ( displayname = "Site" type = picklist values = Sites[AMUser == zoho.loginuser].ID displayformat = [ Site_name ] sortorder = ascending searchable = true width = 206px ) However, I'd like to nest this in an If statement so
Save to Google Drive and return shared URL
Hello, I don't know much about the Google API theme, as much as I see it I don't know how to implement it, what I want to do is basically in a zoho creator form to save in an attachment field a file, when saving must enter that file to a specific folder
call back URL for my zoho creator application?
I am a non programmer, trying to build a simple app with zoho creator, i want to do a get api call to google, and record the response in one of my form fields or as variable. i don't know what is my callbackurl where i can ask google to send response, need help. thank you
Widget not loading in Permaview
I created a gantt using node.js widget. it works great. I want it full screen without the Creator navigation sidebad. the only way I could find is to publish and open as permaLink. but, the widget doesn't load when used in permalink. using an external
Summary Page (Record Template or ZOHO creator page) in ZOHO Creator
Hi Team, Good Day! Requirement: Want to create a summary page for a student management app in creator. If the student is passed for a particular exam, the marks / grade needs to be in green color or else it needs to be in red color. I thought that for
Open Report Filtered?
Is there any way to open a report with a user filter applied. Or to just open it on a select subset of data in the same way that a view can be opened on a select subset of data? I have a report with data for employees. Almost always, the user opening the report wants to see only one employee. If I give them a mean of selecting the employee at report open time, is there a way to open the report so it's showing the data for just that employee?
How do I make subform row items appear only once in an HTML table in zoho creator snippet pages?
I have attached a screenshot. Category fields are fetched from a subform rows and rows can contain similar categories. I want to show category only once in this table with its count in head count. For example Engineer - 2 and not as it is currently being
How to make a product page style with variant?
I am trying to figure out how to create a product page with variant? I was thinking creating a product and its subform will be its variant. The problem is I do not know how to display it in a dropdown and change the image upon selecting the dropdown?
Opening a specific record template as pdf on button click via openUrl
If I use a function to email a record template as a pdf I can choose a specific record template ("testRNtemplate") from several I have created using the syntax: sendmail [ from :zoho.adminuserid to :zoho.adminuserid subject :"pdf is attached" message :"pdf is attached" Attachments :template:testRNtemplate as pdf ] Now if I want to download the pdf on button click this sort of function seems to work but I cannot figure out how to specify a particular template. It seems to always download the default
Issues with updating a new Zoho CRM Record
Hello, I have a Zoho Creator form that leads fill out. The information they input is sent to Zoho CRM in the form of a lead. This was working fine as just creating a CRM record, but I wanted to update the newly created CRM record with more information.
message on click of button
Hi, i added insert task on 'Quick view' below 'Action' of report just below 'Delete' button, so i am trying to add a message on click of button that, "This item is now added into Pending Request" like this .... So, how can i achieve this ; because
Check if url is broken
Hello, I would like to know if there is a way to check if a url is broken when submitting a form, in this case I want to check a permalink of a file hosted on Workdrive. Is it possible and how? Thank you.
sendMail result
Hi, From the deluge documentation i understand there is no "successful" or "unsuccessful" response for the send mail function. Is there any way to get this feedback? Thanks
Subform - Add Rows - First Row Only - Add Information
Hi, I am adding default information to each subrow in a subform, using the delug script below. I'm needing to only add the Paid Invoice information to the first subrow I create instead of each row. I'm not sure sure how to best do that, given my current
User field - Multiple choice and username
Hi, Currently, we cannot select more than one user when using the default User field in ZC. This prevent using the User field for assigning "a task/record" to multiple users. Also, we are still not able to edit the Usernames of the users stored in the
Auto populate subform
Instead of having to retype the information again, I am looking for the proper script to automatically add the userID from the main form, into the subform, when I add a new row.
Java or NodeJS for more processing?
Hi all. after making an MRP (Material resource planning - what parts to order to meet client needs) of our product of 135 parts, the next step is MPS (master production schedule - schedule of production with all different steps). I quickly get to the
Filtering Pivot Charts via a URL parameter [my attempts, a discussion]
I know many have tried to filter pivot tables and charts via a URL parameter before and have failed, but I thought: I'm REALLY going to dig into this, get it working, then share my results with the Zoho Creator Forum community. No such luck. HOWEVER,
Help create Zoho application
Can someone help create the following? DESIGN Client – Name, Address, Status (active or inactive) Supplier – Name, Address, Status (active or inactive) Contact -First Name, Last Name, Status (active or inactive) Client (lookup field to Client), Mobile Phone Supplier (lookup field to Supplier) Mobile Phone Model, Mobile Phone Contract start date, Mobile Phone Contract length in months Populate random data and create 5 Clients (2 inactive), 5 Suppliers (2 inactive) and 20 contacts (5 inactive) Ensure
Transfer ownership (and billing) of Zoho Creator app to another user?
Gents, I created a Zoho Creator app under my user, but now I need to transfer it to another user (for billing and management purposes). How can I do that? []s Manoel
Concatenate Multiselect & Checkbox fields in a formula field w/ a conditional comma.
I want to combine the selected choices of a multi-select (dropdown) field and a checkbox field with a comma between the two within a formula field. However, one of these fields might sometimes be empty, so Multiselect +", " +Checkbox would leave me w/
Changing the name of Record Template sent as attachment in SendMail
Im looking to send a Record Template of a Report as a PDF....with a customized file name...as an attachment on a sendmail. any help? Charles
Upload a Document to Zoho Docs from File Upload in Creator
Hi everyone, Is there any way someone can help - I would like it so that when someone uploads a doc in a creator form - it is sent to Zoho Docs. I've tried asking the Zoho team for help but they just give me a link to the Zoho Docs API User Guide and I can't follow how that is supposed to work. Any help would be appreciated. A step by step guide would be loved!
How can I insert a subform row, set the drop down value, and add to the drop down field a list of options?
Scenario: A user enters data into a subform and submits the form. Later, the user would like to return to the form to make a change. The change is to select a different option from the drop down field. Problem: When the user goes to perform this change,
How to filter an Integration Lookup?
I have a Dropdown with values A - Z which match a field in a CRM integration module (Deals). I want to filter the Deals based on the selected value of the Dropdown. How can this be done?
Connecting to an external service through REST API
Is it possible to connect to any external application that provides a REST API or only to specific services? Where can I find more information about this? I'm trying to make my Zoho Creator app connect to my company's electronic invoicing system (https://developers.datil.co/) so each sale automatically generates an invoice instead of having to do it manually.
Access external API's in appliations
Hi I'm just wondering what the best way is (or if it's even possible) to access external API's in creator? I.e. a payment platform, or other. Has anyone had experience with this in the deluge script, or in the pages function? Thanks
Link records in one form to another via number range
I work in a high volume ecommerce sales business where we process items that are grouped together in boxes. Each item has a unique ID number, and the box that they are in also has a number. Each item is entered into our database including the item's ID
Next Page