Sharing functions
For my own developments I have created an application with functions I often use. In this way I have a centralized place to maintain and document my functions. The comming months this function database will grow and I think it will get very handy for more users. It would be nice if I could share these functions with other users in the same way as I can use my functions cross application. Is this something for the near future? Kind regards, Ivan
Mulit view not working
On one of my databases, multi view does no work. On the other database, it does. Is there any requirement for multi view? Thanks
Messed Up Tab bar ...
@support: The Tab bar in one of my Applications gets messed up under specific conditions. a) The Application has lots of Tabs (see Normal Tab bar.jpg) b) I have set the last Tab (called Admin2) to be Hidden c) After I make a change to the Application (in Edit Mode), if I navigate directly to Run Mode, I can not use any of the Tabs ... as soon as I move my mouse over a Tab, it loses its background image and the Text reverts to some default larger text ... see Messed Up Tab bar.jpg However, after making
Unable to get the ticket
Tried getting the ticket with the URL : https://accounts.zoho.com/login?servicename=ZohoReports%26FROM_AGENT=true%26 LOGIN_ID=[Zoho ID/Email ID]%26PASSWORD=[Password] the reponse is CAUSE=Username and Password do not match RESULT=FALSE I used the same email id and password to login Soumya
What constitutes a record and how much can I anticipate using before I run out of space?
Hi Everyone! I am new to Zoho. And after looking at some of the past forums (ie changes to the free user limits), I wish I had signed up a couple months before. Now, it looks like I am limited to 3 users and 1000 records as opposed to the original unlimited users and 100k records. That is a huge difference. Can someone give me an idea of what constitutes a record and how much data I can expect to have before I reach my 1000 record limite or 100MB limit? Thanks, Arthur
GROUPING on SUMMARY forms
When I have a form with a field that also LOOKS UP (relates) to another form, I would expect that if I set fields to be GROUPED on a SUMMARY form their contents would just appear ONCE for the group, at the top of the group. BUT, what I see is that GROUPING does not appear to be working and the data is simply listed and duplicated down the screen. e.g. I have a form of HEADERS and a form of DETAILS. When I produce a SUMMARY of the DETAILS including related HEADERS, AND I set the GROUPING to group
Want to change date/time fields to date fields
In the early days when I developed my trademaster, I defined some date/time fields for such matters as ship dates, etc. In fact these should be date fields. Now I have the nuiance of always have values like 03-12-2009 19:03:00 when exporting to an excel sheet. I want eagerly to change such fields to date fields. However, it seems impossible now - since I have data in these fields. More importantly, these fields are referenced in other objects, so the system doesn't allow me to alter the fields without
embeding views with rendered IMAGES does NOT work for PRIVATE applications even with embed code
Hi - I am able to embed a VIEW in my website, even though the application is private, by using the code provided that surpasses the login in order to display the view. HOWEVER, if my view is rendering images stored in the database, the application MUST be made public (verified and confirmed) in order for the images to display in the embeded website. example: breweries information on this site at the moment, comes from zoho: http://www.atwproductions.com/index.php?pr=fand_brew as you see, information
i can't find embeding code for my form... help please.
Hi, i created a new aplication (web form) in zoho, i read faq and i see that i need to click on Access this application button and click on More Actions -> Embed in your website, from the Form header. The problem is that i can't see "Embed in your website": i see only copy aplication save as script share this application customize theme and layout no html code i find! How can i do? i'm using kompozer for my web pages. the application is "Richiesta Preventivi Recording" and i allow edit for support.
Consulting a period
Hello, Someone knows if is there some way to create a report/view on which I can specify a certain period (for example, from 01/01/2009 to 01/22/2009? I have a field "date" on the form, and would like to filter, for example, on report, the records of determined period of date. Is this possible? Thank you again in advance. :)
NEW TO ZOHO and SEEKING HELP
can you use arrays for table selections on a form i.e. I have a table containing 29 districts I want to choose one district, this would allow the regions tables of which there are 29 to be hidden and the chosen region from the district table to be visible and enabled as it is the following code is being used but is very cumbersome if input_REGION_SCOTLAND == "<selection1>" { show DISTRICT_<selection1> hide DISTRICT_<selection2> hide DISTRICT_<selection3> hide DISTRICT_<selection4> etc } if input_REGION_SCOTLAND
Automatically open another form
Hi, Is there a way to code the form to automatically open up the next form if the status of the 1st form change and copy certain fields data to the next form after the update or save is clicked? For example, if I change the Status of the lead to complete, after the save button is clicked, the client form will automatically open and the contact information on the lead form will auto populate on the client form. Please advise if this is possible at this moment. Thanks.
Creating a Chart from a form
Hi there I am having some problems trying to create a Chart View from one of my forms. The form has sales data by month from a series of customers. I want ot be able to view this as a bar graph by customer. Is there an easy way to do this without complicated scripting? Please advise Steve
can't change Application Settings
I duplicated an application, and I want to give the "Copy of..." application its own name and URL, but all I get for the past hour is "An Error has occured. Try Later" message. Is Zoho Creator down? Overloaded? Thanks in advance for any help!
Is Zoho Creator down?
I've been trying all morning to access creator.zoho.com directly, or just clicking the link to creator from Zoho.com but I keep getting: Network Timeout The server at creator.zoho.com is taking too long to respond. The requested site did not respond to a connection request and the browser has stopped waiting for a reply. * Could the server be experiencing high demand or a temporary outage? Try again later. * Are you unable to browse other sites? Check the computer's network connection.
Send an email concerning a task to ALL CENTRES if selected a decision box
Hello, I have two databases: one concerning a list of centres (with several contact email for each centre) and another database concerning tasks that are assigned to these centres. In the task form, there is a lookup dropdown menu for selecting the centre which the task is assigned to, and a decision box "Assign the task to all centres" My doubt is how to get all the emails for all the centres, for including them in the "sendemail" function. For the moment, I have this working: // First, if the decision
totime issue
I bring in a string in the format MM-DD-YYYY 00:00:01 example 03-08-2009 00:00:01. I do some manipulation and then finally convert the string back to date time so I can use it and it converts it to 08-03-2009 00:00:01. It has reversed the month and day but when I use it it treats it as Month 8 and Day 3 so it looks up the wrong data. Please help.
Data match issue
I have shared my application Trademaster to you. Please open the View "copy of testing reports and certificates", under "for clients" section. You will find a report record for MTA PO# "MTA-0007-09". The client PO number displayed is wrong here. It should be 100032486, but it shows 10031561. This value is derived from PO_items Form. I have checked the record in Po-items and it is correct. Why is a wrong number derived in the View? Thanks!
Custom actions and reload views
When a custom action is executed in a view, in some situations, after the action is executed it's necessary a refresh; in other situations the same thing may make the script to not function properly. Examples: For the first kind of situations, if a field is modified with a custom action, the old values will be shown if the view is not refreshed. For the second kind of situations, if the script ends with openurl() and the view is refreshed, the url may not opened because the form is refreshed. I
sort by date not working properly
Hi, On one of my forms the sort by date is not working properly.It was working ok up until Monday.So when I click at the top of the field to sort,it is still a bit mixed up and not in date order.Any ideas what may be worng? Thanks, Denis
Old data remains in drop box after switching data type
I had a drop box that has several choices in it, I then switched the field to an import field so that the choices were loaded from another form. When I access the application the new choices get imported as choices but so do all of the old static choices that were originally put in the drop box. How do I remove this old choices and only load the data from the form via the Lookup field? Thanks, Dustin
Is there a problem with Zoho Creator?
Tried to create forms and link them but could not get this to work. Wondering if there is a problem with Zoho Creator?
Sharing Knowledge using Zoho Creator
I have created a small business link exchange page here - http://smbdashboards.wiki.zoho.com/Sharing-Knowledge.html?atime=1237205203774 on my Z wiki using Z Creator to share information related to effectively using Zoho apps.
Decision box always unchecked on form load
Hello, I would like to know how to turn into unchecked a decision box (that was checked) every time we edit something, like by default. What is for sure is that we should include that in "On Edit > On Load ", but I have no idea of how to do it. Thanks in advance!
Link the email field from another database
Hello, I do not know how to do this. I have created two forms, one with contact information like: Centre: XXXX Email: xxxx@yyyy.com Etc. And another one with a list of companies, like: Company Name: ZZZZZ Centre: XXXX (This one is a "Look-up" field linked with the previous form) Send Email? [ ] (This is a decision box) The idea is to send an email to the centre of the company if the "Send email?" checkbox is selected. My try: if(input.Send_Email
Possible Form Features
I was looking at one of Zoho Creators competitors. They have some very useful features on the forms. Here is a short list: A field with an invalid value is flagged immediately not just when the submit button is pressed. This immediate feedback helps the user. The submit button is grayed out until all fields have valid values and required fields have been entered. Forms have sections that can be collapsed and expanded Forms are limited to two columns as in Zoho but they have tabs on top. This makes
Calendar view not showing month and prev next buttons
I have two calendar views of the same table. I have embedded both in my persoanl website. On the top of one form it shows the filter then the Month and the Year. On either side of the Month and Year are buttons for Previous and Next. This is exactly what I want. On the other calendar view it only shows the filter. It does not show the name of the month displayed nor the year. There are no buttons for Previous or Next. Has anyone else had this problem? Efficiently yours, Herb Wexler MBA www.PreventingMediocrity.com
ZOHO Creator App Broken Under Internet Explorer v6 !!!!!
@Support: Did you guys make any changes to ZOHO Creator (or to the overall ZOHO platform) last night or this morning ? The Application I am currently developing ... has a lot of HTML Views that have iframe ... /iframe code that invokes the regular Views for Forms ... but with parameters in the url to restrict the Views to records matching a specified criteria. Everything has been working for weeks now ... suddenly, when testing under Internet Explorer v6, I get error messages (from Windows) ... This
Zoho support sucks!
The support here at Zoho sucks to say the least. I had received a call from a consultant to find out if the zoho platform was fitted for our business..We had a discussion and was told that he would get back to me after reviewing my email with related issues. It s been almost a week and not reply.. I left a message as well but no reply as yet. If Zoho wants to compete wiht other providers they have to step up. Honestly I love the ease with which I am able to creat applications. The downside though
Script Doesn't Save
I wrote a scrip that had a bug, fixed the bug and the form/scrip worked fine (let's call this change 1). Then I edited the script to make another change and the work I did to fix the original problem isn't there. So everytime I update the script I need to redo change1 but all subsequent changes are saved and function properly.... HELP because is getting really annoying. ~chip
Form - PDF printout on filling the form
Hi Is there a possibility to have a predefined PDF containing some of the material entered in the form? I need that after the process of entering and in the "monitoring mode" and via email. Best regards Rob
Connecting my application to other Zoho services
Hello Is it possible to connect my personnal application to other Zoho services, like zoho people or zoho CRM? Thx
Disabling mandatory fields
To Whom It May Concern I am trying to set the scripting up so that when the user ticks the box entitled unsubscribe, all the mandatory fields become disabled and the form can then be processed. Can you help? clivepeh
Did the OpenURL change
I had a view filter working 2 weeks ago and it stopped working. Did the OpenURL function change? I have my openURL using the format shown in the sample code in the creating dynamic views example in help openUrl((((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/html/Repair_Detail_view/Customer_Contact=") + input.Contact_Number) + "&Repair_Tag=") + input.Repair_Tag, "new window"); That stopped filtering records for me. I would get all records. I changed my openurl format to the version I found
'send' an application
All- Is there any way to to send someone an application? For example I have developed an application on my personal account but would like to transfer it to my business' account. How can this be done?
Test for Form View
I would like to test for "View" loaded and alter the original default option on "Form" from "No" to "Yes" Is this possible ??? Thanks
URL Format and Link Names
How does one use deluge script to format or reform a user's submitted hyperlink? I know that the form has an option to require a Link Name, which then becomes a clickable text link in the table view. What if I want to change the user's submitted Link Name? i.e. <A HREF=" + input.URL + ">User's Link Name</A> to <A HREF=" + input.URL +">My Link Name</A>
Pulling Data From Zoho Contacts
Is it possible to pull data into a Creator Database I made from the contact manager.... I am using Creator for a work order system and would like to select the customer and it fill in all the contact info without having to re enter each time. Thank you in advance! Todd
SSL Access
in both Internet Explorer and Firefox if i access my database using SSL the formatting is messed up!
RSS Problems
Greetings all... I am trying to use the RSS export option to create a widget for my website from one of my Creator Views. When WidgetBox tries to analyze the page, it gives me this message.. Sorry This feed does not validate. line 5, column 62: XML parsing error: <unknown>:5:62: syntax error [help] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ^ In addition, interoperability with the widest range of feed readers could
Next Page