API is not working
I was create a function in creator script. This function is getting the data from Reporter. Function was working fine before few day. Bur when i am running today then raise the following error :- Execution Failed Error details: Error occured while executing the script. In the subString function start index should be less than end index Log messages: There is a function details :- void special.ramesh_test() { ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=&PASSWORD=
Saving Record Freezes ZohoCreator into Saving.....
I am copying some blocks/paragraphs of text into some records in ZohoCreator. On about the first 10 fields, everything goes well. Then at some point, when I paste and hit "save", Zoho just gets stuck on Saving.... Seems to happen alot. These records are for the most part about 400 words worth of stuff. An average word is mabe 5 characters, so the entire text is maybe 2000 characters. At first this was just annoying. Now its becoming a show stopper. Does anyone else have this problem? Where Saving
Cannot delete Application
Hello I am testing Zoho Creator and everything was going fine but, I have copied two applications to "My Apps" and now I want to delete then but I cannot do it. I can disable but I delete then are impossible. I want to create an application to show to my boss so he buys a subscription. In the free edition I can just create 3 applications. Any suggestion will be very appreciated. Best Regards, Borys
buttons do not function in embedded data view page
I've created a form with data view and want to embed the data view into my webpage. The data view form is displayed correctly on my webpage, but when I click on the buttons of the data view form on my webpage, none of them work (The buttons are for printing an entry of the form). The buttons work fine within creator. Help?
Solution Search Component
I have modified the Solutions view so that it contains the following fields Title Description Content By default the Search mechanism for solutions on all pages uses the input.keyword variable to search inside the 'Description' field. I want to make this more granular by searching only the Title and/or Content field. How can I change this? I've tried looking in embedCompInSolutionsPage(); but no success yet :-( Thanks for your help! -Jaap
Date and Timezone
I have a date-only field and need to convert it to a date-time field. In this conversion, the date-time ends-up at 03:00 hrs. I have the time zone for my application set correctly. Example 18-Aug-2011 converts to 18-Aug-2011 03:00:00 rather than the expected 18-Aug-2011 00:00:00
What's the best way to prepare this report?
Hi All I have a Form used to add entries in a sales organization (leads to clients), let's call it "Leads". One of the fields is the name of the sales person in charge of the lead. That name comes from another Form and is automatically populated on load. Let's call that second form "Sales People". In "Sales People", additionally to names of my sales people, I have another field that says in which branch of our company they work. I want to create a report that looks like: August-2011,
Filters removed from views
This morning I have found out that all view filters that reference fields that have more than 100 values have been removed. How can this happen. This has a massive impact on my application and I am sure it does on others too. This change has to be reversed and any such future major changes must be analysed for impact and communicated before simply being released. Who else is affacted by this?
Updating Application for Client Not Working
I have made changes to an application that I have published to a client's account. When I make changes and republish and upgrade on the client account, the changes are not showing up. Is there something else that needs done? Bruce Letterle Creative Web Technologies
Inserting data got from Creator application into CRM
I got data from my creator application(getleadsfromcrm) through api .Then I want to insert them into CRM by insertRecords(CRM api method).But their xml formats are different. How can I achieve it.please help me .Thanks !I tried it as follows: first:I get data from creator application getleadsfromcrm, thisurl = ("http://creator.baihui.com/api/xml/getleadsfromcrm/view/leads_view/apikey=2e16c27cff734a56b029f35e616f0008&ticket=2b3c5bb3e29bb7309af75a40d5794a82"); getXml = map(); str = postUrl(thisurl,
Emergency> G Apps Users Field Not Working
Cannot See the G Apps Users Field while I am opening the form to add G Apps Users HELP! Critical! Regards Andrew
Announcing: Zoho Creator for Google Apps
Zoho Creator, is now available for Google Apps. Install it into your Google Apps Domain today and let us know how you like our Google Apps specific features. Zoho Creator has 4 new enhancements for Google Apps Users. Universal Navigation: Once Zoho Creator is installed in any Google Apps domain, users can access it right from the universal navigation bar in Google Apps. G Apps Users Field: Users in a Google Apps domain, can be added as one of the fields in Zoho Creator forms. This field provides
Need help with On Edit - On Load criteria scripting
I've implemented a criteria script where my selection of dropdown1 filters the possible selections of dropdown2. I am trying to create a script for the On Edit - On Load condition that behaves as such: I would click edit for a record that had been previously created. That record would open with my earlier selections still intact. My goal is to change dropdown2. If I open dropdown2 I see every selection, even those that do not match the criteria as determined by dropdown1. The only way to have dropdown2
Do not upgrade for the payment module
Hello, We have upgraded to the professional plus plan on August 17th. However we are yet to go ahead with a working model due to: 1. Lack of clear documentation which could enable us to proceed faster 2. Issues with the Zoho payment module for which we are awaiting a fix. We request you to fix these issues as soon as possible or give us a re-imbursment. Thanks
combined view
Some body asked this in the user guide, which I think is exactly what I need also. Does anyone know if its possible? "Can you or can you not have a form with one to many relationship. or in other words, with (one row)parent as the header and the many rows as the body/child rows below. The best example would be an Invoice form in Zoho Invoices or Books which has the customer info as the header and the items as the body. Can this type of form be created in Creator?" also, on a similar note, if you
Hide Views in Menu Drop-Down List
I have an application where I've created a number of views to provide a data set for some reports. I do not want the views to be an item on the View drop down list as that information will only be used in their report form (Chart). How do I restrict the appearance of table views in an application without denying access to that data or associated forms. I've tried playing with the user settings but that just blocks complete access to the table and all associated forms/tables. Anyone know if this
Discounted monthly fee for Non-Profits
I am so excited for new payment option you've added to Creator! I began to set up a new Membership application form for one of my non-profit clients. But, when I found out the minimum account to access this feature was $100/month, I abandoned it as I know they are on a restrictive budget. Please consider discounted membership fee for non-profits. We have found many online services that provide such discounts. Thank you!
view option broken for form in view mode
Currently my links to other forms do not work in only one of my forms, but are fine in the others. clicking on the link begins to load the view but then the popup fails to open fully. Instead, the beginning of a popup is created. I've attached two images, one showing the normal viewing of a linked record and the second showing this bug. Please advise.
How do you show a field if a file has been uploaded?
Here's what I'd like to do: When a user uploads a file another file upload field appears. To do this I've created a maximum of 6 file update fields: Documentation Additional_File_1 Additional_File_2 Addition.....3 ....4 ....5 My current scripts... Form Action: On Add/On Edit - On Load hide Additional_File_1; hide Additional_File_2; hide Additional_File_3; hide Additional_File_4; hide Additional_File_5; Field Actions: Documentation - On User Input show Additional_File_1; Additional_File_1 - On User
Display a duplicate record warning next to the field
I am new to Zoho and coding in general. I am trying to keep track of orders that need to be refunded using a form. I would like to keep other employees from entering duplicate records. To accomplish this I would like to have a warning message come up next to the actual field saying "this order already has a refund on it..etc". I know that Zoho has an "allow duplicate entry" field BUT this displays only after the form has been submitted. I would like to code it where it shows up as soon as it is
Importing online forms to weekbly
Hello, I wna to be able to create online forms such as job application form, contact form etc and import the same onto weebly.com (free website hosting). I am not able to see/convert teh forms into HTML. Please help! Thanks and regards, Pallavi Prasad
Editing a Duplicate Entry
Hi Folks, I am a Zoho newbie and have a problem. I would like for my form to search for duplicate Order numbers on user input. If there is a duplicate order - i would like for the page to open in Edit so that they can simply edit the information as opposed to filling out a duplicate form. How can I accomplish this? Thanks!
How to dynamically populate picklist using displayformat
I created a stateless form with a lookup field that imports the ID value of the linked field but uses the Advanced Display Options to display another field (FullName in this case). This all works perfectly. Here's the script for the lookup field: must have Student ( type = picklist values = Students.ID displayformat = [ FullName ] width = 206px ) Here's the script for the Submit button: Submit (
Need help combining report with views please!
I'm a novice using trying to develop an internal database that stores all of the vendors we use. I've developed forms for our users to rate interactions with each company so I have the following tables: Vendor table: Vendor ID, various identifying information about each vendor, e.g. address, phone, etc... Vendor rating table: Linked to vendor table by Vendor ID, with ability to enter a rating and description of each interaction I've created a report in the form of a pivot table to report the average
can't edit view => " [ServletException in:/jsp/edit/view/viewedit.jsp] null' "
Hello. I have a problem with my app "CRM" in Creator. I can't edit view "NormSCommonOpenCalls", in new opened window appears message: " [ServletException in:/jsp/edit/view/viewedit.jsp] null' " When i insert this view in HTML-page in opened window appears message: "We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com " Than i create view with name "NormS_CommonOpenCalls". I can't edit this too. Deleting not available. Please, help
Google Calendar Rejecting iCAL Feeds
Here's an example of one https://creatorexport.zoho.com/niskypto/buzzable/ical/Buzzable_Events/EVENT_CALENDAR=District&DTSTART=EVENT_START&DTEND=EVENT_END&DESCRIPTION=EVENT_BODY&LOCATION=EVENT_LOCATION&ORGANIZER=EVENT_ORG&SUMMARY=EVENT_SUBJECT&ZC_FULL_DAY_EVENT_VAR=EVENT_DAY It's valid using this http://severinghaus.org/projects/icv/ And ZOHO Calendar can subscribe to it. Any ideas? John M. Whitney
Insert Image
I am new on this and was wondering if it is possible to insert an image on a send email function and that this image will be different depending on user input. Thank you
How to email everyone from an Application I've Created with an Email field??
I am using Zoho Creator for data entry to get away from paper based methods. I entered in all our patient's email addresses and phone numbers etc.. into a Zoho Creator Application and now am ready to email everyone a practice news message. How do I do this? How do I script?
Zoho Creator, Google Sites and my payment gateway
I have built a Zoho Creator app that I have embedded into a Google Site. I need to link from the Site to a payment gateway. I am not able to integrate the Site to the payment gateway. The payment gateway requires the post query to emanate from my website domain, but since the request originates from a ZC iFrame wihtin my domain, the gateway rejects this. Is there a work-around? I am in India and local regulations practically prohibit the use of Paypal. Please help.
Advanced Filtering in Views (two level filtering)
Hi, grateful for any suggestions here My issue, I have an Auto filters for Regions/Products/period/countries etc etc (all work well) Then i want to further filter this list for to only show a particular sales person in that region (over 500) Am i missing something ? in list view, this seems impossible to do at the moment Will I be spending all weekend writing custom filters ? which for all the variations will be many Thanks
What is the Default Font and Font Size?
What is the default font and font size when typing in an rtf box? I tried typing the same word next to other words (ex. the) and then changing the font and font size for it and it looked like Arial 10, but when I saved it that way, the rtf boxes did not match the drop down box fields in terms of font and font size. If I copy paste something in I want it to match the rest of my fields (ex. drop downs are in the default font and font size.) Thanks!
ACT to ZOHO
How do I transfer my ACT Database onto Zoho? Thanks! Jennifer
Generating a unique case ID #
How might I go about having a unique customer number emailed to my customer on submission of a form? I am needing to keep track of my customers cases by way of a 6 digit "case/customer number" which would be generated automatically and emailed to them at the time of form submit. I would also require that the case numbers progress by 3 digits with each new submission. Any help? I am grateful in advance!
Combining values from two fields into a third
I have a field called firstname and a field called surname. I want to set up a third field (called fullname) that combines the two. What is the exact syntax I need? This seems as if it should be very easy, but I cannot get anything to work, and theres no documentation I can find to help.
asign variable to link field
Hello, I need to know how assign a variable in a link field with 2 boxes URL & LINK NAME (I need put the link name). I tried to do: On Success input.link1 = variableURL In a view I can see the URL (without link name) but in plain text (cannot click) and editing the record the link disappear and the 2 boxes (URL & LINK NAME) empty. After click update the link in the view disappear. Many Thanks Xavi
How do you I enter script text into a Rich Text field without it changing the text?
I'm tracking XML data feeds and when I copy the feed script from my XML document into my records Rich Text "Details" field, update the record, and reopen the record, the script is treated as if it were meant to be performed and is executed within the field. I just want whatever is entered into this Rich Text field to be left alone and look exactly the way I left it. Example: Original copied text... <name> John </name> Text after update... John Please assist. Thanks! Brent
Can you hold value of variables across scripts?
Can you use and hold the value of variables across scripts? Say for example, onUserInput of text field Field1 I set a variable: intHold = 1; Then on onUserInput of text field Field 2 I do the following if (intHold == 1) { // do this } else { // DNE 1, do this } Will this work? If not, what's the right way to do this?
Automatically generate a record name?
Is it possible to automatically generate a record name based on selections within dropdown fields within it? I have a form that allows users to add records by first selecting 'A' from dropdown1 and then 'B' from dropdown2 and finally 'C' from dropdown3. Because this record is made up of selections from dropdowns it has no name or unique identifier other than the hidden ID created automatically. What I'd like is to create a single line field that would be automatically populated based on the choices
grouping select all
My records are organized by the groups that I determine. I would like have the ability to quickly select an entire custom made grouping of records. Currently I can only select all of the records or select each record individually. Please consider this. Thanks!
How to delete duplicate entries from listbox before display?
Hi there. I have a view called: used cars. When using the form to add an entry to this. There is a field called: make which does a lookup on a view called car types. However. car types has 2 fields. make and model. so if there is 2 records like so: BMW Z3 BMW 320i. then the lookup returns 2 * BMW to my drop down list. How can I remove these duplicates? Thanks. Rats.
Next Page