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
Update Image Field Via Custom Action Button
Is there a way to create a custom action button in a report view that would allow a user to access an image upload option to add to the respective record? Scenario is, I would like for a user to have the ability to access a record in a report on their phone, select the custom action button and be asked to upload an image or take a pic on their phone. Once complete, it adds to the record. I know there would be an option to create a button that would take the user to the form and can access the image
My profile api reference not showing
What may be the cause of not showing anything when i visit the link https://creator.zoho.com/api/reference In tutorial says when i visit this link i will get my full info about my app/reports/fields etc.
Zoho Creator - Redirect Form to Page
Hi, I've done a little research and this seems to be a similar problem - albeit without a meaning resolution. https://help.zoho.com/portal/community/topic/want-form-redirect-to-pass-via-parameter In essence, I wish to take the ID generated from a created form and pass that into a new page. This page serves as to display a variety of information (as a result of a deluge script being run on create and generating other items - which works fine). The problems I am hitting are: 1. The direct to page
Subform as pop-up box - getting the data back into the main form?
Hi All, I've got a huge subform in my main form, so I've made it a pop-up form. The issue is, On Submit of the pop-up form, I need to push at least one of the field values back to the corresponding row of a subform within the main form. Each row contains a decision box that, when ticked, will pop-up the record for them to edit if needed. Passing a unique field to the pop-up subform: The use case is for adding rooms to a home. The subform pops up On User Input of Room_Type field. If Room_Type is
Fields can't be updated on button click in stateless forms
There was a recent change in stateless form behavior and it requires an urgent fix. When a stateless form button is clicked it no more executes the script which updates other fields from the form. It previously worked, now the same script no more works - I guess that this is a problem related to the new UI. Please fix this as soon as possible. it currently breaks existing functionality in some of my applications (and I suppose that I am not the only one affected). I hope that this is not an intended
Proper way to map First and Last Name from CRM Webhook to "Name" field in Zoho Creator Form
I am trying to create a webhook action by mapping particular data in a CRM deal over to details in a form in my Zoho Creator App (Fulfillment Tracker). I am able to successfully map data to my form/table that is a standard field (i.e. single line input text). However, I am running into an issue when linking up to the name field (which has sub-fields of first name and last name). I included screenshots below up my setup on the Zoho CRM, the form on my Fulfillment Tracker App, and then the table which
Next Page