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
Recommendation: allow some simple layout control in live Form views
I'm sure most of us have at one time or another wished we weren't constrained entirely to only one way to have our forms laid out. Currently, like it or not, we must all live with two vertical columns for fields that stack vertically into those columns -- one way. Well, it could be worse, but it sure would be nice to be able to have greater control of that layout with more variety of options. One simple option that would make a world of difference in some forms would be to control the width of
Non documeted limitation - maximum number of Expressions in HTML view in Edit Mode
Dear Zoho Creator Team, What is maximum number of Expressions in HTML view? According to my testings more than 200 and less than 400. And limitation is that HTML view with such number of expressions is loading FOREVER in the browser. Limitation is presented in IE, Firefox, Chrome. Below are described steps to reproduce this behavior. Step 1. Create HTML view: htmlpage Expressions_400_Bug() displayname = "Expressions 400 Bug" content <%{ a = "b";%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%>
Zoho xml rpc request returns success but no record in database
I have problem with my application, when i try to insert record from custom html form from localhost i get success response. But when i try to view records in the database view the record is not there. And if i delete record from my view and then i try to insert new record i get success result and the record is there i can see it in the view. By the way i am sending the post request with php curl and it is working ok Any help with this will be appreciated. Here is the code: $apikey = "xxxxxxxxxxxxxxxxxxxxxx";
Share Bug
I made my application public then reverted to private. Then I attempted to share with a user and got: buzzap/abis is shared with ZC support Cheers, John Whitney
Set subform field only to Display
Hi ZC Team I have a Form with a subform, when I click on Add I have a field on the subform that is completed with a value existing on the parents form. What I want is to show as today but disable the possibility that the user update that Field (is a dropdown field) I was trying at subform level on Load Add disable but it doesn't work, is any way to only display a field in subform and avoid alter it?, please let me know. Thanks a lot. Victor Miranda
Given several applications and many users, how can I associate applications to users?
I have 3 applications and 5 users (u1,..., u5). I want application 1 to be used by users U1, U2 and application 2 to be used by users U4, U5 and application 3 to be used by user U3 only. I will be the admin for them all. Is that possible in ZOHO Creator? Thanks.
Using zoho.adminuser variable instead of static "ownername" in urls
I want to publish an app to the market place without code, ie client can't have edit mode. I have certain html views that happen to have url links that include my app_owner_name. The variable zoho.adminuser returns the username of the application owner. Is there any way to construct an url to a view/form with the variable instead of the static <ownername>? Example: http://creatorexport.zoho.com/myname/app_name/print/printable_HTML_view Where zoho.adminuser replaces "myname" so that anyone who downloads
How do you update a CRM record from a Creator form when you don't know the CRM ID?
Hi I have a script which simply adds a record via a form to Zoho CRM. tenantinfo = { "Salutation" : input.Salutation, "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Mobile" : input.Mobile_Number, "Email" : input.Email_Id, "Date of Birth" : input.Date_of_Birth, "Employment Status" : input.Employment_Status, "Organisation" : input.Organisation, "Monthly Income" : input.Monthly_Income, "National Insurance No." : input.National_Insurance, "Other Street" : input.Current_Address, "Other
Next Page