Export Back-ups
Hi, I have 7 applications and I will be making more soon. I would like to back-up my data through exporting it all onto a excel speadsheet (each different application). I was wondering if there was a way to get them all to download at once with one click instead of going on all of them and doing it manually and if possibly there is a way to do a scheduled back-up some how? Thanks
Conditionally Call Paypal
Is it possible to conditionally call the PayPal function? For example I'd like to have a radio button options to Pay online Pay at the Door If they choose Pay online it takes them to the PayPal screen otherwise the form saves normally. Herb Wexler
HTML View Problem
I am evaluating creator for possible use by our company. I am having a problem grasping the concept of the HTML View format. I have my form created, and have created many working view with that. I would like to create an HTML view to report on a single unique record row from my table/form. I understand how to build the HTML portion, but how do i display data from the form in the view specifically. I have passed the variable that I need to set up the criteria to select the correct row, but how do
Opening View from list and passing record ID
I am new to custom programming within ZoHo creator and am having difficuties in creating a function that will open a custom view with the lists record ID. I have the custom view called Quote_Review_and_APQP_Tracking and here is the inital Free Flow Script htmlpage Quote_Review_and_APQP_Tracking(potential_idstr) displayname = "Quote Review and APQP Tracking" pdf = true content <%{ curPotential = Potential [ID == input.potential_idstr.toLong()];%> I have created a custom function called
How I iterate the loop without using form data
There is 'For Each Record' is iteration loop in Zoho creator But I want to iterate one html view in 7 times with incremented date. How I resolve this problem by using Zoho creator? Please Reply
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
Next Page