Get nested drop down
Hi, I have a requirement where i have 2 dropdowns. One is Area Second(which will have 3 options say option1, option2 and option3) and second one is Sub Area(which will have options like option 11, option 12, option 21, option 31, option 32, option 33). When i select e.g, option 1 from Area.. it should display sub area options from Sub Area dropdown only related to it i.e, option 11 and option 12. Similarly if i choose option 2/3 same action should occur. I referred to some forums. But still stuck
Picklist sometimes not pulling records during edit
Hi there We have an issue where on editing a record, where we've already defined a picklist item during the create record process, the set picklist choice does not show. Is there a way I can ensure that the picklist field we have set shows in the edit record information.
Importing subform data results with success but no data is being imported
The import process results with success (or at least without any error messages about any of the related subform data) when I select the "Do you want to import subform data" option on the data import screen and select the related subform columns on the data relation table. When you return to the report after the import process and look up for those imported data then there isn't anything in the subforms. What am I doing wrong here? I can't also find any related help pages on the help guides about
open page in popup window without navigation
hi is it possible to open a PAGE in a popup without the Creator Navigation? i want to display record details kind regards Lambert
Exporting Page to PDF page size issue
So I created a Page in Creator 5 that we are using as a report page. We export it as a PDF and then print it out on our printers, but the PDF that is created is slightly larger then 8.5 x 11. When we print at full scale, it crops about .5" off the top and bottom. We been printing with the Shrink Oversized Pages turned on. Is there some way to control the paper size that the export to PDF uses?
Populate a field with criteria from other fields
Not sure whether this is the right way of doing this but i'm trying to populate a field by looking at results from other existing fields and then taking a value from one of 6 variables. The Script I created is below but its throwing up an error on line 8 "Improper Statement Error might be due to missing ";" at end of line or incomplete expression. I cant see where i'm going wrong though: KidsKick = if(Height <110,"Micro",if(Height <120,"Light",if(Height <130,"Welter",if(Height <140,"Middle",If(Height
For Each Value In A List Not Working, Help Links Are Wrong
I've been searching for a way to add each selection in a multi lookup field to a list. I came across an older help article here: https://www.zoho.com/creator/help/script/for-each-value-in-list.html Knowing it was for the older Zoho Creator, I still thought I'd try it out as it's currently my only lead. However when I did, the error told me that this type of iteration was no longer supported, and gave me a link to learn more. However the link itself doesn't work. So I'm now back to square one
Sending an email with several record templates
Hello, For each of my clients, I create a project. each project contains 3 subforms. for each subform i have create record templet when i finish a project, i want to have a way to send an email which contains these 3 subforms record templet to the client. How can do it? please advise..
getPrefix on a mixed field [SOLVED by Adhavan S]
This is my first post, as I'm new to Creator. Please give me some ideas on how I can solve the following problem: I have a lookup field witch takes data from two fields: a Number and a Single line text, separated with " - " (example: 125 - The Customer One) On another form I'm running an on-load deluge script, where I want to get the number and use it. I have played using the get.Prefix of get.Suffix, as well as conversions to Decimal or Numeric, etc.., without success. suffix = customer.getsuffix("
Pivot table filter won't update
I have created a number of pivot tables based on a drop down box in my form. I am creating individual reports and filtering each one by the corresponding criteria. Like so: Report #1 - Leads (Drop down option = "Lead", Pivot table filter = "Lead"). The pivot table displays all open leads in the system. Report #2 - Prospects (Drop down option = "Prospect", Pivot table filter = "Prospect"). The pivot table displays all open prospects in the system. And so on... All of the pivot tables worked great
sending email reminder based on field date plus
Hi, Been using creator and the rest o9f the Zoho products for some years. Very happy. For our new year project we would like to send reminders to customers (email) based on a couple of fields. 1. Next contact date which we already have in there ( we would like to send it 30 days before) 2. That it is a current record. 3. The customer has not opted out. As always when i start these changes I am always over whelmed by choices so a point in the correct direction would really help. Thanks
Get info on users who accessed the form
Hi, I have created a Form using Creator App. I have created 3 users to be able to access the form after accepting the invite. I would like to know how can i know which user accesses the form last or which is user is currently editing. Thanks
Edit mobile field order
I love that Zoho creator has an app for users to be able to fill out forms on their mobile devices. What I can't seem to find (if indeed it exists) is a way to edit forms for mobile. For my regular online forms, I have fields set up in columns - with related columns reading left to right... But on mobile it only allows for one column, and thus the logical order is thrown out of whack. Please tell me there is a way to change the field order for mobile! I am in the design space and mobile view...
Adding custom button in forms
Hey team, I'm building a cab booking application for my company. The concept mockup idea of the application is attached below. While developing this application, I'm finding problem with 1) Using custom button inside the form 2) If custom button can be used with only pages, than how can we hide/Show those buttons depending on the current time. 3) I can able to fetch the email id using ("Zoho.loginuser"), but I'm not able to display their name. 4) How I can make the boarding point drop down to a pre-default
What's the delimiter (separator) character to use when importing multiple values from a single cell ?
I'm trying to find out the correct delimiter character to use when importing multiple values into fields on reports but I haven't found it yet. I couldn't find any help pages about it in the help documentation either. Could someone please help me out about this issue.
How to select columns to export
Hello, Right now when i go to export data it downloads only visible columns. But i want to download all columns. How to select them? I get select box only for first column. For Rest i get just drop down with sort options. Thanks
want to create a editable form
My requirement is i have a excel sheet on system When i upload this sheet i want a form to be created populated with the field data as in the excel sheet. Also i want some new fields in the form which i will be filling after these data gets populated. Once i fill these additional fields i want to save and download it as an excel sheet. Is it possible?
Copy Drop-Down Values
Working with some drop-down fields, I find it cumbersome to have to start from scratch with each one. I do like that we can open a dialogue to "import predefined" choices so that we can paste a list. But, when I want to get the same values into another drop-down, I have to start over again. There should be some way of accessing all of the current fields in the same pop-up dialogue so that we can copy all of the values from one drop-down field into another. Or, perhaps there should be a way of creating
Question about Zoho Inventory and Zoho Creator
Hello, We are having some problems with Zoho Creators. We have a costume app with some forms ready, and we have a Zoho Inventory with all the products and stores in there. So we were trying to find a way to implement both things together, if there is a way to do so. We mostly want to update things from the Inventory via our costume app.
SOAP Error - Error on Execution
Hey everybody, I try a SOAP-Post Request, but everytime I get this: Result: Error on Execution Error details: Execution Failed Error due to - 'Internal Exception' Line:(39) The script is working on Postman and SoapUI, but not on Zoho Creator. This is my sourcecode: requestBody = ""; requestBody = requestBody + "<soapenv:Envelope "; requestBody = requestBody + "xmlns:soapenv=\"https://schemas.xmlsoap.org/soap/envelope/\" "; requestBody = requestBody + "xmlns:rep=\"https://XXXXXX/soap.php/soap/report\">";
How can I enable the user to enter some data into a record whilst a workflow is triggered ?
My use-case scenario is as the following : I have a spare parts report where the spare part items are being listed. I'm adding an action to the report which creates a record on an order cart form where the user should be asked to enter the quantity of the selected part. The spare part form doesn't have the quantity field in it. This field is only present on the order cart form. I have created the related action workflow which transfers the part serial number and a predefined order quantity to the
Is there a list of keyboard short cuts?
I have looked for the list of keyboard short cuts that is alluded to in other forum threads but cannot find it. Is such a list available?
ToUpperCase Flow
Hy With Zoho Creator, I need a flow to automaticly convert string to upper case. Concretly, when I just finish to complete the field, I need to update the field automaticly in upper case. If someone has the solution and the code... Great thank you !!!
Establishing and visualising hierachical table relations
Dear all. I have a database with 4 hierarchical levels, and I would like to show in the first hierarchy table not only the records that are linked to it through a lookout field, but also records that are linked to the child table through another lookout field. Example. Table 1: Experiment Table 2: Treatment Table 3: Subject Each Experiment consists of multiple treatments, and each treatment of multiple subjects. Table 1 and 2 are related through a lookout field, and Table 2 and 3 are related through
Probleme d'affichage
Bonjour, J'ai mis des conditions d'affichage en fonction de si ma cellule est vide ça masque le fields. Mais malheureusement j'ai des bugs d'affichage malgrès le faite que je pense avoir juste dans ma configuration. Pouvez vous m'aider????
Material Ordering Form
I'm a bit new to Zoho Creator and I'm trying to create a form that allows a user to order materials -I'd like the user to be able to add a material, the price, and some other fields in one section. -Then, I'd like them to be able to add another section with the same fields for the next material needed to be ordered. -After they're done, I'd like the form to be able to calculate the total price -I'd like the form to be submitted for approval. -I'd like the approved form to be stored in the CRM. How
Fetch data from CRM "Products" module
Hi, I have a CRM lookup field to "Products" included in one of my forms. While using the form, when I select a product from the dropdown lookup CRM field I'd like the "Unit Price" field to be copied over to a field I have in my form called Cost_per_Fixture. Also, this is a subform.
encodeUrl() bug: using this function on numbers turns them into null values
Here is a function that you can run to illustrate the issue. In brief, for integers and decimals, unless the value is first turned into a string using toString(), it will become null when encoded for a URL. void Bugs.encodeUrlBug() { // this function illustrates a bug whereby integers become null values when processed by the encodeUrl() function // the solution is to turn all numbers into strings before using the encodeUrl() function // encodeUrl() documentation here: https://www.zoho.com/creator/newhelp/script/built-in-functions/built-in-function-url-encodeurl.html
Deluge - copying text to Mac clipboard
I need to copy a value (actually the current value of a Creator autonumbered field) to the Mac OS clipboard. Is there a way to do that programmatically from Deluge?
Stuck on "Please wait, while we work our Magic!"
Stuck on "Please wait, while we work our Magic!" Please sort out the issur
GET URL ID in products page
I'm new here and I'm creating a app to control my products costs. I create a new page with my product list, I need to create a link for each product send to information page, this information page will show me all information for this specific item. I'm sending ID_product for URL https://app.zohocreator.com/ricardo289/custo-produtos/#Page:PG_Custo_do_produto?VarID=1 Now I need to filter all details using this VarID , how can I set a variable with this information ?? like: VarID = ????? (URL variable)
Post XML String data without a Form
Is it posseble to post the XML string data without a form, I am trying the below script without much luck? ------------------------------------------------------------------------------------------------- <script type="text/javascript"> if (window.XMLHttpRequest) { xhttp=new XMLHttpRequest(); } else // Internet Explorer 5/6 { xhttp=new ActiveXObject("Microsoft.XMLHTTP"); } var url = "http://creator.zoho.com/api/xml/read/apikey=[APIKEY]&ticket=[Ticket] "; var XMLString = "<ZohoCreator>
Possible to add data to Creator via email integration?
I'm in the process of building a GTD (Getting Things Done) style task manager using Creator and am looking for input on email integration. Specifically, I'd like to have the ability to create some sort of "Inbox" in the app so that I could send an email to a designated mail target and have the Subject and/or Body of the email show up in the app. For example, the app would contain a "New Action" form with Title/Notes fields mapped to the Subject/Body (respectively) of emails coming into the mail
Error in sum function for formula fields
Thank you for a very good online application, wich I find very useful. However there is an issue whith the sum function for formula fields It only sums the integer part of the numbers - this is the case in all my applications. How can I make it also work with decimals - this is an important issue for this application. The application has been shared with Zoho support. Also I would like to be able to move or export applications with the contained data between accounts. Is this in your to do list,
How to get the list of multiple checkbox value
Hi I have order header and order line item two different form. order line item is subform. I want use to search order number and then select multiple order line items and update the details. I know about the bulk update . but i want to send email based these update. please suggest. Thanks in advance RS
Cannot see Action Buttons on Reports when using iPad
I developed buttons on a report to open a new form based on a record within a report. On the desktop, it is working fine, but when I use my iPad app, there are NO buttons. Are buttons supported on iPads? Attached is a file showing side by side desktop version and iPad version
Blueprint integration?
So Blueprint is now integrated into CRM and Projects. Does anyone have any insight into whether we will eventually be able to integrate its functionality (hooks, triggers, UI, etc.) into Creator apps? It strikes me as an obvious fit. Thanks in advance, James
Simple searchRecords call
I'm trying to make a searchRecords call based on the "new help" documentation for C5 found here: https://www.zoho.com/creator/newhelp/script/crm-v2-search-records.html (see example #2) acc = zoho.crm.searchRecords("Accounts","(Account_Name:starts_with:A)"); info acc; I receive {4832:"Invalid parameter value"} in my log messages. To be sure, I've tried this on both C5 and the previous version of creator. This is the only code in in the application. I'm a ZohoOne subscriber. I'm having similar trouble
qr code
I would like to add a unique QR code to my pre-printed deposit slips. The QR code would go to a form that allows my employee to enter the deposit info. The question I have is, can I create a QR code that is unique to each deposit slip? And is there a way to scan the QR code twice? First scan for the employee to enter the info and the second for me to verify/approve the deposit.
Where are Report Settings in Creator 5?
I was going through the tutorial videos, currently on Zoho Creator: Intro to Rules and Workflows. At 8:07 it talks about being able to add the Status (which was hidden to the form user) to the calendar report in the Reports Settings, Column Properties section. I'm following along in the new version but cannot find where I can add Status to the calendar report. Any ideas? Thanks!
Next Page