On Success scripts not working for imported data
I have an application that has worked for years executing on success scripts for imported data. Everything worked fine Monday and now the scripts do not run when I import data. Does anyone know why this is or have a work around? Many thanks, Dave
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
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
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
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
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
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.
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
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
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
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
Filter on custom view - cvid - for current owner filters in CRM
Here's my query for getRecords. When I specify a cvid that corresponds to a CRM view filtered on My Records. I do not get a correctly filtered list. When I use other, filtered views, I'm seeing the correct subset query_map = Map();
Payment workflow for Apps that will be sold in the market place
Is there any documentation about how pushing an app to the market place affects payment workflows?
allow multiple client users per zoho app
I have an app created on zoho creator. I am now trying to market it to multiple customers. However, I can't create the code for this application to be accessed by several different clients, and for each of these clients to have a separate database.
Undoing user update of a field
I have two bits of code that are used for different subforms on the same form. The idea behind the code is to prevent the user from changing a field on a locked row (invoiced). The first code snippet works fine, the second gives an error. Does anyone
Form workflows not running with new import feature
Hello, today the Import feature from reports has a new look and feel. Unfortunately it seems to break functionality with form workflows. Form workflows that are triggered on input of a field are not running when importing data that contains value for
OpenUrl in new window with perma-link
I have a report with several buttons: Each button opens av new report with OpenUrl and perma-link with the New Window parameter. When I push the forst button "Leveranser", it opens the new window in a new tab. If I go back to the tab with the above report
Coding help involving lookupfields
Hi I am wondering if the below is possible. I have a form called "Book a Trial". On this form the customer can choose a trial class to book using a lookup field to another form called "Add a Trial Class Option" which is where we keep a record of all of
On Load workflow for a pop up box
Hi, I have a declining button on my bookings management system that should have a pop up box asking for the reason why that booking is being declined. I need firstly to make that box work (it was before then I changed something and it stopped) and secondly
How to modify data from developer console
Hi, I've just started using the Developer Console for publishing apps to my customers. for the previous projects i exported and imported the DS file to the customer account. It's still not clear to me how to use the developer console correctly. 1 - Can
Delete Portal User
Hi, The portal add on for 1000 users is A$387.2 per month. Are these customers or organisation users? im assuming customers …. The follow on question Is it possible for us to delete or inactivate customers ? Thanks Richars
For each into a message of an email
Hi! I'm trying to create a table that contain variable rows. To create those rows I'm trying to put an "for each" into the body of the email using <% and %>. Does anyone knows if that is possible? And if it is, how i can do it?
Next Page