endless loop on stateless form
I have the following code on a stateless form. The user enters a last name and an id. If a matching record is found the data is loaded into the stateless form. If not an alert box is shown. The problem is with the not found condition. It goes into an endless loop. I close the alert box and it pops back up. Do I need to set the focus back to the last name foield? if ((count(NHS_Form[Last_Name == input.Last_Name]) > 0) && (count(NHS_Form[StudentID == input.Student_ID]) > 0)) { NHS_Rec =
Function based criteria gives error "Adding Criteria failed"
Hello I have the following setup: I have a form "Form1" where I maintain departments for users I have a function getUsersDepartment that returns the department for zoho.loginuser from "Form1" In another form "Form2" I have a department attribute based on a formula in which I call "thisapp.getUsersDepartment()". This works great. In the criteria for the List View based on "Form2" I give "(Department == getUsersDepartment())" I get the following error:Adding Criteria failed. Please try after some
Generate dynamic HTML views with stateless forms?
Hi, I found a bit of info on creating HTML views of data based on user selection in a stateless form. I think this is precisely what I need to do the following: display a customized html view of one record in my Projects database, based on a user searching for that record. I've tried on my own for an embarassing number of hours but just can't seem to get the pieces right. Can someone provide an example of how I might do this? I don't care how the data get passed, I just need a user to be able to
endless loop on user input
I have the following code on a stateless form. The user enters a last name and an id. After entering the id this code is called to verify the record exists. It works correctly if the last name and id are found. If the record is not found the alert message is shown. But it goes into a loop at this point. The alert box is shown over and over again. Is there something I need to add to put focus on the last name fiield? if ((count(NHS_Form[Last_Name == input.Last_Name]) > 0) && (count(NHS_Form[StudentID
Restricting items on a "view"
I would like to be able to restrict the items shown on a view, based on user input, as opposed to a using a fixed, pre-set criteria when I set up the view. For example, The user inputs an email address, and the view shows only the relevant records that contain that address in a particular field. Can that be done? Thanks Dennis
Unable to Delete view
Hello, I just started playing with creator and it is a great tool. I tried to add criteria using the not equal to operator and starting getting an error [DataModelTopic]. I tried to delete the view and received an unable to delete view error. tobywm
Global Variables
How do I define user-defined variables ? I see I can use them during Set functions, but I don't see where I actually define them.
Delete the CRM application installed from Market Place
Dear Users, We are having an issue while deleting the CRM application which you have installed from the Market Place. This is happening due to an issue from our side from some Functions in that application. Here are the steps on how to delete this app.... Delete the On Add-->On Success and On Edit--> On Validate of the Form "New User". Go to these HTML Views, Company Dashboard, Company Dashboard Perf chart, Company Dashboard Growth chart and Company Dashboard pipeline chart and delete all the HTML
Print Problems in IE7
Greetings: I have an app ready for deployment with the exception of a few nagging bugs. I have posted this problem before and supposedly you guys are working on it...but I really need a time frame as I cannot begin selling the app until I am sure this is going to be fixed. You cannot print out of IE7. If you have a view and you go to export to an an html view, the resulting output in a new browser session can only print the first page of data. And since you cannot export to pdf without losing
Cannot delete a copy of the CRM app
I have inadvertently copied the CRM app multiple times. Now I am not able to delete any of the copies. It gives me the following errors. Please help. This application components is used in the following places,Please remove this and try deleting the application The function 'thisapp.monthStartDate' is referred in following place 1.thisapp.salesForMonth 2.thisapp.salesForPersonThisMonth The function 'thisapp.monthEndDate' is referred in following place 1.thisapp.salesForMonth 2.thisapp.salesForPersonThisMonth
Function Number2Currency
I built a Function that formats numbers with commas for readability. I use it when I include numbers in an email or a screen field that is display only. I could not find any similar built in function in Zoho. Feel free to use this in your own applications. // This function converts a number to a string with the appropriate commas // Example Tot_Value_Str = thisapp.Number2Currency(Tot_Value); // If Tot_value = 1234567 then Tot_Value_Str will be formated as 1,234,567.00 // Herb Wexler 1/14/09 string
Function Not Working in Dynamic View but Works in Static View
I have a stateless form used to pass parameters on to a dynamic view through the openurl code. This is working great. However on that dynamic view I have a function button beside each record that uses fields in the dynamic view as parameters to pull specific records from another application through the openurl code. If I go to the static view and use the function button it works but when I go through the stateless form to the dynamic view nothing happens when I click the fuction button. Have
Using comma instead dots
Hi, I tried to insert values using "commas" (example: 160,65) in numeric fields, in the application I created on Zoho Creator, but the app only accepts dots (example: 160.65). Someone knows how to change this, and how to make the numeric fields accepts commas, please? :)
Coding Logic Is Messed UP
Hi Support, It seems that the coding logic in the zoho creator is messed up. The logic that was once worked no longer work. An example of the following code was placed under ON User Input: //If it's To-Do Activity, he all unrelevant fields if (input.Category != "To-Do Item") { hide Billable; hide Client; hide Lead; hide Professional; hide Contact; hide Assigned_To; hide Start_DateTime; hide End_DateTime; hide Hourly_Rate; hide Misc_Cost; } else { show
Error loading form - "unknown Task: Task Personality is 1300
An application that had been working for months recently stopped working. The error is "Error occurred while executing "on load" script. Unknown Task: Task personality is 1300. Error occurred. I've removed all programming from the "on load" event and the error still occurs. The form will load in the "Preview" view under the "Customize" menu option, but the application cannot be accessed live. Please advise what I can do to correct this problem. Thanks. seeley
Need help with criteria/filter of records of related forms.
I have 2 forms in a one-to-many relationship. Form1 = Job, Form2 = Notes. There are many Notes related to a Job. On the Job form is a JobStatus field with 3 choices, the default being "Active". Notes are created from a list of "Active" jobs. When the JobStatus changes to "Complete" or "Other", how do I filter the records in the Notes View to only display records of "Active" Jobs or conversely "Complete" jobs? The options don't left me select fields from the other form. Thanks for any help. Frank
Citation & Bibiolography
Nice! Would ther be a way at some point to categorize/sort the references by topic?
duplicate records
How to avoid duplicaating records ?
Duplicate seems to be buggy for my application
Settings Duplicate Share The button Duplicate when pressed does not create another application. any help how to copy application? i tried More Actions Save as Script but it stopped without any output. I shared out to you for debugging, please help :)
My app takes a loooong time to load.
Hi - My app (NWP Time) takes a significant amount of time to load (30+ sec). Any suggestions? Thanks, Kevin
Printing
Hello, I need this by tomorrow Morning so I hope that you can help, Please I need your Help!! How do I print out my contacts
ID Field
I have an ID field that contains a string value but and then I use that as a link between 2 tables. However In the view and the drop down the string that I entered shows up as a series of numbers instead to the text I enterted. What did I do wrong?
Printing
I wish there was an easy way to print the application once data has been entered. I want one form on each page. I know there is a way to export from the "view" tab, but that puts all of the date on one page, and then prints. I want to print each individual page with the data.
Acces Denied
Hello All! I'm attempting to share some databases with a friend. When they receive the invitation it returns "access denied". I've set them up for sharing. What else could be causing the problem? Thanks for your time & attention,
Edit access to view/form
Hi.. I have created application which has data entry form and its views. now i do not want to share my application to public so it is private. I want to share my form and views between my shared users only. 1. Data entry Form -- only shared by shared user-1 2. view-1 -- only view (read) by shared user-1, shared user-2 and shared-user-3 3. view-2 --- only edit by shared user-3 how can i do that ? please advise and your help is appreciated. thanks,
Calculation problems - Field not updating
Hello, I have 4 fields in a form that I need to calculate in order to present the result in a 5th, field, but I don't get to do this. :( I created the below code: input.Valor_total = (input.Valor + input.Juros + input.Multa - input.Desconto);So, if I put the above code on the "On User input" field action of the Valor_total field, it field is not updated after entering values on Valor, Juros, Multa and Desconto, with the result of the calculation, because it is the "last field", I think. I only got
Lookup Decimal Field - On edit Form data does not appears
Hi, 1- Maybe I'm doing something wrong, but i have created a Lookup field to import data from a Decimal field. In the form it works fine, but in the edit form (at the report Views) this field does not recover the data that i have put in the submitted form. It means that when i update from edit form, the data in this field change to null. 2 - My intension in my form is to give the change to users submit several hours (several beginnings and ends). Please consider make a Creator field only with
Open a view when opening app
Hello, Someone knows how can I set a certain view to automatically opens always when I open the app? Is it possible to open the same view when I open the app? Thanks. :)
Problem importing large database from Excel
I am attempting to import an Excel database with 438 rows of data in 34 columns. After Creator assesses the data, it asks me to press the "Finish" button to compile the full database. However, I can't see the "Finish" button on my screen. I have noticed that this does not seem to be a problem when I import a small database with only a few columns of data. Can you offer a solution to this issue?
On click events and Zoho Creator 3.0
Hello, I saw in some screenshots that there is a "On click" event form/field action, but in my account it does not appears. Is there some type of configuration I need to do, or is it another version of Zoho Creator? Thank you again for your help. :)
Stateless Forms with Dynamic Views - Nothing Happening
My problem is with a stateless form which holds criteria to be passed to a view (dynamic views). I've followed the instructions given in deluge help for dynamic forms using the "openurl" code. After clicking the button with the attached code the loading message appears with no actions. I even tried the example in tips and tricks provided by zoho and get the same results ( http://creator.zoho.com/zchelp/repair-details/# ). In light of this I don't feel it's any coding error on my part but a bug
Login problems in Firefox
There is a new login problem with Firefox and it is very frustrating... When you go to creator.zoho.com (or directly to any creator app) and attempt to login using Firefox it simply says "Loading please wait..." and sits there. You have to refresh the page to see that you are logged in and that the app is ready to use. With the print problems in IE7 one is confronted with a difficult situation. You can't use Firefox because of the login problems, you can't use IE7 because of the print problems.
View Criteria question
Hi, I need to create such criteria for my views so that people can only view their own department's data. As an example: u1 belongs to d1 u2 also belongs to d1 u3 belongs to d2 u1 creates records in various forms u2 can view all these records u3 cannot view these records At best I do not want to store department information in each form. The logical route to get to the data might be so: 1. Get zoho.loginuser's department. 2. Get the department's users. 3. Show all records that have added_user as
Shorten Info on feedback form
I have a reservation form at http://jaxareagolfassn.com/MtgNoticeMinutes/meeting_notice.htm. ; Choices of attendance are: 1) I will attend the meeting, have lunch and play golf 2) I will attend the meeting and have lunch only 3) I will not attend 4) Other, see remarks But I dont want to have all that info on my feedback list. I would like it to be: 1) 'M-L-G' (for meeting, lunch and golf) 2) 'M-L' (for meeting and lunch only) 3) 'NA' (not attend) 4) 'O' (Other
Hide/Show on Update
Hello, I am trying to use "hide/show" commands on "On Update" field action, but an error saying that this is not possible is being displayed. Someone knows if is there some another way to do it, please?
Update Income & Expense (form field)
Hi, I am trying follow this example: URL: https://creator.zoho.com/help/deluge/result_doc.jsp?url=functions-code-tt.html&query=update%20field#updateincome I create a functions and I have this code: ======= void updateincome() { x = 0; for each rec in Add_Income { x = (x + rec.Amount); } aih = Add_Account [ID != 0]; aih.Ac_Amount = x; } void updateexpense() { x = 0;
How to subtract 2 fields
Hello, I know that this is a simple question, but I don't get to make this run. :( I have a form with some fields, and would like to subtract two of it, as described below: Form: Baixas Fields: C_digo Nome_Raz_o_social Data_vencimento Data_pagamento Valor_bruto Taxa Valor_l_quido I need that the value on Valor_l_quido equals to Valor_bruto - Taxa. Is this possible? I also don't know if the subtracion can be displayed on the form itself or only in a view. So, I would be very grateful if someone helps
Session Tracking Cookie
Hi there, Zoho Creator 3.0 looks awesome, congratulations! I have one question... I'm playing around with ideas for building an online shop. I wondered if there's a way to track sessions, so that each anonymous user can have their own shopping cart? Eg. I have a form called "ShoppingCart", with two fields: sessionid, productid. When an anonymous user sees a product they like, they press a button like "Add to basket", which creates a record in "ShoppingCart" with that product, and a sessionid or similar,
How to fill a field depending of what was choosed on previous field?
Hello friends! Someone knows, please, how can I automatically fill a field based on the choose I made on the previous field? For example, I have a form which first field makes a "lookup" on another form. I want to fill the next field with the first field of that another form, based on the choose I made here. Is this possible, please? Thank you again. :)
Selecting a picklist value with script does not invoke the On User Input function.
After I populate a checkbox picklist with items I am using the field.select(<value>); The picklist has On User Input code that needs to execute on the selection. But what I am finding is that the selection occurs but the script does not execute. How can I progammatically invoke the On User Input function for a checkbox picklist? tt
Next Page