HTML view, in print mode, with parameter == error.
I have created an HTML view that generates a custom payment history report for a contact and displays it in a table. I pass in a parameter (contact_id) to allow me to grab payments associated with a contact. I would like to print this report without the navigation elements that are usually present. Normally to print a view I just change the URL from: /#View:Report_Payment_History?contact_id=322494000000019283 to /print/Report_Payment_History?contact_id=322494000000019283 However in doing so I get
In and Not In
Does anyone know the formatting for using In or Not In when using the script builder? I was thinking of doing something like the following (VBA format, as I don't know how to do it in Deluge): If cboStatus Not In ("-Select-", "Booking Made", "Cancelled") Then Expression End If cboStatus being a picklist. Thanks, Leo
error
hey whats up stephen. im getting an error message every time i try load the page that supposed to come up as a split screen with the rep demo/sale info on the left and the personal info on the right. anything i can do?
Exporting
I have to create more than one view in my form because it was so big.... Now I have a problem, How can I export all the form data instead of exporting view by view.... Thanks
Custom form with custom output views
I have Zoho data (I imported from access DB) and, what do I need to create is 1 custom input form and 1 custom output view: Input form will be taking the 1 or 2 parameter(s) and passing them to Zoho database. output(or result set) will display custom (spredsheet like ) view with 3 or more tabs ( view1,view2,view3. ) see this link example i found on some site, this is input parameters and here is the link to output. I don't know if this eaven posible , but if it's , what would I need to do do develop
Full RSS Feed
Hi, Might sound like a dumb question. How to I get a full RSS feed of all items from a form or view. I am struggling as when I export the RSS feed it only displays about 25 items. I have around a thouand items. I have tries yahoo pipes to fetch the csv export however I am not sure how to convert this to an RSS feed. Is there any whay to export and RSS feed that contains all items in the form/view? Thanks
Date - Time fields: Day and Year are being swapped.
Help. All of the sudden all of the dates in existing records for one of my forms the date's day and year are swapped. I enter: 7/20/09 It is saved/returned as 7/90/20 Any Ideas? tt
Pricing
Just to confirm a pricing question. If we wanted to create an app that was used for employee to enter time (time sheet), and hence these employees would need to individually login to the application, this Zoho Creator cost for this is $175 for 50 employee per month - or $2100 per year to create a time entry page for 50 employees - and roughly double that for 100 employees - and if you reduced this price down to $2 per user per month when you hit 500 employees - this is still $12000 per year??
Alphabetical Order in Deluge script?
I have a field called "Accounts" that is set to be alphabetically ordered in the field preferences. In my form, however, I change the contents of Accounts using Deluge script to filter them according to another selection. When I do this, the returned list is no longer alphabetical. How do i get the alphabetical order back? Thanks!
How to make the SUM to appear in Bold
Hi How to make the SUM to appear in Bold
Print Button?
I'm wondering if there is anyway to add a "Print" button at the bottom of a created form that will be embedded in a website? I'd like for people to be able to print the form they've filled out before hitting submit or have it automatically print when they hit submit. I'm not good with code or script so if that's what I need to do, help would be appreciated.
EDITING ENTRIES
HI WHEN I TRY TO EDIT AN ENTRY IN ZOHO CREATOR THE EDIT DATABASE SCREEN IS CROPPED AT THE BOTTOM NOT ALLOWING ME TO SUBMIT THE CHANGE. HOW CAN I GET THE FULL EDIT DATABASE SCREEN TO APPEAR. THANKS
Image field
Hi all, On one of our forms we have an 'image' field for passport photos. When in views, I would like this to show as the actual image, rather than the link which normally appears. Is this possible? Thanks!
API Key request not working
Hi Guys, I'm trying to request a AKI Key for another account and the page http://writer.zoho.com/apikey.htm is not working on my side. I always have : Loading...Please wait Thanks Pascal
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.
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
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.
Next Page