Multiply
I have two number fields; cabHeight //inches cabWidth //inches another field on the same form called sqInches I want to multiply the first two fields and put the total in the third field. What would this script look like and where would in go "on user input, update, success field level or form"?
Adjust Column Width on PDF
Hi, I am running a few schedules where I send some "views" as pdf attachments. I adjusted the column width for each of the "views" using "Set Column Width" but these adjustments are not showing up on the pdf attachments. Is there a way to adjust column width for the pdf attachments generated for "views" via Schedule Function? Thanks! Vishal
How to improve performance
I am wondering if there is any way to improve the performance of Zoho Creator. While I was making a presentation, one of audiences did not like the delay of page loading. I found that somebody posted some basic advices about writing a script, but is there anything else I can try? Our database does not have much data yet. Only 10-30 records for each table. When I jumped to menu to menu, we saw "loading" icon. Should I just say it is common because database is a memory intensive application? I do not
Resetting lookup to null
I have a form with a lookup field using the new builder. What is the script to clear the value in the lookup? Setting the field to null gives a script error- expression type does not match: type required:long Setting the field to 0 gives a runtime error.
Developing on the IPAD - is it possible
Hello, I have tried to work on Zoho Creator apps on my IPAD and it does not seem to work. I cannot update the form properties. I am using the new interface. Is there something I am missing? Is this a known problem? Any help or some direction will be appreciated Thanks David
How do I create a script to show a particular field based on selection of a 1 choice radio button
In other words I may want the field 'Docket Number' to show (hidden on form load) when radio button with one choice is shown (let's say button says 'In Foreclosure'). Please advise. Thanks in advance!
Getting products data from Quote
Hello, I have an app with zoho crm field to CRM product. What is the correct way to get the products data from a quote. quote = zoho.crm.getRecordById("Quotes", Quote_ID); quote.get("product") // returns string, how can I get a list or map from it? quote.get("product").toList() // returns a list, but the string is just split by "," and it's not usable quote.get("product").toMap() // wrong! quote.get("product").toJSONList() // I've seen this somewhere, but it doesn't return anything. Maybe I'm not
Client side scripts for showing or hiding "Show a link to add new entries"
It will be nice to have ability to hide or show "Show a link to add new entries in" by deluge script on client side. It can be usefull for managing permissions for adding new values to form, from other forms with lookup fields Like this: field1:ui.showAddLink() or field1:ui.hideAddLink()
Problem in downloading PDF from Zoho creator.
I have created a form in zoho creator and I have created a custom view for this form in HTML. Now i want to downlaod the PDF from this form. But everytime I try to download the file from this form it prompts me to log in. I want to download the PDF without sigin in the zoho creator. Help me out as how can I do this.
how can i import more than 70 columns all at once from Excel table?
Hi, how can i import more than 70 columns all at once from Excel table? Thx!
Display Field on Calendar ... can the number of characters be extended?
I need more characters on the display field in my calendar. There is room for more on this particular calendar.
Google authenticate not working on Ipad
Here is the situation: This is a Zoho Creator with Google apps setup I have a Zoho Creator form that is embedded on a Google site. The form has an upload file field that can upload a file from Google Drive to the ZC database. This works just fine on the MacBook Air On the Ipad however the Google Authentication periodically just hangs. ....are there any solutions to this? I have been unable to get any useful answer from Zoho support.
field-level access for editing in my custom creator's view?
hi for managers who works next on entries in custom views how make next functionality 1) i take for work view with fileds 1, 2, 3, 4 2) fields (when they open entry) 1 and 2 they can only view without ability of edit 3) fields 3, 4 they can and view and edit examlpe when they open entry for edit first 2 fields they see but can't change, next 2 fields they can change.
Creating a function to open a list
Hi, I've created a list and now I want to be able to create a function that provides a button in the list that when clicked opens another list that is related to a value in list one. I've looked through help & forums but can't find anything - can you point me in the right direction please. Martyn
Encryption
Is there any news concerning encryption of stored data in Zoho Creator? It is a great product, but until we cannot store sensitive data in a secure way, we are prevented from using it as much as we would like to.
Want to create a Dashboard for Response Rate and Converted Lead Rate
I want a visual dashboard that shows the percentage of contacts who responded to my mass e-mails and a conversion rate from being a contact to a lead. How can I do this? I apologize for the broadness of my question, but I am not familiar enough with the system.
Deluge statement for showing "Edit record" for lookup fields
It will be excelent to have following abilities: Additional option for lookup field: Checkbox "Show Edit link". If you select it, you can also select View for this Form, which will be opened for editing Deluge statement to show or hide this "Edit link" on client side We ofthen need to make some changes in selected in lookup field related form
Displaying views with many subform rows
I'm using subforms for a few of my forms. Some of the records have many subform records, ie 50+ children. I have views that display the form and subform results. The views currently display 1 subform entry per line. For entries with multiple subforms, it is very hard to read. My suggestion is to have subform records either comma delimited or per lined as an option. It will make it easier to read rows with multiple subform rows.
Can't log support issue on website....your website is broken....
Can't log support issue on zoho creator support site, see error below, rather ironic that support site is down!!!! An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go toZoho Creator Home
Online Documentation for getDayOfYear() incorrect ?
The text regarding 'getDayOfYear()' on page : https://www.zoho.com/creator/help/script/built-in-functions.html#Time_functions Looks like it refers to 'Day of the Week' and not day of the year ? "returns a number in the range (1-7), representing the number of the day of the year,that date falls. The number "1" represents Sunday, "2" represents Monday and so on." Does the function not return a number 1-365 or does it actually replicate the functionality of getDayOfWeek() ? Neil
Function error message
I am updating the following function Application: https://creator.zoho.com/essistmgmt/assets Function: udf_history.save_subform_row_deletions I am getting the following error Function is modified successfully However the following other functions have argument mismatch in invoking this function Make a note to correct them as early possible, as it may lead to execution errors In action script-->COST(form)-->on success with arguments (string ,int ,string ,string ,date) In action script-->EVENTS(form)-->on
How can I monitor my users?
Hi, I've just built a new application and want to make sure my remote users are using it correctly. How can I monitor their activity and undo errors as necessary? Thanks
what, really, is an application?
Hi, I am using Zoho Creator, new to it but I do have an MSC in I.T., I totally get Zoho Creator, no problem, even with limited experience on it. What I cannot seem to wrap my mind around and cannot see from the knowledgebase is the answer to this question: what exactly is a zoho creator application? Of what consequence is it? I mean, say i have 30 forms i plan on building, why should i not dump them into one application, even though they may not be related, as opposed to create a separate application
Hide/Disable Submit Buttons
Hi Think its critical to have the option to incorporatre the submit/reset/custom buttons into the deluge script so programmers can hide/dissable etc those buttons like any other fields. Rgds,
REST Api downloads a file
Hi all, I am integrating a website we have on Magento, so that a newsletter subscriber on the website is added to our MEMBER database. The website is in PHP though so my tweaking is not very strong. The REST API and form are working fine now, but the result is that an XML file or JSON file are downloaded whenever you click submit. Can I avoid that ? tx, Seppe >>> Here's the code. <form action="https://creator.zoho.com/api/my_owner/json/my_application/form/MEMBER/record/add/" method="post" id="newsletter-validate-detail">
Multiple attachments of xls sheets in scheduler
Can i have 1 schedule command that has more that 1 attachment in it? It seems silly to have multiple schedules for multiple docs at once.
data entry focus
While entering data in to the application, pressing enter takes you to the next data record..this is good. ... but... the focus remains on the last used control...which is not what most people would expect i guess tommyjonas
Is there a delay to send mail through scheduler?
Like 30 minutes? I'm so confused by this thing, is there a sample application that shows how it works?
Can't get my field to show or hide based on user input.
Hi. I have a field called 'In Foreclosure?' When a user selects 'Yes' from the dropdown menu, I'd like the 'Docket No.' field to show. If any other selection is chosen ('No' or 'Unknown' are the remaining choices), then I'd like to hide the 'Docket No.' field. Even after it shows as a result of me selecting 'Yes' (let's say I change my mind). I'm hiding the 'Docket No.' field when the form loads. But I can't seem to get the remaining script to work under 'In Foreclosure'. Here's what I have: if
Changing imported field type
I have a POSTCODE_SUBURB form that has a POSTCODE field as a number. I will now be adding UK postcodes that are in a alphanumeric format so I want to change the field to string type. The POSTCODE field is referenced in many other forms and scripts. I cannot easily recreate the relationships/script logic/etc. The import fields that reference the POST_CODE field are also used in other script logic. How can I change the field to string without spending too much time? Please do not give advice to create
New App Builder : How Does Auto Number Work ?
I can add the field, but it doesn't appear on the data entry form, neither does the data appear in a view or even if I create a formula field to display the content (on a data entry form) using the 'Auto_Number' value as the input.
Need some advice on forms layout
I am new here to ZoHo and I already have my database/form setup but the problem is I have a ton a fields on the form and I am trying to figure out how I can make sections collapse/expand - I haven't been able to find it, not sure if it exists. If not is there a way I can have the user added additional fields as needed for add more content? I have it split up in two columns but that's not enough. Can anyone provide documentation on how to work with this? Thank you.
Anyone come across "invalid Subform Comp Name <columname>" error - Subform
Hi While setting up a dynamic picklist at subform, I had used clear row.<subform-field'scolum name> to clear the list eg: clear row.Area This would clear the list But, now i am unable to save this line of code as it says Error at line : 1 'Invalid subform Comp Name Area' Anyone come across a similar error while trying to clear subform's droplist? -Deepa Govind http://homepreneur-online.com/
Links stopped working in zoho creator from 2010 how to I update the links so my website updates correctly??
A former coworker set up the zoho database in 2007 & 2008 with various views that would automatically show up on our website, and the links used to work correctly.. now the website will not update with the zoho creator data. HELP!!! here is one source page of the website. where the heck do I find the new or updated link for zoho creator? it's supposed to automatically populate the following website: http://www.hchlibrary.org/gala/sponsors2013.php <title>The Henry Carter Hull Library | Gala
Creating a Function - variable not decleared
Hello, I have a script to calculate prices in a subform. This script is duplicated in three fields price, quantity and discount. I want to create a custom function called 'Price calc' so that I can alter the script in one place. To create the function I'm simply copying and pasting the script from one of the fields, into the Function script area. However I get several variable undeclared error when I try to save the function. What am I doing wrong. Thanks Stephen
Default image in form
I need to set a default image (QR code) in a form so that it is displayed in a report and when exported to a spreadsheet. The QR code will always be the same as it will direct third parties to another Zoho form (permalink) once scanned on a phone to fill in. Is this possible? It would seem actually adding the image detail could be achieved through a notes field but notes unless I'm mistaken are only for reference on a form and can't be used in report. Also the information I've found online to actually
Get lookup fields
I have lookup dropdown field in my app, it import date from other app like ID, name, age. How can i get all fields for selected lookup entry? I try to get like: mylookup.name or mylookup.age - but error. And mylookup give me just current lookup ID.
Fetch phone number from Zoho CRM to Creator?
Hi, I've been fighting this problem quite some time, and still haven't found the solution. See the attached picture. When I check of the "Contact person = costumer" box, I wan't the application to fill out the fields "Contact" and "Mobile". The "Contact" field is easy, cause it's equal to the "Costumer" field, but how do I get my app to fetch the phone number from the CRM? Hope you can help me, Kind regards, Mads R. Svendsen
using business name in application URLs instead of personal user name
The Zoho Creator URL structure is: creator.zoho.com/[user.name]/[app.name]...etc. I would prefer not to have my account's personal user name form part of the URLs of my apps in Zoho Creator. My account is for business use and I would like the URLs to reflect the company name (or an abbreviation) instead. I understand it is not currently possible to change this without going through the hassle of creating a new account. This seems very inflexible and counterintuitive for business users where the account
Limitations on Script Size
Are there any restrictions on the number of lines of code that can be written for one script ? Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Next Page