Cycle 2 : HTML view to PDF
Purpose: At instances where HTML views are used to generate dynamic reports, the user can have a copy of the report ( at a given point of time) , and can also share it as attachment in private ( with people outside the ZC application) Motivation: Apart from using HTML view to create dashboards, this is also used to pull out data across multiple forms / views based on specific criteria ( a.k.a parameters).Sometimes, these reports are generated via user selected values, more so in an interactive manner.
How to Create Summary Page with all the Names (without Replicating) and getting the total for each person
Greetings. I am in the process of finalizing a vacation / sick leave tracker and just need one more thing. How can i list all of the names of the people who submitted a leave request and get the total # of days (a field in the form) without replicating each instance of the names of the people who applied for a leave. Here's the formula i tried: <%{ for each x in Create_Leave_Request {%> <tr> <td> <%=x.Name1%> <td> <td> <%=x.of_days_applied%> </td> <tr> However, what it does is it list
Calendar display limit
Are there plans to increase the number of characters displayed in a calendar? Currently only 10 characters are displayed. Even increasing this to 15 will be a big help. Herb Wexler MBA www.PreventingMediocrity.com Norwalk, CT 06854
Zoho Creator Import only accepts .csv cut and paste data, and only creates first field
I can't seem to find anyone else having such a basic issue, but all I am attempting to do is to paste data into the import function. I have tried with and without headers, with or without commas, tabbed, formats .xls, .csv, and ,tvs. Only .csv works, but regardless of what I do, it only picks up the very first field. Is there any direction / help you can offer? I am using Firefox 3.5, but it did the same on my earlier version of the browser. This is really supposed to be a simple aspect of the process,
Help - strange import error message
Hi there: Trying to import an Excel spreadsheet of 800 + records. Get the attached error message. No idea how to fix it - the column labels match the Zoho columns and are appropriated labeled, data looks good. Help!! Thanks in advance for your help! Edited to add: I also emailed my question/support request to support [at] zohocreator [dot] com on 7/15/09 at 11:15 CST. No response as of 7/16/09 at 3:25 PM CST.
Zoho Creator
Hi, I did some work on Zoho creator last year and have struggled to get back to it due to other commitments. I notice nothing appears to have changed in the last 12 months. Can you let me know what the future plans are for Zoho Creator in the longer term ? Kind regards, Jim.
Create a view without edit or delete?
Is it possible to create a view without the edit/delete functions. I want to post the database on my website, but I don't want users to edit or delete the records. I have tried NOT selecting the "allow users to edit / delete" function. Also have tried the Permalink thing. I still get the edit/delete functions on a list or grid.
Specific database calculation help needed for computer illiterate novice!
I have created a database to calculate the amount of time I spend with patients doing a specific task. I have fields "Time Began and Time Ended". I need for the database to be able to take the time began and time ended and automatically enter another field telling me the total duration of time spent with that patient. I need to know how many hours, minutes, etc I spent with that patient during that visit. I know nothing about functions and scripts and after trying to read about them to learn, I
Current Month Criteria
I am trying to add a criteria to a view and I am having trouble. I am trying to only show the records for the current Month and the field I am using is both Date and Time. Can anyone help?
Page Layouts
Is there a way to change the layout of fields, I need to have multiple fields on the same line, or have the ability to drop fields into a table so can control the layout.
Deluge date time function fix
Dear Users, Due to a number of complaints on date-time functions, we are rolling out a fix in a day or two which will establish the following behavior. 1).toString() applied to datetime value a).<date/datetime>.toString() function on date/datetime will output date string in the format specified in the application setting. b).If you want to override it, you can use <date/datetime>.toString("date format as string"). eg. toString("dd-MM-yyyy") 2).toDate() applied to string value a). <string>.toDate()
I have imported my .XLS "database" into creator and Need to Email my contacts.
Once I have a Creator database established is there a way to create an email list from that information?
TypeError: node.childNodes[0] has no properties in Script Builder
Ever since the upgrade to 3.0, my app gets this error in Script Builder. Free-flow still works, but wondering if there are other effects? (see cross post on sendmail error) My app http://creator.zoho.com/egutshall/task-manager is shared to support
Ok I figured out how to send individual emails
Is there a way to email the entire group simultaneously? I added the Send Email Script to my Creator database and cand send each client an email. I need to be able to send them all an email. Thank You Jason
Record informations
I add a formula on my blog, I recorded all the informations, and I did not receive anything, anywhere... Can you guide me for this ? I thought it was in my account section, on the contact file...but nothing is in it Thanks, BR JMC
Can you break this Application ?
Hi: I would like to invite Viewers of this Forum to check out this Application ... SICAR Lite ... that exploits the recently released IP Address facility in ZOHO Creator ... to provide a "Proof of Concept" of a Secure Framework for enabling external (non-ZOHO) users to self-Register and then add & edit personal information that will be accessible ONLY to the Registered User and ZOHO Users authorized by the Owner/Admin of the Application. More details about the Application can be found on the Home
Modified_User_IP_Address and stateless forms
ZC Team: I saw that the recently introduced field Modified_User_IP_Address is not updated when the record is updated using scripting in a stateless form and remains blank/empty. Is this the normal behavior for this field or it's a bug? I expect that the field to behave in the same way like Modified_User and Modified_Time and not to remain blank when the record is updated using a function and a stateless form, and I suppose that the actual behavior is an issue. Regards, George
Required Decision box
Hello, I would like to have a Required "Decision box" on my form. Can anyone help me? Thanks a lot Olivier
Exporting data of ALL applications
Hi, I'm Sarah Carpio, an intern at Evaluando ERP in Buenos Aires, Argentina. We currently have 43 application on Zoho Creator. We export the data from each application to an Excel sheet (which makes 43 separate Excel sheets) and then compile them into one Excel sheet for convenience. The process is very tedious. For this reason, we were wondering if there is a feature/function on Zoho Creator where one can export the data of ALL applications into one cohesive Excel spreadsheet. I have looked through
automatic updating monthly payments in Expense Tracker
Is it possible for a monthly payment to automatically be added to the expenses without having to go through each one manually? I have a great many direct debits and stop orders? Cheers Rob
Duplicate record = Same record ID
Hi, When I duplicate a record the ID to the record is also being duplicated. It doesn't seem like it should do that. Is there a way to have the new duplicated record have a new unique ID? Thanks, tt
XML File and executeXPATH
Is there a max size that the file uploaded to executeXPATH can be. I was trying to play with my itunes xml file and it would not load. I then exported an xml file from itunes for a play list with only 50 songs and it still would not load. I copied the text and browsed to it to upload it. I am just doing some testing but I plan on using the XML features of Zoho more in the future. Thanks, Shadrach
Slow to run deluge script
Zoho Creator seems to be running VERY slow today, when executing deluge script. Is there exceptionally heavy use on the server today? Previous to this, there was no problem, but today is really bad. Leo.
Simultaneous pop-up forms/views
I have a view with a custom action that opens another view in a pop-up window. Within that pop-up view I want to have another custom action, which would open a pop-up form. So: View -> opens pop-up view -> opens pop-up form. It kind of works, but then something weird happens. The pop-up form will open when initiated from the pop-up view, and then revert to the pop-up view that opened it. Anyway around this? Thanks, Leo
Cycle 2: Built-in Function ReplaceAll(searchString,replacementString)
I am re-submiting the suggestion to have a ZOHO Creator built-in function to replace "all specified character patterns in a named field/variable" with "another specified character pattern". Suggestion: Provide a ZOHO Creator built-in function that will replace all occurences of a specified SubString within a specified String (field or variable) with another specified String. Purpose: Perform Text Replacement operations ... - easily ... one simple command instead of recursively calling a User Defined
HTML View, DropDown(<Option>), Javascript(onClick)
I need a HTML dropdown in my HTML view. The data of course is coming from a Creator form. How do I do this? I was able to easy enough get the code done but then I was slapped down when I tried to add some JavaScript so the selection could load my iframe widget. So how do I do this simple HTML without javascript in the Creator HTML views? <B>Select some fruit:</B><BR> <SELECT NAME='Morefruit' SIZE='25' > <OPTION SELECTED onclick="alert('Apples');"> Apples <OPTION> Bananas <OPTION> Oranges <OPTION>
Looks good but...
This programme looks great, but how do I add a new year for the reports? The drop down box only shows 2008? Cheers Rob
Application Error - How best to get Support?
I have a problem with a zoho creator application that I have developed. I keep getting the folowing message... We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com I have emailed support as suggested but my previou emails to support have taken many days to be replied to. How should I proceed to get my problem(s) resolved as soon as possible? Thanks.
Calendar View and Custom Actions
The calendar view does not support a Custom Action button. I was looking to have it open a page displaying event details rather then the 2x click method. Alas, it only works for a list and grid views.
Printing HTML Views with Passed Parameters
Greetings all... I just spent the last two hours figuring out how to pass parameters to an HTML view with an embedded view only to discover that you can't print that view (using the Print feature in an HTML view.) So some suggestions on the best way to proceed would be greatly appreciated. The view is showing correctly using the code below - I WAS WRONG HERE...the Between function doesn't seem to be working properly. If you have the same date for both start and end dates you get data equal to that
Cannot add records
Hello, I cannot seem to add records. It just says "please wait". I never had this problem before. What must do to get it working again. Thanks
Can't update any records.
I keep getting this error everytime I try to update a record. "Invalid entries found. Please correct and submit again. [t_245481000000035634_PIDX] Exception occured while inserting rows" Failed to update data. Any help would be greatly appreciated. I have shared and gave edit access to support on both of my databases.
Don't want to display meetingid in Attendance view
I needed some subforms in one of my applications, and I found the Meeting Tracker example very helpful, thank you! But in order for it to work (meaning, when you click the View Attendance button in the Meetings view, the records that show up in the Attendance view only apply to that particular meeting), meetingid needs to appear in the Attendance view. All those numbers are irrelevant and confusing to my users. So, I went to the View Configuration for Attendance, and in Column Properties I hid (deselected
Complex Boolean is Making Me Crazy
This is for an html view I'm developing. for each r in BBPOST [POST_STATUS == "Moderated" && ORGANIZATION == "Birchwood" && START_DATE >= zoho.currentdate] This works as expected. Now, what if I want to also include data for other Organizations AND Birchwood? It's like I need... for each r in BBPOST [POST_STATUS == "Moderated" && ORGANIZATION == ("Birchwood" || "Rosendale" || "Craig") && START_DATE >= zoho.currentdate] But this is malformed script. I tried this, but it does not work: for each
Can a log-in form be embedded in an HTML view?
I want users on my site to be able to log into their Zoho user accounts (so they can access other embedded views and data) **from my own formatted web page** and not by going to a Zoho website login page. The reason is I do not want to my users to leave my own site just to log in. Is there a widget or special form field or trick in Deluge that will allow me to do this? Many thanks for your response. Greg datazen1@gmail.com Santa Fe, New Mexico US
Interaction and editing local file/process
Hi! I need advice how to edit/save a local txt file stored in client side machine and suggestions how to stop/pause a local service. I suppose that this operation could be done only with some interaction with JVM envoirement or other external program...
subform
hello everyone,i need to know how to create a subform in a form. can you help me??? thank you
Authenticated Zoho Users for a Form
I remember seeing some posts on this a while ago, but I cannot find them (this new forum has so much eye candy it's giving me a headache - sorry Zoho!) I'd like to prevent non-authenticated users from submitting a form. Is this the best way? if (zoho.loginuserid == null) { alert ("You need to sign-in to your Zoho Account to submit this form."); cancel submit; }
Sample Suggestion Submission for Cycle #2
Over here ... here http://help.zoho.com/portal/en/community?ftid=2266000000337629 ... it is mentioned that suggestions for Cycle #2 of the Community Driven Feature be submitted using a Template format. This is a sample of the suggested Template ... provided by user niskypto (John Whitney) ... that refers to the winning entry for Cycle #1 ... hopefully, it will assist you in formulating your own suggestions for Cycle #2. Suggestion: iCal Feed Purpose: Enable an application to push event-oriented data
Community Driven Feature ... Cycle #2
They tell me that the Community Driven Feature (voted in Cycle 1) is almost complete. So it is time to commence Cycle #2. Rules of Engagement ... a) In order to organize/manage this process, each suggestion must be started as a new post ... b) Use this template ... proposed by user niskypto (John Whitney) ... to make your case. Suggestion: What is your feature title (short)? Purpose: What does this feature do? Motivation: Why would anyone want this feature? What's your personal experience that lead
Next Page