Edit mode is disable for certain forms
I have couple forms in zoho creator and one of those I can't edit any more. I don't remember if I did something to disable that. please, someone could me help to turn edit mode back !
email form data to different people based on field???
I am trying to enter in a "if statement" and I do not know how to write it. I know how to use the email portion, just not the if statement syntax. Upon form submission or update, I want not email a particular person based on the entry in a checkbox. I am not a programmer and the expression builder is difficult to use. Form is named: Leads Field Name: Send_To Check Box Options: Tim, Rob, Mike Please Help. Thanks!!!
data application
im unable to change from private to public view, why?
How to show views in a form?
I have one question to all. I am new in this - and made a form that is submited to a posturl to a new form - on this new form I want to show a some of the date collected in the first form. Is that possible? Ex. Form1: name, address. ....... Form2: show -> name, address........ in a grit/table and have them verify the input? Please help
Access to Data
I need to allow companies to Go from Step 1 to Step 3 in this application and then for me to be able to reveiw the submitted data. All the information I need is shown. I also need people to see only their employee information in Step 2.
Linking to the Form URL
I would like to link directly to a particular record. How do I determine the URL to put into my browser? Thanks much. SS
Problem: Unable to upload. Please contact support...
Hi, I cannot upload my access database, using the migration tool, and get the above error. I have the following .ds file: application "ALTprovision2" { section Forms { form altcourses { displayname = "AltCourses" unique IDProgramme ( displayname = "IDProgramme" Type = number ) IDProvider ( displayname = "IDProvider" Type = number defaultvalue = 0 tooltip ="Auto inserted from
Use a String-list rather than multiple "OR" statements
The question I have is if I can make an arbitrary string list: ZOO={"cat", "dog", "bird"} And reference that against a database: For each row in DATABASE [ZOO.contains(animal)] { //some code } ...would return true if the animal column is cat, dog or bird. I cannot figure out how to do this, or if it's even possible. The only way I know how to do this is using lots of OR's, and it looks inefficient: for each r in DATABASE [((animal == "cat" || animal == "dog") || animal == "bird")] {
Usage Limit for Schedules
I have talked to support 3 times to confirm that the usage limit on schedules in creator was removed for paying customers. In all cases i was told, yes this limit is removed for paying accounts. Upon reaching, and exceeding, my limit of 31 for a free demo account, i signed up and paid for the Professional edition. I have now discovered that despite 3 separate sales and customer support people telling me this limit was removed for paying clients, i have now discovered it still exists. I'm trying
Making form public
I am trying to make my form public but when I'm clicking 'click here to request for public access' it's not working. What to do now?
Empty second column displayed in form
I have a form in my application ('PlayerEntity') in which I moved all the fields from the right side/column to the left side of the form. When I edit a record the second column still displays. Except for a text in a field of type Note that streches accross both columns it is empty. Can you do anything about this? Regards Filip
Data Missing in Account
I have a client with an application I have developed for them and they have just reported data missing from the database. It is significant. Is there anyway to track who deleted the data from the database? Or when the delete requests were made? I can even provide an ID which is no longer in the database 506603000000737517 This is quite urgent as the client suspects foul play.. ~jono
column total from a loop...
The large 542.81 is meant to be a total of the column of amounts. As you can see it is displaying the last piece of information in the column rather than the total. The code i am using is listed below. What have i done wrong? What must i change to make this work? thanks htmlpage Date__Form1(From, To) displayname = "Expense Pie Chart" print = true content <%{%> <div elName='zc-component' formLinkName='Pie_Chart_To_From_Date' params='zcSuccMsg=Thank You'>Loading Form</div> <br><¬tualExpense = map();
Create invoice from Creator
Hello, I have signed up for Zoho Invoice to investigate if it is useful for me to create invoices from Creator. Zoho Invoice is setup, I have read your integration doc: https://help.creator.zoho.com/Integration-with-Zoho-Invoice.html And I have created a Form to test this. But I when I process the form no invoice is created and the log details says: Error in zoho.invoice.createdraft I can not figure out what;s wrong here. So some help is appreciated. The app (named FactuurTest) is shared to support.
URGENT: Disappearing records
I have a client who is reporting that just recently added records are being removed from the system. I reported this last night and have not had a response. https://help.zoho.com/portal/en/community/topic/data-missing-in-account This has become urgent. is there a way you can trace who or what is deleting records? I have removed delete access from all users and still records are being lost. Please either reply with a number I can call on or with some information Thanks in advance
Why the characters should be between 1 aND 2000 in the multiple choice questions?
I really dont get it
Criteria-based URL Redirection On-Load Briefly Shows Form
Originally posted here, and now re-posted as a separate bug to track. Problem: If a form's on-load script has an IF statement that checks for some criteria (i.e. date-time, ZOHO signed-in user ID, IP address, etc) and performs a URL redirection based on this criteria to some other page/form/view, the original form flashes for a second before the redirection. Issue: I can stop the page loading to prevent the redirection thus exposing the form. Also, the application just seems unprofessional by briefly
Help: Field values disappearing
Hello, I have a form A in which the name, registration number and other details of a student are stored. I have another form B in which the name and registration number are imported from form A and marks of the student are stored. I have a grid view based on form B in which I take the imported name and registration number from form A, and the marks from form B. As a result, in the view, the name and registration number are "non-editable" [since they are imported from form A] where as the marks are
Form View questions?
In the Form View, the default "Record Count" is 10 per page. Is there way to change that to the max of 200? Also, can I have default Form View to display "Company" in alphabetical order?
Check whether the datatype for this column is given as specified in the data-dictionary
I am getting the following error 1 . [t_539276000000206255] Exception occured while setting value in PreparedStatement for the Column [Formula_1_539276000000206279] Check whether the datatype for this column is given as specified in the data-dictionary .[t_539276000000206255] Exception occured while setting value in PreparedStatement for the Column [Formula_1_539276000000206279] Check whether the datatype for this column is given as specified in the data-dictionary What is happening? Why am i getting
[ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
I am having this again: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' while trying to view the definition of a form via the Scripting screens. I have opened access to support and will PM Ruben about this.
User access to html view popups?
My app offers user to view records in a nicer way (custom html views) than the regular Creator table by providing links such as follows: https://creator.zoho.com/filip.aulin/myApp/#View:myHtmlView?zc_LoadIn=dialog&recID=1234 When I am logged in as an admin it works fine. When logged in as a user the popup seems to get redirected and shows the 'Home' screen. Is there a permission setting I missed? Thanks, Filip
form disappeared AGAIN!!!!!
OK. Whenever I make a minor change to a field the form disappears and is inaccessible. Is this going to happen every time I edit something? We need this form up ASAP. Library Materials request form. Please inform when we can get it back up, and what I can do to alleviate the problem in the future. Thanks, Leslie
Report based on the view doesn't calculate count
Totals are not populating correctly even if I Regenerate Please take a look https://creator.zoho.com/mr.geek/swis/#View:Totals Thanks
Adding columns to a report...
I am trying to make a change to the Expense Tracker app in marketplace. I have added it to my account and allowed access to support. There is a section called Expense Pie Chart that i want to make a change to. The application shows a table and a pie chart showing all expenses for a selected time period. I want to add more columns to the table. I was able to add the header rows to the table but cannot get any data to work. I get an error when i save the script. <tr class="zc-row-header">
set criteria does not persisit
Dear Support When I set a criteria I often notice that it does not persist the first time it is loaded. This means that I have to open the box 3 times. Twice to get the criteria to load and then once to check its actually loaded hope you can fix this bug Regards Peter moanazoho
Linked fields & dropdown fields
I have a bit of criticizm for your implementation of linked fields. Linking is what sets you apart from Google Spreadsheet, IMHO. And I do have some dissapintments here. It is all fantastic and super while the linked field has a few dozen values. Then dropdown is practical, even checkboxes might be useful then. But If I have a few hundred items in the linked field the dropdown is the worst of all choices. Why not just a simple number or text field? I could even write my own verification code! Even
Split long sript into multiple lines
I have several sripts that have lines that are horizontally very long. Curent behaviour of the free flow scripting is not consistent - sometimes it is displayed as one long line (tis is good - see next why!) or automatically brohen down into sections that fit on the screen. I hate when it is broken down. As then the light gray text that is editable is overlayed with the original unbroken text. So often I have to type 5 to 10 rows below where the actaul code is and this later code is simply on top
Bug: Function is not being recognized in HTML view script save, though it is a valid working function
I've actually seen this same problem in different contexts a few times in recent days, and it's back now, so I'm reporting it. I have a valid working function, in this case named "getDayOfWeekName()" I'm using this function in an HTML view named "Dashboard" Loading up the Dashboard script into the editor, attempting to Save Script (either immediately or after modifying the script) will result in an error message about the getDayOfWeekName() function not being valid. See below: Yet, the function
Script slowing down browser on IE
Without any changes to my application today my users have been getting a pop-up message asking to stop running the script because it's slowing down the IE browser. Have there been some recent modifications to Zoho Creator that could have caused this?
Getting started
Hi I have created a form and now I dont know how to send to people that I want to send to could you send me a link that will help me on how to use this database, I am stuck
When creating a new form pressing DONE twice fast creates two identical forms
The problem is not that two forms are created. They are identical all the way down to the name. Editing one creates identical editing in the other one. They can't even be renamed separately. When the 2nd form is deleted, the first form is not deleted and appears empty (witout the fields that were supposedly added to the 2nd form but were visible in the 1st also).
URL which opens a view with criteria
How can I can add a criteria in my URL to open a view showing some records depending of the the criteria? Thank you!
On Success script broken
I have an 'on success' script on my 'add customer' form which opens a new sale form preloaded with the customer data: openUrl("#form: enter_sale?Customer=" + input.Full_Name,"same window" ); This script has always worked in the past but recently has become broken. After adding the customer, I get the following error: "There is no such component in ZohoCreator." Has something changed, or is there an error in my script? Thanks, David
3 and more level deep queries
Lets say I have 3 level relationship hirarchy (each come from a separate table/form): Company (account) Emploee (client) Order How can I get a table (view) that would dispaly Order number - Emploee ID - Company ID All three IDs in the same row. As I see now only 2 level deep relationship is shown when building a new view. Thus I can get Emploee ID and Order number togehter, but not the company ID. And views are based on froms so I can't build a view that queries Company and Emploee first and then
1) How to Navigate from a single Creator App... back my Business Console Dashboard? 2) Putting Apps on Console Dashboard ?
- If I use and/or edit one of our Creator Apps.. or am at my Creator Home.... - The only way I can get back to my Business Console Dashboard is to enter www.Zoho.com into the browser. 1 - Is there an easier way to navigate from a Creator App back to the Business Console Dashboard? 2 - Can we put our Apps right on the Business Console Dashboard or must we enter www.Zoho.com to get back there? thanks for any help.
PDF and PRINT buttons in HTML Views fail with bad URL
Definite Bug: Selecting Print and/or PDF options in Header Options of HTML View... ...makes the PDF and PRINT buttons appear in the live view of the HTML View... ...but, when clicked, both buttons send you to a malformed URL, thus no pdf or printing functionality. Please advise when this has been repaired. Thank you, Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Unable to access form for editing
There are only 2 forms in my app. I performed minor editing on one of them but cannot access it again for additional editing. The fields in the form shd appear in the right-hand side of the screen but instead it is BLANK. The left-hand side appears normal. However the 2 associated views appear normal and contain the chgs i made previously. Apparently the URL contains a digital code to determine which form or view is to be accessed. In my case the digits '15' cause the condition described above. However
Data prob
Hello, I dont unerstand why the form tells me that when I test it : 1 . [t_559703000000011051] Exception occured while setting value in PreparedStatement for the Column [photo_559703000000011598] Check whether the datatype for this column is given as specified in the data-dictionary .[t_559703000000011051] Exception occured while setting value in PreparedStatement for the Column [photo_559703000000011598] Check whether the datatype for this column is given as specified in the data-dictionary I wanted
Problem with a number iteration
I already did did this kind of operation with your help. I create an iterate number like that : yyyymmdd00001.... I would like to do a new one for another number field. I write exactly the same script of the other one and it dosn't work. When I submit, a message appears and tell that "invalid entries was found". I don't undesand the problems, that's now few days that i'm blocked with that. Can you help me please? You can access my application. Thank you!
Next Page