Error occured while executing on user input script
I am inputting test data into the following form https://creator.zoho.com/essistmgmt/assets/#Form:AGREEMENT and it suddenly closed with the error message above. Can I get more information on the error details to understand the cause?
Just build a database from Google spreadsheet
When I try to edit a record - I get this error No rows found for the table CustomerDatabase in this DataObject
Field Placement
I have a two column form. I have dragged the fields to the desired positions on the form. When I view the form the fields have moved all by themselves. They change positions. They change columns. I end up with the First Name and Last Name fields nowhere near each other. I've moved them multiple times. They keep moving back. What's going on? What am I missing? --DJ
Link to EXCEL - Problem with multiple line fields
I was able to link a view to Excel by using both Excel's Web Data Query and Zoho html permalink . This is very handy because I can build a lot of reports in Excel and then just refresh the data. The issue that I have is with one text field in Zoho, which has multiple line. This field gets broken down into multiple rows in Excel. Any suggestion on how to fix this? thanks
Expert in Zoho Creator required!
I have a small project (10-20 hours) which requires some quick development, and ongoing developments as I no longer have time to do it myself! If interested please contact me via email: ashley@elprofesoringles.es or +34 633188512 Thank you, Ashley Williams
Display the position of the selected radio item
How can I return the position (0,1,2,3,4, etc) of the selected radio item?
Back ups suggestions
I have 3 main suggestions for back ups automatically delete oldest when you reach the limit of back ups have more than 3 back ups per application rename back ups I have an application which I want to back up regularly. When I go to back it up, I see the following message, "Already three backup's for this application assets is present. You are allowed to have only three copies" I always have to delete the older back up before I can click the back up button. Can you automatically delete the oldest
How do I change a number field to text field?
I've a field called student ID, which is mainly populated by numbers. One new ID contains a letter to cannot be entered. How do I change the field type? Thanks Mel
All fields do not show up on the screen in the Chrome browser when using new Creator Builder interface
Chrome browser does not appear to be compatible with the new builder in Zoho Creator. The screen ends on the icon File Upload field. There is no way to access icons below File Upload. No such problems existed in the old builder, which was a better product on many levels. I support opinions expressed by other Creators users that the best decision Zoho could make is to scrap the new builder and return to the drawing board.
Can't duplicate application
Hi, I am trying to duplicate an application. When I click on Duplicate it says 'Duplicating, please wait.' After a few seconds that disappears but the application has not duplicated. Please help- thank you!
Creating A SAS using Creator
I'm developing an application for a client Creator and it's going well. I'm now seeing opportunities for create specialised apps which could be sold as SASs (Software As a Service) - like Zoho itself does with its Business Apps. I may have missed the obvious, but I've not seen a way to do this. I know I can create an app and share it with people who have a Creator account, and I could do things such as using filters so that users could only see the records which they personally added - but that's
Schedule Delete Based on Date
I am building a property management app and need to run a scheduled script once a week to delete records. I need to delete records that are older the 14 days and status is set to "rented". I would appreciate any help. Thanks, Aaron
Just shows Processing on website - Please Help!?
I've created a form through Creator but on the website it just shows "Processing" and doesnt load my form unless i sign back into creator and "save". But again a day later it returns back to "Processing"? Can anyone help?
Merketo Form Submission Error
Merketo form validation not working with javascript function in submit button tag
ZoHo Creator is down for us--anyone else experiencing problems?
We can sort of see parts of forms, reports and views, but in a janky format, cross-browser. Clearly, something is down and has been down for over an hour. Anyone else having issues?
Portal site login issue
After I login, the header is repeated in the loign box area. I contacted tech support a couple of times, but no response. Is the portal feature still beta?
Check for conflicting dates
I am trying to create a form that will double check whether or not a person is already scheduled for a shift that is in conflict with another shift that I would attempt to assign the person to. I.E. PersonA is assigned to Shift1 from 7/1/2013 to 7/7/2013. If I tried to schedule PersonA for ShiftB that is from 7/3/2013 to 7/10/2013, the application will tell me that those dates are unavailable. on Validateif (Shift[ID == input.Shift && Shift_Start_Date <= input.Assign_End_Date && Shift_End_Date ==
Having problem with getYear()
Hi, I want to define a function that returns the no. of row count where the year in A_Date (Date field) is equals to the current year. I tried using getYear() but upon saving, I'm getting undefined and null. Is there something wrong with my codes? Here's my code : int Calculate.AttendanceTotal(int empID) { yr = zoho.currentdate.getYear(); c_VL = Attendance[Employee == input.empID && A_Date.getYear() == yr].count(); return c_VL; }
Margin problems when saving HTML view as a PDF
I have an HTML view that I have enabled the "PDF Header" option. As I expected, the PDF goes over a number of pages, but the problem I have is no margins (top, bottom, right, left) at all on the page. Any ideas how to set the margins?
Null to Zero - can't seem to ge this to work.
I am having difficulty converting null to zero. I posted this question yesterday and was given a response but I cannot get it to work. In a nutshell I have a formula field (InsertCost) that contains 2 fetched fields (decimal) that I need to divide.I have set the input.pubcost and input.allocation default values to 0. But my formula keeps coming up with NULL. (input.pubcost/input.allocation) If the fetched fields contain data there is no problem but these fields often they will have no value and
Show additional fields after radio button selection
Hi Everyone, I am trying to make 4 extra fields show when one of my radio button selections is made. It is actually for Credit Card information. This is what I have been trying on user input: if (input.Payment_Choice == "Paid by Me") { show Credit_Card; Card_Number1; CVV; Expiration1; } else { hide Credit_Card; Card_Number1; CVV; Expiration1; } Keep getting error message on line 1, not sure why. Your help on this is much appreciated!
Annoying Code Comment issue
Hello, Let me start by saying the Creator application builder system and deluge code are absolutely amazing. I have been able to build an powerful application from scratch in less a month. My question is related to being able to write comments in my deluge code for readability. When I write a comment right after an "IF" state state the IF statement somehow absorbs the comment to within the "}". this is very annoying and makes commenting code with a lot of conditional statements hard. For example
Delete Forms
How can I delete a form? ismael1127
Unexpected error due to improper script.
I am trying to view my scripts under https://creator.zoho.com/essistmgmt/assets/edit/function/ Sometimes I get this error. When I refresh the page a few times, the error message goes away and I can see my script code. Can you please investigate why I am seeing the error?
Passing forms as parameters
I have found the help page at https://www.zoho.com/creator/help/script/form-objects.html#Adding_form_object_as_argument_to_the_function and tried to replicate it but am experiencing difficulties I created a function that has a form as an argument When I execute the form via the script builder and randomly select an ID, it works as expected. When I try to insert it into the form actions by calling the function and passing input.ID, I get the following error message. Why is it not working as expected
Linking Fields in Creator to Fields in Project
Is it possible to get data from Zoho Project (let's say a start date) and display it in a Creator database? They would have to be linked by a common record id or number. Something like a join.
Creating a HOME button in Views/Reports
Hi I've been trying to create a link to HOME in Reports/Views, after countless user requests. Have finally found a way of doing this that doesn't require IFRAMEs or embedding. I've just sent a message to support to see it its okay, because it seems to break some unexplained condition in one of Zoho's Help pages. For the record, here's how (and this could be used to create a full Nav menu and other things) Open the relevant View and then * Click on Edit this application * Click Create New * Click
Custom script code disappeared
I was working on the following function udf_generateids.convert_numeric_to_alphanumeric_code and when I opened the function, it ended up seeing string udf_generateids.convert_numeric_to_alphanumeric_code_896426000014261704(int value, int digits, string code) { } My code disappeared. I never created a function with the name convert_numeric_to_alphanumeric_code_896426000014261704 with the random number. The other big issue is that all my script logic has disappeared. There is nothing in the version
help
the link i use to edit my webpage has gone! and i dont know how to do it any other way ... please help??
Multiselect lookups in new builder
I tried creating a multiselect lookup in the new builder but I could not find an option to change from single select to multi-select. Herb Wexler
Power of caret
Zoho creator appears not to support using the caret "^" as a power of When I try and runs this test code below int temp.temp13() { return 2 ^ 4; } I get the following error Lexical error at line 2, column 10. Encountered: "^" (94), after : "" How can I get the power of a number?
Unknown variable causing script error
I want to update the following GLOBAL_SEARCH html view located at https://creator.zoho.com/essistmgmt/assets/htmlview/GLOBAL_SEARCH/edit/ However, I am getting the following error message Error at line :2 The variable 'd' cannot be accessed at this point. There is no reference to variable d in the script. Can you please help troubleshoot? Thank you
File upload: action on the user input
Hi, I would like to set up script that after file upload other features would appear. Which variables i should use in the script formating (e.g. "If" input.file upload "then" show field) thanks, r.
Questions to integrate paypal with zoho.
1. Do I need to setup the paypal developer before I could integrate with zoho? 2. I followed the instructions in https://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form How can I configure the submit button so that it will linked to paypal website to make payment? 3. Can anyone please provide a step to step guide so that i could follow? THANK YOU!!!
Error Assigning Null to a Date Field in a Subform
Hi, I have a working script. It works great! The problem is now I want to edit it and I cannot. I can't even save the script without making any changes. I receive the following error message: Expecting TIMESTAMP expression found NULLTYPE expression Below is the code the generates the error: //Alert if the Move Out Date is not after the Move In Date if (row.Move_Out_Date < row.Move_In_Date) { alert("The Move Out Date cannot be before the Move In Date."); row.Move_In_Date = null; } I
Trimming field values
How can I make a form automatically trim the leading and trailing spaces of a text-string? I wanted to do this to avoid duplicate entries. Thanks.
Creator down
Hi, We're currently looking into service interruption issues with Zoho Creator. We'll keep you posted about the status. Sorry about that! Regards, Mani
API Edit Multiline via XML RPC
I'm trying to edit a multi-line field via the XML-RPC API. When I ADD a record, the format is: <field Name='myfield> <value> the value which can be multiline </value> </field> However, in the EDIT spec, I have to format it like this: <field name = 'myfield' value='some value'></field> This format, where the value is a parameter of the field node, and not a separate node, doesn't seem to support multi-line. Any suggestions on how to work around this problem?
Excel / Creator integration
Wondering if it is possible to create an excel page that takes the data directly from Creator? or any other suggestions to this question... I want to print ID cards from the database collected through Creator. The data is already in Creator but I need it to access it live, print a single small id card customized to a certain look with graphics etc. Thanks in advance.
Bug in Usage Limit and Buying Addons
We're on the Professional plan, which gives us 20,000 records. Today we received an error staying that we've reached our limit, and the dashboard indicated that we'd already exceeded our limit by 1,194 records. So we bought an addon for 5,000 records, but now for some reason our dashboard says that our quota is 40,000 (instead of 25,000) and that we have still exceeded our limit by 1,194 records. In other words, there appear to be 2 bugs: 1. We bought 5,000 additional records, but the dashboard indicates
Next Page