importing excel into Creator, need help
Still cannot uplocoad my excel file to Creator. Have followed all steps.
How to use for each element deluge?
Okay so I need a code to where it fetches all records: fetch = Add_Subcription[Employee1 == input.Name1]; { fetch.Date_Cancelled = zoho.currentdate; fetch.Staus = "Cancelled"; } like this and updates the fields, as in the code above, but I need to do it for ALL records and I don't know how to write the for each element in deluge or the script writer. Can somebody write one for me? Thanks, Michael McNeill
Cannot update Form in htmlview
Hi, I have a strange error. In a form, when 'normally' accessed to edit, I can Update the data. But when the form is shown in a HTML view, on Update I get : 'Invalid entries found. Please correct and submit again.', and a red 'undefined' on the screen. For support : the app is Hotel, and the HTML View is Reserveren, I have shared it for support. Thanks, Danny
Best way to deal with null variables in an HTML view
I have an HTML view that is populated by 50 differerent variables. Some are from drop-downs, some aren't. On fields that aren't required, what's the best way to keep them from showing up as "null" in the document? I understand there is a way to use a tempVariable, but this would have to be done for each variable and seems messy.
How to make a search view?
I have looked at the information on the Zoho Creator Help Documents and they haven't helped me. Can somebody help me set up a search view? I have the stateless form and everything, I just don't know how to code it. Any help would be amazing. Thanks, Michael McNeill
Synchronise contact from database to Outlook
Hi Zoho! Is there a way to synchronise contacts from the database that you create to go straight into outlook?? thanks! v
Backups Not Made of Correct Application
When I do a backup for a specific application it is subsequently listed as a backup to another application. Since backups are crucial, I need this corrected ASAP. Thank you.
How do you conditionally send mail?
Okay so in my application I have two forms one to add subscriptions and the other to add subscription types. The Add subscription type form has options to allow the user to select whether he or she wants to email the subscriber and email the team leader. Then once a subscription is added the respective emails should be sent out. But those vary with each subscription selected. The Type is a Lookup field (ds name Type), the Email Team Leader field is a dropdown list (ds name Email_Team_Leader),
How do you restrict the number of items that can be selected?
Okay so my system has a set of subscriptions and basically each location has a special number of subscriptions that they are allowed to have. How can I restrict the number of subscriptions so that they do not over subscribe.
HTML in Zoho Creator
Hi I would love to be able to paste some HTML in a Form. I explain a little more : I would love to paste some tracking tool like google Analytics to analyse what people are looking into my data base. So the idea is to paste some google analytics scipt some where in the form or view. I have tried already pasting directly in the code. No success. Creating a multi line field and psting the code : No success either. Does any body has an idea ? Thanks in advance hgonay
Cascading deletes
Hi there, I have two forms, one with a lookup field to the other. I've noticed that if I delete a record in the parent form, the corresponding child records are not deleted. Instead, the lookup field is set to blank. I just wanted to check if there's any way to enforce cascading deletes within Zoho Creator, so that the child records are not left orphaned? (From the forums, I read that this is how it's done in Zoho Reports?) If it's not currently possible in Zoho Creator, could I please put my
problem for contains in set criteria
When I put "contains" in the criteria in records in editing mode there is a message saying that "adding criteria failed" please refresh or try again later. neither works; only "equals" works. please can you correct the problem urgently
� Character in email import
When I am populating a form via email, Zoho is translating a space to �. Is there any way to remove this using a string function via a deluge script?
I am unable to edit an applicaiton installed from Zoho Marketplace.
Help me! I installed a few apps and I can't edit any of them, I haven't gone over my limit or anything, I just have no idea whats going on! Help! The Application is Timesheet-Management (English) and it has edit access to support.
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?
Next Page