Login limit
Hello. I have developed an app that -among other things- allows the user to upload images. This app is the front-end to a report generator hosted in a remote server. Since Zoho Creator doesn't allow to automatically download images (via API or the like), I developed a script that automatically logs in, retrieves the images URLs, downloads the images one by one, and then logs out. Last friday, after I ran this script many times, it stopped working. When I tried to manually log-in, a "Login limit reached"
Inserting Sub-Form Rows
Hi everyone, I've done some reading around and whilst the problems seems to be solvable I'm going around in circles Scenario Once new inventory component is created, we need to pre-populate a list of tasks for (percentage) allocation. (via Custom Function) Problem I can't seem to be able to loop through the tasks and incrementally add them into the sub-form. I have tried Directly adding (via insert record) to Sub-Form. However, I get the error "Form 'Task_Distribution' does not exist in the application"
Mobile menu not updating
Hello, I've set up a customer portal for our users, and in my testing I've noticed that the menu isn't updating on the mobile side. I've hidden items and renamed some things, but those changes aren't taking effect on mobile. I do see the changes when I login on my desktop, so I know the changes are being made. I just can't figure out why they wouldn't be updating on mobile. Is there some delay in updating the mobile that I'm not aware of? Or, or is this a glitch? Any help is appreciated.
Retrieving Customers from subscriptions.
Hello, I have a function that I created today that pulls customers from subscriptions. And no matter what page number I put in I get the same records. The page number is set to 4 below. But no matter what I use I get the same customers. Below is code: Custs = zoho.subscriptions.getList("Customers","649130175",200,4); I could change the 4 to 1 and I would still get the same customers. Could someone look into this for me. Bob Lozinak Twelve/Three Marketing, Inc.
Help page information about creating subform-mainform relation is out of date
https://www.zoho.com/creator/help/forms/creating-subforms.html#Creating_relationship_between_mainform_and_subform The second bullet under this section does mention some actions which don't seem to be related to C5 but to C4. Select the SubForm report from the Reports tab, click on "Column Properties" and select the lookup field created above and click on "Link " button, to create a link to the MainForm data. I've did use the "Configure Fields for Web" window belonging to the related report and have
Remove obsolete fields
I have a Creator app in production. I am using Sandbox to make modifications. There are a number of fields which I have identified as obsolete (which do not contain data in production). I would like to remove them from a form but I get a message saying that the fields cannot be deleted while in Sandbox. How do I go about deleting fields which are no longer necessary? I can hide them so that only Admins see them but that is very messy. There must be a better way. Thanks.
Zoho Creator File Upload API
Hello Zoho community! I'm having trouble with uploading a file into a zoho record. I've checked this post out https://help.zoho.com/portal/community/topic/upload-image-file-via-creator-api-from-ios-app but it seems like I'm doing everything correctly. He uses Apple's NSData of the image, but I'm using Base64. I'm getting back a success response too. <response> <result> <form name="Sign_Up"> <fileupdate> <values> <field name="Photo_ID">
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("
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
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
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
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????
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?
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
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!
Any Key to triggering Add New in subform
Is it possible to triggering Add New in subform by clicking any Key.
How to populate the html clicked radio button value into a form using Deluge
Dear all, I've a page with some radio buttons that I use as a toggle, I'd need to obtain the value of the clicked radio and insert it into a form together with loginusetid. The purpose is to remember what "tab" /radio button last clicked the user. Thanks in advance Eduard Martínez
Next Page