Help Documents Are No Longer Working!
You get this every time I attempt to go to the help documents: Whats going on??
How to restrict the date from being overridden?
Okay, so if I use zoho.currentdate, how do I restrict that so once entered it cannot be changed? Any help would be amazing. Thanks, Michael McNeill
How to combine these two fetch requests?
fetch = Add_Group [Name == input.Group]; input.Group_Manager = fetch.Group_Manager; fetch = add_contact [Name == input.Name1]; input.username = fetch.username; I need to combine those to so that I can acutally script them as I can only define one "fetch" task. Thanks, Michael McNeill
How to restrict duplicates in a Field?
How can you restrict duplicates in a lookup field? I need this to be restricted! Thanks, Michael McNeill
Calendar View
I wanted to create a simple reservation database using the Calendar view. Trouble is that the calendar view can only be based on one date. It does not support a 'date range'. Hopefully this feature could be added to make this calendar view just a little more useful. Thanks, Shane shanepresley
Significant Excel Importation Problem
A client for whom I'm using the paid version of Creator is frustrated to the point he wants me move to DabbleDB– a move I'm reluctant to make because I think Creator is a better long-term solution to his needs. Our problem is a two-day old inability – even with Zoho’s very courteous support – to import into an existing application a two-thousand row Excel file. I've tried both the file import and cut and paste options of the web interface, as well as the migration tool. The excel file is good, because
UK Postcode Field
Hi Zoho forum gurus, I am very new to Zoho (signed up today!) and have been learning how to use the creator. I am currently developing a test form that has supplier information fields. I would like to include a UK postcode field which only accepts uk postcode entries. Is there an if/else statement or snippet of code that is already used to solve this problem, ie an error message comes up if there is an invalid entry?? Thank you, V
Looping on Fetch existing data on add
If a key field value already exists in the database I want to populate my form with the existing data. The form is populated correctly but apparently the system goes into a loop. The rotating arrow next to the key field never disappears. When I type a new value in one of the fields it is immediately reset to the value from the existing record. I am using the following code on user input for the key field. if (count(temple_main_input_form[Policy_Claim_Number == input.Policy_Claim_Number]) >
How do you dynamically change the subject of a send mail task?
Okay so I have a form where on success it executes a send mail task. But with that I would like to change the subject with the different type selected. Is it possible to make it dynamic or does it have to be one set thing? Thanks, Michael McNeill
Problems with restore
I have two restores proces in progress till 2009-09-08 04:15:46.0 !!!!! I need to stop these restore process and know why every time I try to restore it didn't work. In the other hand, I cannot backup my apps. When I try to backup one of my applications the process finished with failed status. Please I need to make these backups and stop these restore process. Thanks. Sergio Galiano
Domain Portfolio Manager
Hi! I live in Brazil and manage a portfolio of 800+ domains. Its being hard to manager them, specially its expiring dates. I am looking for someone to develop an application to make our life easier. I started adding data to ZOHO but dream some integration between ZOHO and any GMAIL, for example, to update database on demand, while we receive emails from Register. Best regards Claudio Santos
Missing 10th of the month in Scheduler interface
ZC Team: I suppose that the image below is enough to see the problem. I'm using FF 3.6 . Regards, George
How to display related records in an HTML view
My view currently displays one record from one table. x = Purchase_Order [ID == input.PurchaseOrderId.toLong()]; where Vendor_Account is a field in Purchase_Order I want to include other records from tables that are related via look-up fields on the original form but the only fields that appear in the script builder window as a collection variable is the name of the lookup field, not the id of the corresponding record. ex. y = Vendor_Account [ID == x.Vendor_Account]; but of course
Appointment Setting Form
I received a phone call from Customer support and I was asked to post this request here. I am trying to create a form with Zoho Creator that has some dynamic field population functionality. Please see this form that I have created in another site as an example of what I am looking for as far as form design . http://fs3.formsite.com/steveepm/form010783660/index.html Background: We are a property management company that rents apartments. I need a date field to only show availability for Today(if a
Problem saving a view after hiding a column
Greetings, I want simply to hide a column and then save this change. But there is no way to do it. I always get the message: "FAILURE:Error occured while saving the view" And it say me to refresh the page, but it neither works on this way.... I've tried saving with and without the option "Saving as a new view".... Any idea about it? Some permissions problem, maybe? Thanks!!
Possible Bug when using openURL ...
Hi: I encountered what might possibly be a bug. If I place a cancel submit command in the Validate section of a Form, it works just fine. However, if I place an openURL command (to display a web page in the same window) immediately before the cancel submit, the contents of the Form are added to the Table ... i.e. the cancel request is not honored. Gaev
Problem with Saving View Changes
I am having a problem changing and saving views in Zoho Creator. In my Startup Company Input Form Pipes View, I am selecting the More Actions / Show/Hide Columns option. I then am Showing the column 'Display Logo.' The column then appears in my view. However, after I select 'Save Changes' the column disappears again! It does this over and over. Any ideas about how to fix this? Here is the link to my view: http://creator.zoho.com/startuphouston/houston-startups-database/#View:Startup_Company_Input_Form_Pipes_View
On user Input - show alert
Hi, I cannot save this script on On User Input of a field: if (count(Matr_cula_Consular[C_digo_Fisca_CPF == input.C_digo_Fisca_CPF]) > 0) { input.C_digo_Fisca_CPFerror = “Warning...”; show C_digo_Fisca_CPFerror; } I write something wrong? Mic
Reporting in ZohoCreator - Preview
Dear Users, Continuing with our efforts to integrate the powerful reporting & analytics functionality of Zoho Reports into Zoho Creator, we are providing the ability to create reports within ZohoCreator. We're opening this up as a limited preview so we can get early feedback and constructive critisism from our eager developer community. Pretty soon it will be open to all Zoho Creator users. We are working on a full blown support document. Meanwhile, you can find your way around the reporting feature
How to make batch notifications?
Okay, so is there anyway to create batch notifications to an RSS feed or an email. So that basically all changes to the application are either sent to that RSS feed or an email is sent, every week at a certain date or time. I have the scheduler preview enabled on my account, so please help! Thanks, Michael McNeill
Due to security reason - i now cannot get my form to go public - what is up with THAT???
All of a sudden - my form asks for a login - and I want it to be public - however I try - I get an error telling me that I cannot go public This must be new???? How to resolve ???? thanks karla info@darocas.com
Stateless Form Email
Is it possible to generate an email notification upon submit of a stateless form? Can I include the data from the stateless form. I am just trying to use a stateless form embedded on a web page to update a contact information (contacts) table that has more fields. I get the data into the contact form from the stateless form using the "insert into", but want to send a confirmation email to the user. I tried to do this from the contact form (based upon the Public added user field) but it does not
How to input data on success?
Okay, so I need to automatically add data to a field called "Supervisor" from a reference field "Location_Subscribed_to1.Supervisor". And then I need to add data to a field called "Group_Manager" from a form called "Location_Subscribed_to1.Group_Manager" and I cannot figure out how to do it on my life. So please help me! Thanks, Michael McNeill
Add new view columns, lose previous view columns in display.
I added 3 new columns to one of my forms. I then went to an existing view to add those new columns to the view. Now when displaying that view, only the 3 new columns appear in the view. All the original columns no longer appear. If I go in to the show/hide columns feature while the view is displayed, all of the original columns are listed but only the 3 new columns have their boxes checked. If I select all of the original columns to show them, they all appear in the view. If I edit the view
Remove Line Feed from String Entry
I need to write on Add Success function to remove some text and line feeds from an input field. For example Line 1 other text Line 2 I would like to convert this to Line 1 Line 2
404 Error When Printing HTML View
When i push the print button or PDF button off my html view, i get this Not Found The requested URL /fcpsppe/ppe-with-appt/print/Printout/JjvdvZdm3Ab6w45NqnFVZxwzGgw5Kb8huNxHknapJTWNYDxGTMkuN7pdpZpRCTeKSF5d1WjxbzazxZ0je7MCDZUdpJ1ES3SeCe5f/Lookup_Name=Gartma,+Bart-+11/09/09&privatelink=JjvdvZdm3Ab6w45NqnFVZxwzGgw5Kb8huNxHknapJTWNYDxGTMkuN7pdpZpRCTeKSF5d1WjxbzazxZ0je7MCDZUdpJ1ES3SeCe5f was not found on this server. What am i doing wrong?
Import function doesn't work
I can't make the import data function work at all. It is just loading empty records, or nothing at all. Completely frustrating. Help please!
parsing text from email message
I would like to parse a text inserted to a form by email. The text may have several lines and I would like to insert each line separately to another form. Is there any method of tokenizing text by lines. I tried getPrefix with \n but didn't get anything.
I need help on using jquery datepicker on a user control...thanks.
I am trying to get jquery to work on a form I have on a usercontrol. My web application has a masterpage, The current page I am working on has several forms which are on usercontrols loaded onto the parent page by the click of a menu control option,which then loads the required form contained on a usercontrol dynamically via a place holder located on the parent page.The placeholder is itself placed in an ajax update panel control. Below is how I have tried to register the jquery datepicker on one
Next url to show View with filter
Hi all, I have a script, containing a : input.SelectItem = (((("<span style='font-size: small;'><a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=#Form:Reserveringsitem?ResID=") + otmpRes.ID) + "&zc_LoadIn=dialog&zc_NextUrl=#View:Reserveren?ResID=") + otmpRes.ID) + ">Reserveringsobject</a>"; which creates a href, working great. Also, the nexturl works, but is doesn't the ResID. In the browser, it shows : http://creator.zoho.com/dnjs/hotel/#Form:Reserveringsitem?ResID=38685000001024261&zc_LoadIn=dialog&zc_NextUrl=#View:Reserveren?ResID=38685000001024261,
Is it possible to detect a user's screen resolution and use that in the script?
Hello, Does anyone know if I can detect the screen resolution and then use that information in my script? Rob
Is it possible to rename my account
Hello, I have a Creator account. Everything works perfect. Thanks for this great app! The only thing is that when I have registered i used my own name and now all my apps use a URL that contains my name. That doesn't look good and is confusing. So in stead of url's such as creator.zoho.com/myname/appname I would like it to use something else. Is this possible? And / or can I have the name of my account changed? It would seem that it has impact on everything I have built so far? Greetings, Rob Bastiaansen
"Loading..." Message
I am using the following command at the end of a script in a stateless form to call a view conditionally (On Click action for a button): openUrl("#View:Register_View?Report_Date=" + input.Date_field, "same window"); The view opens correctly, but a box displaying "Loading..." appears in the middle of the screen and does not disappear even if I go to other menu selections in my application. This also occurs if I take out the reference to Report_Date, as follows: openUrl("#View:Register_View", "same
Only can access 4 of 314 records. Please help!
This is an urgent problem: I'm unable to access all the records in my database. When I open the database, I only see 4 records. These are records that I previously queried using the word, "etiquette" in the search field. Now I can only see these records. I checked my account settings and there are 314 records in my database, so I don't think they were erased. Please help! I'm very disturbed that I cannot access my entire database. Thank you in advance for your prompt attention.
view reports under category
I'm really loving the invoicing and expenses. Would it be possible to add the reports associated with a category on the left side of the screen? If I'm on Invoices, rather than click Reports, etc, it would be great if the Invoice reports were on the left. Same with the expenses, etc. It would just be faster to look at something. Thanks!
Error in Creating Custom Filter
One problem and one question, if I may. Problem: when I create and save a custom filter, and then press the Done button, I frequently get an error message saying 'Setting Filters Failed'. Why is this happening? Question: how can I set a filter to show records where a checkbox field is blank? Thanks
Disappearing html view popup
I have an html view that i call with a button (openUrl) in a list view. For some records in the list view the popup (the Zoho-kind with 'close' in the upper right corner) displays like it should. For most records though the content also displays correctly but the popup disappears after about a second! The screen is left black. When trying to find what causes this I started to delete the content of the html view. The only result I got that in the very end (when there was almost nothing left at all
Export as XLS is not working correctly - dates change half way thru the file
Dear Sirs, From today when I export as XLS in Creator the format of the file changes half way. The date values come as numbers and this issue is giving me problems while updating my files on zoho reports and also when I download the file to keep my local database up to date. I am attatching a sample file that I've just exported and you can see that it suddenly changes all dates to numbers. This is probably due to a current update you have made to your system. Please let me know if this has a solution.
Edit this field box disappears when clicking the criteria-box
Dear Zoho-team, When I wish to change the settings of a field and add criteria to it, the box simple disappears when I click the field to start writing in it. This means that I cannot at the moment add any criteria to any fields in my form. It specifically concerns the fields organisation_skole and organisation_ikkeskole in the form "kontaktrapport". Here I only wish to show the items where "organisationstype" == "skole" and "ikke-skole" respectively. Could you please fix this for me? That would
HELP !!!! How Do I Resize An Image In Deluge Script?
Hi, I am trying to write in deluge a defualt size for automaticly having an image when submitted be a certain width and height. Is this possible?
Next Page