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
Uploaded File Validation
Is there any way to validate a file-type and size? I'd really like my users to post only PDFs, JPEGs, or Google Docs under a certain size. Cheers, John Whitney
automatic updating of database from external link/spreadsheet
I am new to Zoho, but am very interested in Creator. I have forms being submitted via another service which updates a google spreadsheet in real-time. I believe I saw something mentioned in a forum about the scheduled updating of a database from an external link/spreadsheet. Is this possible, and if so how, because that would be awesome?
5 FORMS INTO 1 REPORT
I have created 5 forms that are all linked together by one common reference number. I need the output results to all populate into one report. I do not want to look at 5 different reports when the forms have been completed. Can someone tell me how to merge 5 reports into one easy to read report?
populate form via email
hi there is form on website which takes from user name phone city email form sends email notification, it is possible to customize notification how can i populate creator's app via email from web-site form?
Field Types
I had an application running on the old Builder Platform. Now when adding items to it, such as a lookup field, when I start to write a script, that field, gets a field type change to an Integer. I wanted it to stay as a string. Can I change it at anytime?
importing data to a subform from the main form
Hi, I saw this forum https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095 and I tried using the steps but really it doesnt work for me, I don't know if the title on the spreadsheets are wrong but is it already the same with the link view name. I have allowed edit access on the application named SAMPLE. Please help this is urgent thanks.
Upload file - Creator API
I am trying to send a file to the creator using a java code through the API creator as shown in the link: https://www.zoho.com/creator/help/api/rest-api/rest-api-upload-file.html # http_method But all attempts are returning 500 error. see the parameters sent with POST: Url = https://creator.zoho.com/api/xml/fileupload/ applinkname = XXXXX FromName Requisi_es fieldname = teste_1 recordId = 836809000002270003 " filename = filename.pdf scope = creatorapi and the file ... tried to send with Content-Type
Dropdown dependent on dropdown? How ?
Hi Just make new form. Logic is next: 1 dropdown - choice of city , 2 dropdown - choice of firm in this city. How to make this logic and how upload to creator those dependencies "city-number of this city's firms" I have about 90 cities. In each city form 40 to 2000 firms. Thank you.
Lookup Issue with New Application Builder
By default, the new app builder uses ID numbers for lookup fields. You can select the display name however. I have a lookup filed type using checkboxes, so the values entered are a list. This is how it appears in the Report view: But this is what happens if you email this field: Is there some new deluge aspect to get this to display names rather and ID numbers for sendmail? Very Frustrated with the New App Builder, John Whitney
Dynamic View
Hi I have a number of Stateless forms that hold information for engineering configuration. The Current Config ref is stored in a variable that is global (via a table). One part of the config is a set of Widgets, Each Config can have up 10 Widgets each widget has 5 parameters. I was going to code this as 10 static sets of data in the main table but thought I would be knocking on the limits of Zoho and fields in Tables. So I was looking at a Master-Detail set up just for this part of the config
Another backup error
New app, built from scratch, backup is successful. When restored gives error: "java.sql.SQLException: BLOB/TEXT column 'Descriptio_1388351000001002559' used in key specification without a key length"
In IE, record edit link triggering reload to home page
If one clicks on the gray Edit button, no problem, but should one click on the Edit row of the hover menu, then the link, instead of opening the record for editing, triggers a re-load of the home page. If this in not a common problem, let me know and I will open a support ticket. Thanks,
Newbie design question on code vs description in Dropdown/Lookups
Hi everyone, I am new to Zoho Creator app builder tool and this forum. I weren't sure if my previous post got through. So I am going to try again.... I have a simple question. When you setup the Dropdown/Lookups, can you setup a dynamic lookup list where it can display a description value on the Dropdown, but store a code value into the Form record? For an example, if I have a US State setup Form, the Form will have a CODE field and a DESCRIPTION field. The CODE field may have "AL" and the DESCRIPTION
HTML View, Populating a table with fixed number of columns
I wan to populate a table with fixed number of colunms with records from a form. The idea is to display an iframe (in a zohosite) with products that belong to a selected category in a 4 columns by unlimited rows table. the question is this. I can have the records to display in a collection variable like this: Products_to_display=Prdoucts[Category==input.Category]; now I need to populate the table, one product per cell (say the product name for now), with the condition to have only 4 columns. I
pivot table report window in Chrome not working propperly
Hi have you noticed that when using chrome a pivot table report's window does not allow you to get to the bottom? it keeps returning you to the top? This does not happen in Explorer. Any advice on how to fix this? I'd like to use Chrome. Regards Luis
Encoding a string in a HTTP Post
Hi, I'm trying to use the Google API for adding placemarks on maps. The HTTP body needs to have the following: <atom:entry xmlns='http://www.opengis.net/kml/2.2' xmlns:atom='http://www.w3.org/2005/Atom'> <atom:title type='text'>Faulkner's Birthplace</atom:title> <atom:content type='application/vnd.google-earth.kml+xml'> <Placemark> <name>Faulkner's Birthplace</name> <description/> <Point> <coordinates>-89.520753,34.360902,0.0</coordinates> </Point>
copy formula error?
hi there is working code in creator 1 filed - formula field, calculation works well try make new formula field (new builder) just copy code of old formula in place of code of new formula builder says "Expression not supported in forumla" how copy code of 1 formula to code to 2 formula?
Data format errors: Enter a valid date format
Under Applications Settings, I modified the date to dd-MM-YY format When I load the form, the date fields still show the old format. Also, when I select a date from the date picker, it shows the old format. When I submit my form, I get an error. When I change the date to '07-07-13', then it works. The date format specified in the form and the date picker is not in sync with the application setting.
Newbie design question showing description but storing code value on Dropdown/Lookups to
Hi all, I am new to the Zoho creator app builder tool. I have a simple design question. I came from an Oracle development background. In many Oracle typical screens, there is a List of Value widget like Dropdown that is based on a SQL query or dynamic query. Typically, there is a code and a description value where you want to show the description on the drop down but physically store the code value. How do I set this up in Zoho Lookup or Dropdown form widget to do this? For an example, if I
Updating a field
Hi Could you help please -- I am sure this can be done.. I have a Form = Clients that has a field = HealthPlan - Yes/No When the Client Purchases anything : I have a Form = ClinicalDetail ( like Invoice Detail) - I have a Field = Discount in a subform called Rows ( main Form is the Clinical ( like Invoice) - which holds the Client ID I would like Clients that are on the HealthPlan - to get a 10% discount - so that this applies automatically. So I would apply script to Form = ClinicalDatail
Issue with saving scripts - new creator script entry
Hi all I had an issue when updating the form scripts ("workflow") for an existing customer. Their database had been created using the previous generation of the Creator design platform. I needed to add some script lines to their existing code. I was able to paste them (using the freeform scripting interface) and save it into the On Load script area, and it "stuck" correctly (it was still there and working when I looked later). However, when I also pasted into the Validate area, and did a Save
Posting to Database
Ok, forget about my last post. All I want to know is if it's possible to insert a record into a Zoho form, from an external website, without forcing the page to refresh? I will learn any language I have to, I will do whatever I have to...I just need a way to submit a record into the database, without a page refresh. Currently, the only method you have listed is submitting a form. That refreshes the page. I need my plugin to execute onLoad. So if it automatically posts, then refreshes, the user will
Ajax, Json & adding a record.
I'm currently trying to test to see if I can come up with the code to add a record to the database. This is what I have: $.ajax( { type:"POST", url:"https://creator.zoho.com/api/c.mart6780/json/boxoff-mw/form/Stats/record/add/", data: { authtoken:"<MyAuthCode>",scope:"creatorapi",UserID:"56464",MWName:"Test",Attack:"980" }, contentType:"application/json; charset=utf-8", dataType:"json",
Report based on drivers name
I am trying to create a database to track loads run by my trucking company. I am hung up on generating a report for the driver's payroll. My trucks typically run with team drivers so I have fields for "Driver A" and "Driver B". I also have fields that indicate the number of miles the load is and the rate per mile each driver is to be paid. I need a report that will pull the pay details for each individual driver whether they are listed as "A", "B", or both. (A driver may be listed as both if
Error while duplicating Records
In my app one of my forms gives me this error when trying to duplicate a record: "Error while duplicating records". All of my permissions are correct in the app for allowing duplication and even as the app owner I cannot. As additional information this form has a subform associated with it and does a lookup to my zoho crm onLoad. These are more sophisticated elements and I wonder if they are causing this error. Other forms duplicate records fine. Please advise.
Application for Zoho creator
Hello Friends, I will like to know if there's a mobile app for Zoho Creator or an Andriod Mobile app that will allow me access my developed forms directly. If there's none please when can we get one?. Thanks Presoft
Serious Subform Namespace Error
I found a serious error that caused my application to loose a significant amount of data. Zoho is unintentionally causing a variable that was pointing to a subform to now point to a form instead. Here is how it works: Let's say we create two forms: Books Pages The form Books has a subform that is called Pages. Notice how the subform Pages in Books has the same name as the form Pages. Let's now say that when you delete a book you also want to delete all the pages. One way you may want to do that
Next Page