Report's Problem
Hi! My reports don't function. I see the message: An page's script cold be stop answer or in exec... Script: https://js.zohostatic.com/db/Jan_27_2012_1/compressed/ZDBGridView.js:1578 All my reports don't function since 26/01/12. I Can't create a new report too. Can you help?
No response from ZOHO Creator's Support Team to repeated email enquiries
Latha: 1) On Jan/16, I emailed you with a follow up question to (Yoge's long delayed) response to my original enquiry of Nov/23. 2) On Jan/24, I emailed you again ... asking for a response. 3) On Jan/30, I emailed you yet another reminder. There has been no response from you to any of the above emails ... why is that ? ... and when can I get a response to my enquiry that my client is waiting on ? As mentioned to you before, the client whose needs originated my original enquiry in November, already
How to call custom validation method in custom validation and set the validation message according to the inner custom validation result.
$.validator.addMethod("MyWebserviceValidation", function (value, element, params) { var otherStatus = $.validator.methods["childWebserviceValidation"].call(this, value, element, "true"); //Ajax synch call if (!otherStatus) {$.validator.messages["childWebserviceValidation"] = this.customMessage(element.name, "childWebserviceValidation"); return false; } else { //process for this validation and return as per the output } }, jQuery.format("The fields must be valid "));
iframe snippet embed issue
Hi We have 4 separate applications which have worked perfectly for several months. The applications are exposed within an iframe with form and view snippets. Suddenly all 4 applications come up with the following error message. Error details: Error occured while executing on user input script. Unable to update variable Error occured. An email has been sent to support with snippet details and access to one of the applications concerned. The applications are currently unusable. The coding has not
date email trigger
For my application, my customers contact me by submitting a form on my app, and then I email them back. I am trying to make it so, the customer gets 4 days to email me back (so I can tell if they are serious or not), and would like to get an email notification by that 4th day if they haven't contacted me, so I can delete them. Any ideas on how to make this happen? Thanks
forms
why can I not save my customize form after changing all the settings such as background colour and fonts. also is there a way to change the actual overall of the form width and height with border around it. I wanted to be 150px width and height 300px. how to set the fields when a user fills in that the email address is legitimate and not a fake or spam email. please help. thanks
Format Pivot Columns
I have a pivot chart which includes a column generating an average. The default average value contains 4 decimal places, how can i remove the decimals or reduce to 2 decimals ?
date criteria generating error
In a user defined function the following form criteria generates an error: apt_rec = Appointments [((((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate) && Start_Date <= inv.Closed_Date)]; However, the following version (without the end date specified) works fine: apt_rec = Appointments [(((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate)]; What is the correct syntax
Unable to access Views or Reports...started this morning (US GMT -6)
We are UNABLE to access any views or reports within our application. We can only use the default form... Are there others having this same issue?
Issues
Hi! I developed evaluther apps using the 15 days free trial with the end in mind that the client will upgrade this to a paid account. However, there were issues that they are still waiting for Zoho to respond to. 1. Inability of the system to create reports using data captured by multiselect forms. 2. Currency field configured with Philippine peso sign (Php). But when data is fetched by the report builder, the $ sign appears instead. 3. Printing report in PDF is not based on "What You See is
Parent fields empty On Add Row Subform in Edit mode
In my Invoice application I have parent form Invoice and a subform Invoice Lines. When a new line is added in the subform a script copies the unique id form the parent (Invoice) to the child (Invoice Line). This works fine when I create a new Invoice. However when I edit the invoice and then add a line in the subform the reference is not copied. The script is triggered but it seems that the parent field (input.INVOICE_ID) is empty in edit mode. Ivan
Is it possible to add UTF-8 support to ZOHO view ?
oday I exported from ZOHO view the information and chose different formats. * I wanted to ZOHO view Export support UTF-8. * I am from the Latvia. * I am writing in Latvian language and I need UTF-8 support. * Attached photos. *** HTML version is UTF-8 support, and there everything is fine. **** Spreadsheet version is UTF-8 support, and there everything is fine. **** Version of the XML is UTF-8 support, and there everything is fine. *** JSON version is UTF-8 support, and there everything is fine.
Embeded Zoho App is showing up as a header in Google Search how can I make this stop.
Usually a link for my site in Google shows up as the title of the page but when i embed Zoho instead of it saying {Contact Us} The link header says {Zoho Creator} how do I stop this.
another broken feature - cannot execute function in script editor
Yet another feature that has apparently been broken by the update on Friday... See screenshot taken in Chrome v15 which should be self-explanatory. The function is not executed and the modal dialog displayed is empty.
calculating number of days
Sorry to be so ignorant on database forms and formulas, however, I created this simple db and cant figure out how to calculate the number of days between dates entered. we have level of care date 1 and level of care date 2 and so on. I would like to have Days Level 1 to Level 2 calculate for me. I have included pic. thank you for any assistance.
platform update problems - why on a Friday and why so many bugs every time?
Why do these updates cause so many problems and break so many features so frequently? Why is there not thorough testing done using multiple browsers?? Why do the updates typically get rolled out on a Friday evening, thus leaving things broken on the weekend when I am usually working on our business's apps in preparation for the upcoming working week??? Why...why...why..........??!!!
alert messages broken by latest platform update
The latest platform update has broken the display of alert messages. This can be replicated this by testing an "On Edit / Validate" script which cancels form submission and generates an alert message to the user. All that happens is a generic "Failed to update" error is displayed without the alert message specified in the script. Why is there so little testing done before rolling out these updates which so frequently seem to break things that were perfectly ok beforehand??
subform display broken by latest platform update
Subform display has been broken by the most recent platform update yesterday. Kindly please fix this before Monday morning!
pricing discrepancy
I was looking at the upgrade options for Creator and when I view it while logged into zoho, the number of reports for Basic are 5 and for Standard are 10. When I view the pricing options when not logged into zoho, the number of reports for Basic are 2 and for Standard are 2. Why the discrepancy? Btw, Creator is great! Ray
Modify records in form in batches
Hi, i have a problem where a user inputted quite a lot of data via the form and my deluge script is failing. So is there a way to fetch the records in batches? There is a checkbox that is invisible to the users that is by default checked. So this way i can distinguish the new records. My script basicaly looks like this: for each deal in Deals [((Decision != "Go" && Decision != "No Go") && Status == "Request for approval")] sort by NewDeal desc range from 0 to 50 { //do some other stuff deal.NewDeal =
Expiring Date
Hi there, I made a Database with Airplanes (AERONAVES) from our customers (CLIENTES) and every Plane has different Equipment (EQUIPOS) as you can see in the following image: Every Equipment (EQUIPO) has different fields added from a Sub-form and one of the Fields wich is really needed is Expiring Date (VENCIMIENTO) as shown in the following image: How can I Fetch the Expiring Date (VENCIMIENTO) in wich includes the kind of Equipment (EQUIPO) and the Customers/Airplane Details. Im really blocked with
Unable to delete an application
I have a hold application that I can't delete from the Home page. The application is coming from the MarketPlace and I can't access to the source code. I receive the error message below. Please, can you delete and erase all data about that application. https://creator.zoho.com/slack/help-desk/ thanks This application components is used in the following places,Please remove this and try deleting the application. The function 'thisapp.helpdesk.getTechnicianPageUrl' is referred in following place
grouping a Lookup
Hi there, Here's the situation i have: In the Main form, i have a Lookup field called year. This is setup as a dropdown. It's lookup definition is to grab Recruitment_Year from Reference form. Recruitment_Year in the Reference form can be the same for multiple records. As in, i can have records form that may be: Recruitment_Year/Recruit_Name 2008/Jack Black 2009/John Doe 2009/Susie Q 2010/Jennifer Brown 2010/Alan Partridge Currently, if i pull up this Lookup picklist in the Main Form, it shows
Red Alert : Grouping Suddenly Not Working
As per title. All grouping in form view suddenly not working. I am using it this morning and everything seems alright. And now in the afternoon all grouping gone......HELP!!!!! Regards Andrew
Formatting forms
I'm brand new to Creator and have managed to make my first form. How do I format it to make it more user friendly? For example I'd like some horizontal lines, or some other way to break it into sections more clearly. TIA, Graeme
Zoho Creator says, "You are not allowed to view/edit script"
I am the admin on my account. When I try to view/edit script I am unable.
How do I view submissions to a form I have created?
Hi, I created a form under the creator application. However, I am having trouble finding the submissions or completed forms. Can someone please explain to me how I view submissions and how I can export them to excel?? Thanks. Anne-Marie
Two script left (If field_1 is greater than field_2) field_3 = a numeric data
Here is the concept and below is my script. If the sum of total points for Blue Team is greater than the sum of the total points Yellow Team then the Yellow team gets 0 points and the Winner is Blue and receives 1 point If the sum of total points for Blue Team is less than the sum of the total points Yellow Team then the Blue Team gets 0 pts and the Winner is Yellow and receives 1 point here is the expression I wrote Mission_Score_Card > b_g1_wins > On User input if (input.b_g1_pts < input.y_g1_pts)
The code looks correct...
Can anyone tell me why this code isn't working as expected? //1. User Clicks Log Button. //2. Does ID Exist in Log? if (count(tblEventLog[intEventID == input.intEventID]) > 0) { /*2 - Yes 3. Open Log View.*/ openUrl("#View:vwEventLog?intEventID =" + input.intEventID + "", "popup window", "height=100,width=100"); } else { /*2 - No 4. Add Initial Record.*/ insert into tblEventLog [ Added_User = zoho.loginuser intEventID = input.intEventID strEventStatus
Irregular line spacing in Note fields
In my forms I always comment on what the user is supposed to enter in the fields by including a short text in a field of type Note. These comments are displayed with irregular line spacing. It looks quite ugly. Support has edit access to my app. I use Firefox 3.5.8. Regards, Filip