Images don't display
Zoho creator seems like a really robust platform but my first impressions are that it is buggy and unpolished. I hope I'm wrong but I suspect this forum post will land in a black hole somewhere. I am trying to create a simple employee directory that includes a photo for demo purposes. I have followed the instructions in Zoho's help file but the image that is supposed to appear in the help file just displays the infamous black "x" icon indicating the picture no longer exists or the link is broken.
REST API and Authtokens limit
I just want to know that is there any limitation on Rest API (for Zoho Creator) using external scripts like PHP Curl etc... AND Is Authtokens are limited? what i mean, that Authtokens usage is unlimited or there is a certain limit for using authtokens, like 50/100/200 (any count) times per minute/hour/day etc..... kindly assist me and sorry for my poor justification.
How can I save a file on a File Input field using script/function?
Hi there! I need to put a file into a File Upload field using script. How can I do that?
nonprofit pricing? no response by filling our the webform
I'm curious if anyone can fill me in on what the approximate nonprofit pricing is for Zoho Creator? I filled out the webform to inquire a few days ago and haven't hear back. Thanks, Brady
Is it possible to move/copy a Personal App to Workspace App?
Inadvertently created an app under Personal rather than Workspace. Is there any way to change the type of app from Personal to Workspace, or to move/copy it to Workspace?? Thanks!
How to extract part of a text string like =RIGHT() in Excel?
I am trying to add a field to a form and use a formula to copy just the right-most 36 characters from another field into the new field. Similar to the Excel "=RIGHT()" formula. Is this possible in Creator? If not, any ideas on how I can accomplish this? Thanks, David
data saving
Hi, I run a mobile dance club in the uk. I've had a developer from this site working on a simple datadase with a event calendar with some email support.. this has taken longer than expected but looks and works ok... But i have a problem with the event payment section... Zoho does not save data automatically and the way the adding members and payments has force me to start looking at other software... the designer has given up he cannot work out a way to do it... this is how it works now . Open calendar
Get related record
Hi there, I have a Creator form with a CRM field Potentials and a field " Contact Phone" which I would like to populate with the value "Phone" of the CRM Contact related to the Potential. I can't get it working ... please help
Validating SubForm Data
Hi there I have a Parent form "Bookings" - fields include Name, Company, Email, Phone I have a Subform "Booking Detail" (field name Booking Details). I have code on the "Add Row" to populate fields on the subform - effectively transferring the parent fields to the subform. The problem with this approach is if a user adds a row to the subform BEFORE filling in the parent form, the details don't transfer down. The other scenario is where they enter the parent form fields, add a row/s, and then before
Zoho Creator Android app - offline forms with workflow workarounds
One of my main requirements was offline data entry, and I made the mistake of not fully understanding the limitations of the mobile app. I built an application with all sorts of workflow scripts and lookup filters only to find out that neither of these are supported when accessing forms offline https://help.zoho.com/portal/en/community/topic/zoho-creator-ios-app-3-7-2 My question is if anybody has found any workarounds for some specific cases: 1 - filtering lookups when accessing the form offline
Update a record through zapier
Hey zoho, I would like to update a record when a specific event from another app is trigerred using zapier. As you dont offer updating through zapier, is there a way to do it anyway ? Thanks a lot for Tour answer
calculation on date field
I'm new to zoho I have a form with date field which the user has to enter. I have another field which I want to calculate based on the date entered by the user. I want the calculation to be "the date entered + 9 days". What s the best way to do this ? thanks for any response
Error Executing Workflow On User Input Script
My scripts were working a few months ago. As far as I know, nothing has changed. I have not added or modified any of the fields nor the scripts that access the fields. This week I needed to add new records and update some existing records. I received the following error: The field CONSULTATION STATUS is changed from either "NEW" or "IN PROCESS" to "COMPLETE" when the consultation is done and I click UPDATE. At that point I have code to calculate some totals and percentages. Here is the script
Export in excel format
Dear all I have issues when I try to export in excel a report including field in a currency format. The data of an amount fiel is not in a right foramt for excel and I am not able to make some calculations with these amounts. Many thanks for your help. Isabelle from Banook Group
Unknown Error
Just got this error: Left expression is of type BIGINT and right expression is of type BIGINTLIST and operator + is not valid Anybody know what it means?
Zoho creator to Quickbooks customer mapping
So I wanted to be able to create a customer and add info from a created sheet when it is submitted. I am able to create the customer and add Family name, display name, and billing and shipping address info with the following code: //Declare Map Variable to hold the customer details Customer_Details = map(); temp = Quote_Sheet [ID == input.Customer_Name]; //Add the customer details to the map variable Customer_Details.put("FullyQualifiedName", temp.Customer_Name); Customer_Details.put("DisplayName",
Fetching and updating records from another database
While I know it's possible to use a lookup field in a form to relate a record from another application, is it possible to use script to fetch records into a variable from another application?
Making formula field data available for export/import
Hi. I exported formula field data from one application and when importing the data into another, there is no labeled field to accept the record data. How can I make a field in the form that mirrors the data calculated in the formula field so I can import it?
Contact Form Not Redirecting to "thank You" page
My contact form is not redirecting the user to the thank you after they fill out the form. I'm considering zoho for my company but having this issue is not helping. http://residencialsantaelena.com/contacto/
Issues with Web Embed
Hi all, I'm having a couple little issues with embedding my database on a webpage, I wonder if anyone has encountered similar issues and if there's an easy solution. The first is that when I embed my reports, initially they never show up. It's only when I change the display from say List to Summary that they show up. Another issue I'm having is that when I search my app on Zoho, if I have a multiple select field when I go to search that field all of my possible inputs show up and I can just select
Bidirectional lookup from one subform to multiple mainforms
The solution offered here works perfect when there is one subform and one mainform. I have a scenario where I have one subform that is included in multiple main forms, and I'm looking to somehow link them together. If I try to add bidirectional lookups to the subform based on the existing relationships - I can only choose one at a time - so it only works for one main / sub relationship. Ideally I would have a single 'Source' column in the subform that is linked to the main forms that were used at
"Other" option is added to a drop-down even when the option is not marked!
Hi Zoho, I have a form (Loan_Valuations) that for a drop-down field of its suboform (Loan_Valuations_Broker - broker name field) it takes a list from a third form (Loan_Comp_Req - approved brokers field) and append it to the drop-down list On Load both on On Add and On Edit. This should not have a "other" option, and it is not marked as applicable anywhere. But: On Edit mode, there is an "other" option available !!! Please fix this ASAP. thanks Ravid
Complex criteria in pivot reports and charts
Some time back pivot reports and pivot tables were created based on views. The criteria embedded in those views were carried over into the reports. Since pivot table and charts are now created using the form, criteria restricting others from seeing the data is limited to 'Only logged in user records' and 'all records' but not to others authorized to view it as well. What am I missing?
Filter within an sub form
How do I filter within a Sub Form? In the "wiring" form we use Filter Site.ID equals input.wiring_site on a Device drop down. I want the same filter within a Sub form but it states wiring_site is not defined?
Upload Image File via Creator API from iOS App
I'm writing an iOS app that will upload information to a Creator application using the REST API. I can upload text fine, but I can't get file uploads to work. I'm trying to use this API, but as the example is for how to set up a web form I don't know what the structure of the POST request needs to be. I've tried a few different ways but I either get back a status code 500 and a HTML error message or a 200 response with a message saying the request was successful but the image is not uploaded.
Google AutoComplete Address DropDown
Hey Zoho Team, I need to make a google autocomplete Address Dropdown for my application. I need to know how is this possible with your javascripting code side. or any other alternative to do this. I am attaching a Screenshot for it also. Please Check and Explain with your best Example. Thanks
File Uploads Using Zoho Creator API
Hi, I'm having trouble getting a file upload field to work using the Server Side Rest API in my form. Please see code below: <form method="POST" action="http://creator.zoho.com/api/xml/myapplication/myapplication_Form/add/apikey=XXXXX&ticket=[XXXXX]"> <table> <tr> <td>Photo Upload: </td> <td><input type="file" name="Photo_Upload" size="19"></td> </tr> </table> <input type="submit" value="Submit XML String" enctype="multipart/form-data" > <input type="text" name="zc_ownername" value="[myname]"> Everything
Auto Number
I would like to auto generate a unique 3 digit number in field "wiring_reference" in wiring "table". The number needs to be unique for each "site" which is selected from a look up field of "wiring_site" in the wiring table which looks up "site_reference" field of table "sites"
Auto-Field Updates
Hi everyone, I'm new to using Creator and am confused about how to accomplish something. I have created a call-tracking form that fetches contact records from Zoho CRM. I can't figure out how to auto-update the next field, which is the customer's account number; this is a field in CRM. Does anyone know how this can be done? I have checked different help articles and am still confused. Any insight would be greatly appreciated. Xavier
Fetch Data from 2 different form?
Hi people, I'm newbie to creator and deluge, I'm following forums and help center and creating a application for my business needs. I have problem with fetch datas. Let me explain the structure that I have create and ask questions I have 3 different forms and; First form called Courses, it has 3 different single line text fields to explain 3 features of course (1st one name, 2nd one group, 3rd one Semester) And second form called Students; this form has student information and course information,
Zoho creator: How to add a record from a vb.net forms application
Hello, I am struggling for one day and I hope someone can help me. I try to add a record from a windows forms application using vb.net. This is my code: Public Sub addRecord(ByVal ht As Hashtable) Dim apiUrl As String = "https://creator.zoho.com/api/<xxx>/xml/<appname>/form/<form name>/record/add/" Dim xmlStr As New System.Text.StringBuilder xmlStr.Append("<input type=""hidden"" name =""authtoken"" value=""abcdefghijk"">") xmlStr.Append("<input type=""hidden"" name
How to Renew My domain
Need help renewing my website so it can be alive. Please assist me in this matter.
Function works only for one field !?
Hello All I created function to fill 2 fields with current infos in the report when button clicked to update instead of ask user to refill it , Function works well but with one field only , I don't know how to make it work for 2 fields when use " &" or other symbol error message appear , when use " +" no error but all string come in one field , Patient_Secludes void progress(int ID) { (this one working) a = DrNote[ID == input.ID].Patient_Secludes ; (No working even added after comma in
Looking for some one to build me a Data Base and CRM ASAP
Hi, I am looking for some one to build me a Data Base and CRM ASAP who can do it Skype gabigeva regards GG
Pass information from one form to another
The reason for my mail is to see if you can help me in a development that I am doing. The main problem is that I need to pass information from one form to another, through global variables or functions, depending on the case, I would like to know if there is a way to do this, and that my action is executed when you press a button or similar. Thanks!
search interface
Hi, I’ve successfully created a search page with html views. The search page allows our users to type in a keyword from any of these fields, Requestor, Request Details and Response. The script is – <%for each find in Add_a_reference_request [((Requestor.contains(input.searchStr) || Research_Request_Details.contains(input.searchStr)) || Response.contains(input.searchStr))]... What I like to do is to create a Boolean expression for the search. If a user types in a requestor’s name and a keyword
cannot edit site, everything isnjust freezed, no drop down menus and cannot publish it. HELP!
when i open my site editor, i cannot edit anything and when i click on publish, the loading bar pops-up and nothing happens for hours.
'item' is a lookup field and child fields cannot be accessed
Hi, I have 2 forms First with product name and rate second quantity and amount i want to multiply rate from parent form field with quantity of child form field and display in amount field. Please help new to zoho creator.. I get "'item' is a lookup field and child fields cannot be accessed" error thanks anand
Cryptography Function (SHA-1)
I need a function that calculates an HMAC hash from a Date String as the value, a shared Secret Access Key (both the sender and receiver have this key), and SHA1 as the hash algorithm. Why? This is a simple way to verify the authenticity of information. For example, if you send an email to a client and included the hash as a "signature", the data can be validated by the client. There are many instances where this would find value. SHA1 is a standard cryptography method Many APIs require a hashed
Problem with Lookup Function
I created a form which does a lookup for PO number from another form, this works fine, however when I try to lookup a second field which contains the PO Name information from the same form using the first lookup results as a filter I get a type mismatch saying I can not use that because it is a BIGINT format, but it was created as a string. Why is is converting this and how do I get around it, or alternately how do I bring multiple fields across in a lookup function and display them in separate fields
Next Page