error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
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
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?
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
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.
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()
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
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
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
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">
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/
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
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
Deleting fields from forms
Application: essistmgmt/assets/ Form: PRODUCT I want to delete the following fields PRODUCT_CODE_PHASED_OUT SERVICE_CODE_PHASED_OUT However, I am getting the following error message This field is referred in the following places. Please remove them and then delete this field. Functions 1. udf_product.get_product_service_id_896426000011845953() 2. udf_product.get_product_service_id_896426000012564478() I did not create the functions above & I cannot find them when I view the udf_product namespace.
What programming language
I am looking at Zoho for my on-line database. I currently use Access and programme quite heavily in VBa to achieve input validation on controls. What is the programming language that I must use in Zoho to achieve the same? It looks like C. But there are many variations. Which one does Zoho use please?
Create report within the Zoho Creator
Good morning, Some fields I created in Zoho Creator does not appear in report generator, I need these fields to set up my report. They are fields of type Currency. Thank you!
sendMail question
I have a field called input.Stakeholders in the active form. It's selecting the names of stakeholders from "New Stakeholder" via a lookup. I wish to get the email addresses associated and map them to the "to" field in the sendmail function. Any help is greatly appreciated. if(input.Job_Status == "Shipped") { sendmail [ from:zoho.adminuserid to:(NEED HELP) subject:"Job: " + input.Job_ + " has been shipped!" message: "test" content type:HTML ] }
internal execption error. Please help.
My scripts are suddenly failing today and I am receiving an "internal exception" error. These scripts normally run fine. I do not know the cause of the error but this has occurred before when you guys have pushed new updates to production. Please help me troubleshoot this ASAP. This is a very serious issue. Suddenly all of my URLget and URLposts are failing. with {"responseCode":"-1","responseText":"internal exception"} This occurred several months back due to mishandling returned results. https://help.zoho.com/portal/en/community/topic/internal-exception-for-creator-function
Prevent on user input calculation for null case is failing
I have a dropdown list with years in it. When a user selects a year, the code converts it into a number, and then does a calculation. However if the user selects "-Select-" from the dropdown, the form throws an error. I have tried to prevent this using the following code if(input.HSGY == null) { //nothing } else { n=input.HSGY.toLong(); input.Grade=thisapp.Grad_Year(n); } It's ignoring the null case (which is "-Select-") Cheers, John Whitney
How to parse a response from Creator API
I want to build a related list function in CRM to access a view in Creator. I have successfully linked to the Creator API and got an Authorization code and have also passed back the view in question with a number of records using PostURL How do I now parse this XML/Map to extract the data in the records so that I can show it as a related list.
Disabling fields on subform - zoho script isn't working!
My subform field is Students the subform's fields are Student, Status, Type I want to disable editing Student and Type on Form Edit So On Edit Code is something like this disable Students.Student; disable Student.Type;I save script with no errors, and the behavior doesn't result as expected.
need help, how do I add a link to email instead of print the view?
where it says "EDIT PRINT DELETE" is it at all possible to say "EDIT PRINT DELETE EMAIL" and configure the email to send to email address associated with this record? or can you suggest a way I can have this record's view emailed, when the user clicks on something on this screen?
How to change copyright information on pages
Dear Everyone, How can we change the copyright information appearing at the bottom of pages "© 2013 ZOHO Corp. All rights reserved." to "© 2013 My Company Name. All rights reserved.". Thank you. Kashif
Next Page