How may I remove the pane containing the section and home form link?
My application is very simple - one form. I want to entirely remove the pane containing a redundant section and form link. How, please?
Migration of the ZOHO database including the structure to another database
mel_03 asked 23-july-2009 about migration. The answer was as given below in red. This answer show that only the tables can be exported not the database structure. Does this mean that all the links and structure cannot be exported? What about the multiselect fields will all values just appear in one excel cell?. Zoho Creator gives the option to export (Retrieve ) data in various formats as mentioned below. Spreadsheet HTML PDF RSS Feed JSON Feed CSV Feed TSV Feed You can download in any of the formats
batch download/export data
There is a requirement,export data to excel and the content contain picture ; can we solve this problem?
Accessing Forms from a Different Application
I want to run deluge code that looks like this: if (count(master.States[Country == input.Country]) == 0) { clear State; }master is the name of the other application. Country is a field in the States form and input.Country is a picklist on the current form. However, Zoho keeps telling me it doesn't expect a [ on the first line. Can I access form data from a different application like this?
Problem while duplicate the application
I don't know why I'm unable to duplicate my application.. (Penta CRM 10) When I click on duplicate button it starts but end with no error nor the application gets duplicate, Please let me know how do I troubleshoot. Thanks Note: I have already share the access to support.
Solution Needed
Hello I am reservationist for a restaurant. Currently I uses a google docs spreadsheet and have one for every day we are open to record reservations. Because many of our clients are repeat customers, I would like to be able to auto populate the ** columns below so I dont have to ask repeat customers basic questions and can also keep notes about the customer. In the reservation I track date reservation made date of reservation **name number in party number of adults number of kids **phone number
How to sort picklist (lookup field) descending
I have this problem: I have a form "two" which is linked to form "one" through "record number" lookup field. I want always to enter data into last record of form "two". That's why I would like to have the last record of the lookup field on the most top. I wrote the following script record number ( displayname = "record number" type = picklist values = safetyreport.safetyreportid sortorder = descending width
Can't "Add New Section" in some of Applications (?)
Hi, Why I can't Add New Section in some of my applications? After I click on +Add New Section in: Settings -> Customize -> Rearrange Links Then I Specify name for the new Section, Once I click Add, the New Section is not created. Is this Zoho problem or I was make a mistake? Thank you, Wisnu *please check attached .pps file
Selecting a text Field
Hi All, I validate a field on 'user input'. When i am using the keyboard to fill the form, on pressing the tab from the text field "executes the validation script". At this point, my cursor moves to the next field. This is fine when the validation is fine. If the validation fails, i want the cursor to stay back in that particular field, with the text selected. How do i do this? Thanks in advance. Regards Jos Raj Martin
Is it possible to create automatically a record in a form 2 when filling a form 1?
Hello, Is it possible to create automatically a record in a form 2 when filling a form 1? For example, I create an address for a new customer in an unknown town and I wish to record all towns in another form. I want that automatic. Thanks
Formula scripting changes automatically - How to correct this issue?
Hey guys I'm having an issue here and it's not with my math (I'm pretty sure...). The issue is I need this formula: ((New_Rent_Amount + Car_Payments + Insurance_Payments + Credit_Card_Payments + Loan_Payments + Other_Obligations) / (Monthly_Gross_Household_Income)) * (33.33) But after hitting 'Done' (it allows me to do it), it automatically changes to this: ((New_Rent_Amount + Car_Payments + Insurance_Payments + Credit_Card_Payments + Loan_Payments + Other_Obligations) / Monthly_Gross_Household_Income
Issue Editing Schedule in Free-form Mode
In GUI mode, my schedule was saved successfully. I decided to switch to free-form mode and did not make any changes, but when I clicked SAVE, it said: PS: related to http://help.zoho.com/portal/en/community/topic/is-creator-down ? John M. Whitney
Is Creator Down?
I've not been able to access my app for over 30 minutes. Houston, do we have a problem? Richard
iCal - tips
Hi, Few things I learnt along the way while trying to make iCal work with Google Calender iCal URL is too long > hence google gives > FAILED TO IMPORT The problem with google calendar is, the length of the iCal feed URL. Google restricts the iCal feed URL length to 225 characters. Please make sure that your generated iCal feed is less than or equal to 225 characters. This can be resolved by using TinyURL Works great with google calender & Outlook. I had set up a seperate Form / View to be used exclusively
Scheduler Not Working
Hi, I set up 2 schedules for the same form and neither of them are working.
Waiting for pulic access for 6 days
Please help I have been waiting about 6 days for my account to be public enabled so people can search the database on my website. Please can you enable it Thanks
Using Dates and IF decisions
Hi is it possible to use an if statement on a date field to show certain data depending on the date? If so how can I do this? Haven't really been able to figure it out. Cheers.
Can I copy fields in my form?
Hi, I have a rather long form (about 50 questions). I would like to repeat about 30 of these questions. One of the first questions is 'how many destinations did you visit'. If the answer is, say, 2 I would then like to repeat the following 30 questions twice - one for each destination. Is it possible to copy a field or do I need to input it all again? Hope that make sense! Thank you
Check of fields between forms
Hello, I am starting with Zoho and I'm having great time. I have created two forms. One is for contacts with several fields including Name and Company. Second is for event with several fields including Name and Company. The user must fill first the Contact form (no problem with this). Then each time he fills the Event form with a new event, I want to check that the couple (Name, Company) is existing in the Contact form. How do I do that? Thanks Jean
Lexical error , help
I have two forms that we use for booking rides Form 1 Add_New_Ticket one has the list of tickets that can be reserved, with two fields, one is a formula (Choose_Date_and Time) that has the date, time, details, the other has the date (Confirm Date) that zoho recognizes and can be put to use on a calendar. Form 2 is the Reserve_Ride form that customers go to to reserve a ride. Now when they choose a ride from the lookup field that references Add_New_Ticket. Confirm_Date_and_Time (formula), the information/same
Multiple Email address and SendMail
Please can someone tell me if/how it is possible to add multiple email addresses to the cc field of the deluge sendmail function. I cannot get it to work.
My form is now working - don't know what I am doing wrong.
Here is a link to my form (the url will change once my site is complete - so disregard the mess) http://3stepsuccesspattern.homestead.com/Re-CareerSurvey.html When I test the form and click Submit, nothing happens. I have it set to send me an email to let me know I have a new lead. Help would be appreciated! I've also applied for public access - still waiting.
Test forms?
I don't find it anywhere in search but is there a way to "test" a form after one has completed it to see if it is working properly other than setting it up on a web site? Tks - jb
Auto populate
I am building a form to capture owner info - name, address, etc. - and also property info. This info may or may not be the same. I have a check box to check if the info is the same - if not, to fill out the property info. When the info is the same, Is there a way to auto-populate the fields from the owner info already filled in? Also, is there a way to have the date automatically filled in? Tks - jb
Alert Boxes that are not "alert boxes" --- What Happened?
Oh my, what's with the redesigned alert box function? I've been away from Creator for several months so I don't know when this change happened. The Help documentation and 2+ years of direct experience w/ Creator taught me that when you created an "Alert Box" with the alert "<message>" command, an alert box (like what the world is familiar with) would pop up in your view to get an urgent message to you. But now, it seems Zoho has a better idea? Put the alert message down at the very bottom of
Strange Numbers Appearing in My Code
I made a copy of some code a couple weeks back. Here's a portion of it: Here's the same piece of code in the running application: What's with all the numbers added to my variables? The strange thing is that this code still runs. John M. Whitney
Creating a form counter
Hi there, I am new to Zoho Creator and I was wondering if anybody had any feedback or suggestions on creating a counter based on the amount of entries submitted in a form? I essentially want to have a view created where it would check how many entries are currently in the form and show the total number in that specific view. Is that possible and does anyone have any idea how this could be achieved? I appreciate the help! Thanks! Danny
Showing dates in an other language
Reports in my application shows date as 21-May-2011 how can I show the month in french as 21-Mai-2011
Create recurring calendar events
Hi, I had created a database using and I need to create recurring calendar events in the creator calendar. We need this because there are other fields that we use within creator. I someone can tell if this has already been talk about? I have to keep in the Creator. Thank you
Using the Count Function
I'm creating a form so attendees to a education conference can register to attend training courses that are on during the 2 day event. During that day, breakout sessions are scheduled, and at each breakout session, multiple training courses are running at the same time in different locations around the school. My original problem was creating a form to record the different courses chosen, but also create a maximum number of attendees per training course. I've managed to create a dummy form that can
Long form - 2 columns?
I an building a form for someone wanting to advertise real estate and need to capture all customer and property information - which may be different from each other. Also, all the details on the property itself. This makes for a very long form - can/should this be made into one or more columns and, if so, how does one do it? Also, how does one put Text information at the top of the form and between the different parts of the form items? Tks for the help - jeb
Having syntax error
I have two forms. One is Reserve_Ride with field dropdown Lookup Choose_Date and Time.and Confirm Date Form 2, Add_New_Ticket, has field Confirm Date, and Formula_1 Trying to populate the Confirm_Date in Reserve_Ride with data in field Confirm_Date from form Add_New_Ticket rec = Add_New_Ticket [Confirm_Date == input.Choose_Date_and_Time]; input.Choose_Date_and _Time = rec.Confirm_Date; But getting error message Lexical error at line 2, column 23. Encountered: "_" (95), after : "" Used this example:
Why isn't my app working????
I can't figure out why when I click Submit, the arrows just spin and nothing happens> http://creator.zoho.com/42infinity/undefined/# the bottom left of my screen (when on my website where th e form is) has a message: /addRecordValidate.do What does this mean???
Dumb Question?
And they say there is no such thing as a "dumb" question but this has to come close - In Creator, as in other parts of Zoho, it states the number of applications one may have with the different packages of pricing. But just what is an "application"? I have started to make up a "form" to capture data and it shows I have one application. If I now start building another form that will filter and return some or all of the first forms data, will that be a second application? Each form is counted as
Zoho forms - Iphone app
OK I'm a total novice at this, but can I create a form using Zoho and the include it so it can be part of an iphone app? Many Thanks, Gene
Function Problem -Please advise
Hello I have a problem ,whereas my form does not update my other form. Function is below. Please advise . Thanks void display.follow(string id, string projectname, int numoffollowers, list temp1) { openUrl("#Form:Follow?meetingid=" + input.id + "", "popup window", "height=400,width=550"); input.projectname = Post_a_Project[Recruiting_until >= '02-Jan-2010'].Project_Title; sendmail ( To : input.id From : zoho.adminuserid Subject : "Following
Sharing an application
I have an application that has been shared to a user. In their Zoho account it shows in their shared application section. When they open the app it says 'You are not allowed to access this application. The application is https://creator.zoho.com/bulla.training/bulla/share/edit/ The user with the problem is tracy@huntstream.com It has been shared with development. Thanks for your help Herb Wexler
Printing Dynamic Forms
I would like to be able to print out a form that has been filled out - these are very dynamic forms, so I would not want to print out the complete record which would have many fields that are not used for that particular record. Any ideas??
Check whether the datatype for this column is given as specified in the data-dictionary
http://littlemindslc.com/Employment1.aspx Getting this error:1 . [t_627083000000011051] Exception occured while setting value in PreparedStatement for the Column [Full_Name_627083000000016681] Check whether the datatype for this column is given as specified in the data-dictionary .[t_627083000000011051] Exception occured while setting value in PreparedStatement for the Column [Full_Name_627083000000016681] Check whether the datatype for this column is given as specified in the data-dictionary How
API insert record problem
Hi support, We using php in our server, and insert record to creator by API. In normal case, it works. The php and server email the report to us, said it is successful. However, we found that there are about 33.3% chance, the records can't find in zoho, even we receive sucessful report from our server. Any solution? Thank you so much.
Next Page