Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
how i transfer value from one form to another?
I want to transfer one form value to another form and which is also display in view.
Import Data fails with set variable validation
Hi, In my app (app name PIM), I currently have a form called 'Categories', which has the following fields: Root Category Child Category Grandchild Category Website Category I want to be able to import this information and set the Website Category automatically based on the following formula: Website_Category=(((input.Root_Category + if(((input.Child_Category).length() = 0),"","/")) + input.Child_Category) + if(((input.Grandchild_Category).length() = 0),"","/")) + input.Grandchild_Category;
Unable to add or edit records
We are not able to add to any records in the database ("please wait" continues without proceeding") nor can we update any existing records. We have tested in the latest version of all browsers.
if and else if are they counted differently when it comes to number of Deluge statement executions
Hi, I think i read this somewhere need to verify maybe i understood wrong when counting number of deluge statements executed would this be different 1) if ( a==b) do b if (a ==c) do c 2) if (a==b) do b else if (a==c) do c thanks ...
Zoho Creator - File upload with Google Docs
Team, The file upload field does not work for Google Docs. It displays the file name (sometimes) but nothing more. The Google Docs link is not importing. I see that you are working on this in CRM forum. Will it be corrected in Creator as well. Thanks
Importing Data and Code Execution
I know that On Load and On Change code is not executed when importing data. However I was under the impression that On Submit code would be executed. I'm not seeing this happen... Cheers, John Whitney
Embed a View with Export, Print, and More options
Pretty sure I know the answer is no, but I thought I'd ask just in case... Is it possible to embed a view with the Export, Print, and More Options menu buttons? The reason I'm asking is because the URL in my client's application kinda gives away too much for custom filtered views. By embedding it, the url is less obvious to the casual user. And my client wants the Print and Export buttons. Cheers, John Whitney
Zoho creator+google maps
mesporatitech.blogspot.com/2007/11/using-zoho-creator-yahoo-pipesand.html Note:I will upddate links and Images for your Reference shortly Intro: Integrating Data (overlaying in developer terms) onto maps (Google, yahoo) has become a fad these days, the applications range from trivial to Interesting. By opening up their Mapping platforms Google and Yahoo, have given Interesting framework on which developers can build their applications. In the same manner, Zoho creator offers end users a brand brand
Adding Gapps application Screenshot
When i access application it not show the data
How to use GApps lookup field
Hi we just bought ZOHO Creator with GApps after evaluation right now i just created a form with GApps lookup field but it does not work (the dropdown field not showed) also i try to add a Users dropdown and use script with Users:ui.add(zoho.gapps.users()); but i just got following error message Error details:Error occured while on Load script.Some preliminary set up is required for this task zoho.gapps.users. Please contact the workspace owner to do any actions on this application.
In View row add another form,Is it posiible? If yes then how
I want to create attendence form in that there is 7 dates and for 7 dates i want to add separate In time and out time. How i get resolved this problem?
Can i use nested view in zoho creator? and How
I want to create attendence form in that there is 7 dates and for 7 dates i want to add separate In time and out time. How i get resolved this problem?
Can I remove a client that an application is published to so they no longer have access to the applicaiton?
If i publish an application to a user (with out developer access) and later I need to remove this users access to the application is there a way to do this? I cant see anything in my developer zone. Im thinking I cant because the application is now on the other users zoho account and has data that likely we dont want to lose. Is there a way to remove access ? If not does this mean in order to maintain full control of all databases, I need to own all zoho accounts that I share the application with
Required only Time from date time field
I drop date time field ,but i required only time. So, I write on User Input Field action code as : In_Time=input.In_Time.toTime(); But this script take much more time to display only time.Please tell me another way to solve this problem.
Problem in accessing an XML Node which is retrieved using REST web service
Hi, I am creating an application that gets the data with a REST call using "get url" function.I am passing some parameters as query strings along with the REST URL. I am able to get the response xml.But could not access the value of different nodes of that xml. Below is my response xml, <?xml version="1.0" encoding="utf-8"?> <ResponseArray xmlns="urn:mdWebServiceAddress" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Version>2.0.56</Version> <TransmissionReference>
error in accessing and updating sub form variables depending on Condition in main form using a Stateless Form?
Hi, I have created a main form called "Main_Form" that has "FName" field. In the sub form called "Sub_Form" that has "Last Name" and "Address". Now i want to update address depending on "FName " in main form and "txt_LName" in sub form using a Stateless Form. below is the code written in the "Stateless form--->Custom Button-->OnClick" action . r = Main_Form [(FName == input.FName && Sub_Form.txt_LName == input.ddl_LName)]; r.Address= input.Address; But i am not able to update the address,
Gapps
Please any one can sent me how use Gapps.Its not working on my account.If i login with application owner account also it not working.Please send how i get resolve this problem....
Populate Single line field and Multi line field depending on value selected in a Dropdown(Look up field)
Hi, I am new to Zoho and have a problem in populating related fields, I have "Form A" that includes Student ID,Student Name,Student description. "Form B" includes a sub form "Subform1". This "sub form 1" refers to a Form C that includes fields, " Student Id -- Dropdown (Look up field)" "Student Name --- Single Line Field " "Student Description -- Multi Line field" Now, What i want is, When is select the student ID from drop down, related information of student has to get filled in Student name
report totals settings
Hi, I've set .round(2) for every numbers in my app, but in reports, impossible to set the number of decimals displayed. So, when you have percentages in the numbers, you have totals in reports like 12345,895569988115 Totals in reports should use the same display options like in numbers, as for example .round(2). Is it possible ?
how to transfer result from 1-st formula to 2-nd formula?
Hi i just wrote application with 2 formulas in it. 1-st formula is too complex&long and uses "if-thenif-then" calculations. how can i result from 1-st formula (numeric value) supply to calculations of 2-nd formula in same application? thank you!
How do you create a date variable
I am building a function and I'm trying to create a date variable... instead of a variable of type long: DateToAdd = input.startDate.addWeek(WeekCount); That creates a string for the variable DateToAdd... is there a way to do this?
Problem Creating or Duplicating Calendar View
When I try to Create a Calendar View, the form drop-down menu shows no forms. When I try to duplicate a Calendar View I get this error:
Is is possible to hide fields in edit form in a one view but not others
I have a large form and I would like to make it easy to edit certain fields depending on the view. Is it possible to hide fields in edit mode depending on the view you are in?
Is it possible to get the IP from a website-name in ZC?
I am wondering of ZC can be used for the reading of an IP-address that belongs to a website, like PING or http://www.selfseo.com/find_ip_address_of_a_website.php can show?. It could be possible within ZC, or, perhaps, by using a service to which you send a URL which returns the IP-address. Reason: I use opendns to protect my users on the home LAN. My old ISP allowed both a fixed IP and the sending of Dyndns info to TNS-O-MATIC on my router. My new ISP does not allow me to use DynDNS type of updating
Displaying ID as different fields
Hello, For some other issues I have to use the "ID" to link one subform to another. Which is fine because in forms you can use the "Display as" advance option to display the field as a Drawing number or whatever else it may be. The problem is that in a HTML file it is displaying the ID as a long number - how do I script it so that the Drawing number (or whatever else I may be using) is displayed rather than a long, unrelated number? Many thanks Ben
Fetch records not showing in shared user
I have a HTML View. It has a search form and when I press submit I get the desired result under it. But when the shared user does the same , instead of showing the result , he is directed to the main form. Pls tell me how to solve this issue.
"If Updated" Condition - Accountants/Book-keepers, Deluge Experts Please Help
Hey, I'm a little stuck on a problem with a script that updates a dollar amount and a percentage of an account's balance being paid off when a record is edited in another form - It works fine in the "On Add - On Success" action, which the vast majority of entries would be, but I can't seem to figure out how to get it to work or where to put it when "On Edit" Here's the script, where the new "Manual Payment Entry - Amount" record adds to the "Payment to Date" in the Contact Form Record, and calculates
NView not defined in the Workflow
I got this error message when attempting to save a section code ... NView not defined in the Workflow My code is selected_vehiculo= Veh_culos[Cliente_ID = cod_Cliente]; clear row.ECO; for each x in selected_vehiculo.ECO { row.ECO:ui.append(x.ECO); } How can i fix this problem?
Looking to hire someone to create my form
Hi, I am trying to create a application that takes in around 10 pieces of information from the website user. Depending on what has been entered, it then provides a final value (formulas required). The application is based on hair prices and the estimate value of the piece of hair will depend on things such as colour, length, if it has already been cut or not. As these are not all numerical values (for example, hair color), I cant figure out how to create the formulas. Furthermore, depending on what
Multi Select addition
I was wondering if there was say a formula or something that would add up each time an option in my multi select gets selected, and maybe total each option?
Functional URLs
I have a very simple search (Find nearest instructor). I want it to take the first half of a postcode (HU3, HU6 etc etc) and display records that match. Honestly thought I had it, but seem to be stuck! Any ideas (edit access given in hope....or maybe desperation!!)
Add or append values to a multiselect list from within a function
Hi, Am trying to do this Form A has a multiselect list could be (list or lookup) with say A, B, C From within a function i want to write "D" to the list, it does not get updated as D is not part of the list defined in Form A uu.Multi_Select_1 = thelist; (where the thelist contains D) Basically i am trying to emulate ui.add or ui.append from within a function Is this possible, i can live with a blank multiselect in Form A to which i can write any type of list also thanks
Update Multi Select lookup via scritp not following list order
Hi, I have a form with a multi select lookup field no alphabetical sorting set on the lookup field My other form which has the lookup values has lets say rows A , Z 1, Hello From a script i update the lookup field and my List:String({"A", "1", "hello", "Z"}); Problem, the updated lookup is not following the order of the elements of the List:String which i used Actually not sure what order it is following, maybe that of the form lookup, all i know is that it does not seem to follow the order i want
Tier 3 menu creation
Hi .. In my application The Top Menu is my Main menu and the Left menu is the Sub menus of main menu . Now i need a Popup menus for sub menus of Sub menu . Is there any possibilities to create popup menus or sub menus of sub menu Ex: Tier1 - Money Fact ---- > Main menu (top menu) Tier2 - Real Estate ----> Sub menu of Money Fact (Left menu ) | | Tier3 - Getting started Ownership These are my Sub menus of Real estate
How to? publishing app to marketplace that requires certain views to be set as public, views within HTML views to display without login.
If you publish an app to the marketplace without code, do the public/private settings for views and forms install with the application? Or would the client need to be instructed to set certain views/forms to public if the app requires it to function as intended? What is the best way to code a printable HTML with an embedded view, so that the user can then embed this HTML view into their website and display it without login? So far I see only two ways, make the form view public and use the "embed
How to add data to Zoho table from HTML view?
I have an HTML view that displays data from a ZOHO table called "Options". The HTML view also displays a radio button in the first column in each row of data in my view. Up to this point everything works fine. From here, what I would like to do is to allow the user to use the radio button to select an item in the HTML view and then save the selected item to a different table called "Selections". There must be a relatively easy way to do this but I am just not sure how to pass the user's selection
Create records in one form from a multiselect lookup field from antother
Wonder if someone can help; I am trying to find a way to select some records from one form and then use these to create new records in another form. At this point I have created a stateless form with a multiselect lookup for my unit "serial number"s and an action button. I have then tried to create a script for the button; 1 for each key in input.Serial_Number 2 { 3 insert into test 4 [ 5 Added_User = zoho.loginuser 6 Serial_Number = input.Serial_Number 7
Making a field required - code not working
I'm trying to make a field required if the check box above it is checked. This is the code I've input, but it comes back with an error. ((input.VAT_registered == "yes") && (input.VAT_number == "")) { alert "Please enter VAT number"; cancel submit; } Please help! Thanks J
Any way to sort forms listing when adding a Lookup drop-down menu?
As the image below illustrates, there seems to be no clear order or logic to the listing of forms and their fields that is displayed when inserting a Lookup drop-down menu into a form. My application has many forms, including many that are not in use, so the listing of forms is long. So, when inserting a Lookup menu into a form and needing to identify the field of a particular form to import from, the long list is unsorted... clearly it would be better if it were alphabetical by form name. Is
Next Page