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.
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
Action button in report to create new record but NOT on-click; also, full screen success message??
I have a report action button that sends data from one form to another and creates a new record. It works, but I don't like that the new record is created On-Click of the report button. Is there a way to just open a form, populate it, but have the new
Zoho creator C6
When will creator c6 will be released ? Do we need support team help for that or we can migrate our own after it releases ??
Flowchart template
Whats the best template for creating a flowchart app where the user will be simply answering yes or no to questions that appear on the the current screen and the app will then follow the flowchart and select the screen depending on the yes or no answer. The user will enter data specific to them at the commencement of using the app and these keys words will be automatically included in the question. I do not have any coding experience.
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
Next Page