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
new form field doesn't appear as a column in views
I hope someone from support can can help. Using the new builder, I added a new email field to my form. I want this to appear in all my views. It appears in one view but not in any of the others, even though I went through each view to make sure the new field has added (through column properties). Everything checks out fine, even using the old builder. I'm not sure what's going on. I've already provided support access to the application. Thanks very much for your help.
Decisiion Box Values
Hi all, Am a complete beginner to Zoho Creator. I would like to make a form that has a persons name and then a list of Decision Boxes: Item1 Item2 Item3 Item4 Item5 Each Itemx has a value. Depending on what boxes have been checked a total should be displayed I can set the form up with no problems but I cannot figure out how to display the total How can I go about doing this? Cheers Rich
Auto populate Fields - between 2 Forms
Hi All, This questions has been asked and answered in past. I have used same logic given in those post. But it is still not working. I have a form called Employee and has below field. Form Name: Employee Employee_ID = Auto Populated First_Name Last_Name I have created another form called Tour Plan, which has following fields. Employee_ID = Lookup Drop Down list from Employee.Employee_ID First Name = Should be populated with First Name from Employee form based on Employee_ID Last Name = Should be
Password Input Field
Suggestion: Password Input Field Purpose: A standard password field Motivation: There are instances where a form can be public, but locked by a password. Also, this would allow custom authentication schemes built inside ZC. As an alternative, have a Zoho account sign-in box right on the form. People are simply used to typing a password that appears obfuscated as asterisks. Example: A self-serve membership application. The user types in his email for a user name and then obfuscated password. Implementation:
Performance issues possibly related to GApps integration
I am wondering if any users of large applications are seeing performance issues in Creator, possibly related to integration with Google Apps for Business. We have a large application (almost 2.5mb of code), and our sharing is based on groups created in Google Apps. We also import Gmail addresses and usernames into several forms. The application's owner/admin virtually never sees performance issues, and for him the application works quickly and flawlessly. But normal users constantly contend with
editurl with default value which requires login first.
I'm able to edit a record using an url like this: https://creator.zoho.com/abc/def/hij/record-edit/Viewname/956669000000620003 When navigating towards such url when I'm not logged-in, zoho navigates me to a login page first and thereafter the record edit is accessible. So far so good. However, I want to edit a record an set a default value for some field, the url looks like this: https://creator.zoho.com/abc/def/hij/record-edit/Viewname/956669000000620003/somefield=hello (I've tried the url like
Can you move zoho creator to zoho recruit? Would notes still work?
Can you move zoho creator to zoho recruit? Would notes still work? We have a lot of records in creator so not sure if it would be worth the effort.
Two Major Issues/Bugs
Hi, I'm facing two sensitive problem in the application. 1. Application is very slow when subform contains around 50 Records. I have 1 Parent form record, which have 210 records in subform. It is fetching 210 records out of 400 records when i click on edit. It is taking around 3 - 4 minutes to open when i click on edit. (I'm using 2Mbps Speed net) Now per month i have to enter some 1500 records into that subform. what if that has to fetch from 10,000 or 20,000
InBuilt functions for Oauth parameters?
Hi Are there any inbuilt functions/ supported libraries for creating the oauth (hmac-sha1) signature and other oauth parameters like nonce, timestamp in deluge script?
Next Page