About zc_LoadIn=dialog and zc_NextUrl=
The recent additions to the navigation features of ZOHO Creator ... using zc_LoadIn=dialog and zc_NextUrl= ... in the url values of the openurl command and links (within HTML Views) ... can significantly enhance the overall ergonomics of applications built under the ZOHO Creator platform. So, I decided to investigate the behaviour of ZOHO Creator in response to user actions when such features were deployed. With few exceptions, the responses are as expected ... and will add a lot of versatitlity
Update Field on Add Row in Sub Form
I have a subform with a field "Position" in it. When filling out the parent for, and adding additional rows to the subform I would like the Position to count +1 on the addition of each row. How can I do this? Thank you in advanced
Edit fields through a form
I am building an app to keep track of submittals. I would like to create a form which allows for updating existing records of submittals as information changes. As the submittal is sent from location to location getting approval, I would like to keep track of the dates we sent/received them. Also, I would like to be able to update the status (using a drop box). Basically, I need to create a form (nearly identical fields as the one used to input the information) which allows me to update existing
Update a FORM field via URL
Hello, Is there an easy way to update/modify a field in a FORM just by URL? I have looked through the forms and help areas and I cannot find anything on the topic. Basically I just want to change status field (a drop down) in my FORM from "New" to "Active" with once click. I do not want to have to to into the form, change the pulldown and hit save every time (that is already in place). I was trying to create an action button in the report list view that when clicked just changed that value - and
Size of file
I have an application where it is critical that I know the size of the file uploaded. Does not matter if it is before the upload or after the upload. I just need to know the size at some point. (I understand there is a 5mb limit this has nothing to do with my question) Is there a way to find out what the size of the file is? Any workaround or ideas will be appreciated. Thanks David
Formula with no time
Hi I am still new to using Creator. I have made a formula to add a number of days to a date field. Expression I've used: Start_Date.addDay(364) In the formula field it showing the correct date (364 days later than Start_Date) but it is also inserting the time. For example it is inserting like this: 11-12-14 08:00:00 Does anyone know or can help me to just get the date and not the time as well? Thanks
Report: chart & pivot type
I want to show both a line chart & the table chart of the same data. Rather than create 2 reports, my suggestion would be to include a chart type that shows both. I've used other reporting tools that have that feature. It would be a nice add on.
Brackets move
I am developing scripts and noticed that the brackets move when I save and reload the script Original code else if (cws.Address_Line1.contains("SUITE")) { cws.POSTAL_DELIVERY_TYPE = "SUITE"; } Code after saving else if (cws.Address_Line1).contains("SUITE") { cws.POSTAL_DELIVERY_TYPE = "SUITE"; } When I attempt to edit the script, I get error because the brackets have moved. Can you please investigate?
Towards a generalized HTML table-generating scipt
I'm trying to generalize the table-generating script presented in https://help.zoho.com/portal/en/community/topic/html-views-18-2-2013 (which is quite useful as is). My current version is as follows: htmlpage Table_script_test1() displayname = "0Table script test" content <%{ Width = "1200"; Table_Caption = "WBS Info"; Col1_Header = "Activity"; Col2_Header = "Main Dependency"; // Form_Name = "WBS"; Criteria = "ID != null"; Col1_Field = "Activity"; Col2_Field = "Main_Dependency";
Can't upload excel sheet into Zoho Creator Application
Hi there I am trying to upload an excel sheet (.xlsx) with 9 columns and 140 rows. Whenever I browse on my computer for the file, then select it and click "create", I only get to this URL https://creator.zoho.com/importData.do and it stops doing anything. It's just a blank page. Is there anything specific that I need to do with the excel sheet? Is there a limit of character I can use in the cells? I am looking to use Zoho for my new product launch but I need it to work properly. Thanks for the feedback.
Creating many-to-one relationships using subforms without duplicating records
I am developing a database of energy programs. I am trying to set up many-to-one relationships without duplicating records. For ex: a program may have more than one contact but a given contact may be the contact for more than one program. Using subforms doesn't work because if 5 programs have the same contact, I'd need to enter that same contact on each program form. The contacts table would then have 5 copies of that contact. I can select a contact from a drop down list of existing contacts (based
Variable based trigger for e-mail
Hi, I'd like to create an e-mail that is sent whenever a variable called WCExp reaches 10 and then again when it is at 1. So far the only help on e-mail notifications I've found are those triggered when the user inputs or edits data. I'd like this to occur without any action, a self monitoring e-mail notification. Any help? Also, as I was typing this, I realized that my formula doesn't seem to be updating daily. It only calculates for the day inputted(using the formula given by zoho for calculating
Need Help getting started....Willing to Hire.
I need help getting my estimate form put together. It has some look-up fields to fetch the price of items. Add checked mark options to total price. Then be able to download a pdf of estimate. Anyone up for the challenge? Anyone built something like this? Anyone know where I can turn? Thanks Mike
Spell Check
I note that Spell Check does not continue to work after I make the first of the suggested changes. Once I make a correction, any further spell check is absent. But if I highlight the entire paragraph, right click and de-select spell check, and then re-select spell check any mis-spellings are again shown.
Importing Excel spreadsheet
I am having trouble importing an excel spreadsheet. Creator says the import is successful but the data doesn't show
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">
Next Page