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
HTML views
Hi Zoho, I was wondering if you have some information on how to create html views. I have read this article: https://www.zoho.com/creator/help/views/create-html-views.html I don't find it that useful. I am looking for some more detailed information about how to insert deluge queries into the html code. For example i would like to create a table. In that table I would like to get values from one of my forms. At the top of the table I would like to have a user defined field where the user can choose
Views: Is it possible pull a value two tables away?
I've searched as best I can, but I'm falling short on terminology. Forgive me if this sort of thing should be easily answered. Here's a description of my project: We are using our Zoho Creator database to record interactions with school groups who visit our institution. Each Interaction is tied to a School. Each School is tied to a School District. Interaction --> School --> School District Our institution receives tax support from a given region, and schools belonging to districts within that
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
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
No <return> allowed in message body of scheduled report
When you create or edit a report schedule (under workflows), and would like to modify the message body of the email message such that something meaningful is added to the report attachment, then you cannot use a <return> to start a new line. If you do, you will get the error message "Error in scheduling parameters: null", which is not telling you what's wrong...
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
Multiple Criteria
If I want to set a view criteria can I use multiple fields to set the criteria? For example: DATE1_Drop == something; DATE2_Drop == something
Auto fill a field
Hi! Here is my situation: 1.) I have a Dropdown field called Property Sub Type & Description with several choices (e.g. 105 Commercial Real Estate - Retail, 107 Commercial Real Estate - Lodging/Resorts, etc.). Next to this field is a field called Property Sub Type. What I want to happen is have the field Property Sub Type field auto filled with the data being put in Property Sub Type & Description field but with a bit of modification. E.g. If user chooses "105 Commercial Real Estate - Retail" for
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",
Adding a additional field in subform
Hi All, I am developing Tour Plan application for a Pharma company for MR. I have 2 forms: Employee: Employee ID, First Name, Last Name, Location etc... Leads: Company Name, Contact Person, Lead Type, Phone, Address, City Now i am creating a form called Tour Plan The First column will have drop down menu to select the Employee First and Last Name. Once selected, it will fill all other information from the Employee table. The second part is to add Leads. I am using subform. The first column in subform,
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
How about a India phone number for Zoho creator support?
Or do you just not care anymore? Varun.
Support page not opening!
I've been facing this problem since two days. Any one has an idea? Varun. Note: I cannot locate the link to the support page on the new builder. But a search threw up the support page and THIS page seems to load alright.
Concatenating strings in formulas
Hi there, I have created a simple formula in a form that concatenates a field with a literal eg email_id + ";". However when I view this in a report the field is blank even when the email is not. Any ideas ? Thanks
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.
What's going on with the login? Where are usernames?
I have 75 users created with username and password. Suddenly I am unable to create an account with a username, apparently I MUST use the email address. This has created TREMENDOUS confusion. What happened to all the accounts created with usernames? How do they log in? Do I have to tell everyone to use the email address to login? Also when I try logging in with the email address, Zoho creates its own username which has nothing to do with the email address. What in the world is going on?????????
How could you change Font Name and Font Size in ZOHO Creator Embeded View?
How could you change Font Name and Font Size in ZOHO Creator Embeded View? Thanks.
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
Formula field on form not working
I have a form where users enter the amount of work they have completed. Each type of work has an RE. E.g. An 'Enquiry' has an RE of 0.5 and should take 30 minutes to complete. I need the formula field to calculate the users output based on the RE, based on the number of 'Enquiries' they have actioned. i.e. 2 'Enquiries' should return "1". My formula field (I've tried differences in the formula, but I'm more used to Excel): (input.Enquiries * input.RE_Enquiry) Error: com.adventnet.ds.query.QueryConstructionException:
I want to duplicate an App but its not working
Hello Friends I have been trying to duplicate an app but it loads then returns back with nothing, i tried creating a fresh form and duplicated it, it worked, but each time i try to duplicate my already Coded form it won't what could be the cause?? Thanks Presoft
Creating a Group is Broken
I have started to create groups under my other account "sigroup", and when I select to add members, it's not showing any. I have almost 50 users under this account. When will this be fixed? Cheers, John Whitney
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
Sorting within report
Hi, Been trying to sort by the Make in ascending order. doesn't seem to be working
Manage Users isn't showing admin name
Please see this screen shot: http://screencast.com/t/aDPlj8mmiGPZ My user is showing null
WordPress plug-in
If you guys would write a WordPress plug-in to allow me to embed these forms into a WordPress blog, all my worries would be over. Are you working on a WordPress plug-in? If not, why not?? mmcadams
Sum Enabled Formula Column
Our company manufactures a product that is measured by pounds. In my form, a user can insert the total pounds of an order and the price per pound. Then there is a formula field that calculates the total value of the order. What I want is for that formula column to display the value of each order (which it does) but also the sum of all the orders at the bottom of the view, so that we can see the total value of multiple orders. However, the "formula" field doesn't currently support the "Sum" function
Next Page