zoho creator data to google calendar?
zoho creator data to google calendar?
how to avoid overwriting
Hi there, I have a form „Leads” with one of the fields „Comment”. When I make a new comment I don't want Zoho to overwrite it, but to add this comment as a new record. How can I do it ?
Create Form with N-field (arbitrary numbers of instances of a field)
I want to give users the ability to list an arbitrary number of fields of a particular type on a form -- e.g., I have a URL field called "Specs" and I don't want to limit the number of "Specs" links that can be attached to a particular instance. How can I accomplish this?
i dont want any asociation with facebook or zoho
i began signing up for zoho till facebook came up as a part of it i stopped the application in midstream since i get unlimited spam from facebook unwanted and i never finished creating a zoho account [3407love] not my hotmail has gone to outlook on me more unasked for.unwanted invasion of my mail please remove zoho from any connection to me, my account, etc pls disable outlook i could not after following 2 sets of instructions please dont presume those were wrong and send new ones ---------------CUT
Can't hide field with Form -> On Edit -> On Load Deluge script
I am using the 'hide' statement to hide a field from anyone other than one particular user. I am referencing the zoho.loginuser variable to decide whether to hide or not. Here is my form called 'case' as viewed by the administrator in application execution mode where the field called 'approved' is not hidden (as expected): Here is the same form as viewed by another user. Note that the checkbox field 'approved' is no longer visible. Here is the code that I have in the two events in the script
Recursive Function Work
I have a need for a recursive function and don't know where to start. In the form shown below, I have a sub form for Unit Entry. I need to create a way so that every time someone enters a line item in the Unit Entry sub form the system will generate a list of those items with the same unit number, sales order number, and work order number but for each individual part, it will generate a new serial number. In other words, In the example shown, my user enters quantity 34 of the unit number 1234123.
Auto fill based on 2 sets of criteria
I have a database started and have made some headway in Auto-fill. My question is I want to create a form that will auto fill based on two sets of criteria. Currently I have a script written that will will auto fill based on one criteria. I want to be able to be able to auto fill based on the a Client ID and also the Product number (there might be the same product number for multiple clients, this is why I need the script to look at both criteria. this is the script I currently have: if (count(Extinguisher_Locator[Number
the warning for field type changing on new formula field addition
When I add a formula field the warning for changing a field type appears - see the screenshot below Regards, George Baltatescu Zoho Creator Developer
Hide Print opcion view
I need hide print opcion in one view embed in htlm view, zc_ print ?= false????????
Add contact email and phone number information on quote
Hi all, I would like to know how to add contact email and contact phone number information on the quote model inventory. Could please someone help me? Tks a lot. Felipe
Multi Select returns values in a different order than I selected them
Hi, anyone has an idea for my issue? I have a two multi select boxes, multi select 1 multi select 2 choice 1 choice 1 choice 2 choice 2 choice 3 choice 3 etc... etc... I select the following, in this particular order multi select 1 multi select 2 choice 3 choice 2 choice 1 choice 3 choice 2 choice 1 etc... etc... in my view when I go to analyse the info i entered, i should see multi select 1 choice
How do you format a formula
I am using a simple formula and i need to format it as currency. How do I do it ?
Sorting Pick List generated from Related Data
Hi: I have a Creator Application with several forms. Most of the form need a field that I am using as a relationship. To make things easier for the users I have a Pick List of imported data from the Personal Information Form. Here is the script code that generates the list: ust have Contractor_ID ( displayname = "Contractor" type = picklist values = Contractor_Information.Contractor_ID displayformat = [ " " + Last_Name + ", " + First_Name + " - " +
Ho do i Delete tabs on my App view?
I have 4 tabs that I made while learning how to do reports, Now how can i delete them? Help!!!!
copying the field from a different form
Hi all, I somehow have troubles with finding the answer to this simple question. I have two forms: -Companies -People Form Companies has 3 fields: -company name -telephone -address Form People has 4 fields: -first name -last name -company name (a lookup field) -telephone (I want the field to be automatically filled) How to set the field “telephone” so it automatically copies data from the field in form Companies ?
zc_ variable for private key
Anyone knows the zc_ name that we have to use to pass the secure key when we to insert view in html view without user login ? The insert view in html view is better than the regular IFRAME. <div elName='zc-component' viewLinkName='Rapport_des_rdv_View' params='zc_XXXXX=CM53WNP4jg8Bvt4pOKYAjeB78hSAeX99C86uBwAwUM3HkygeX1N9787f48EqkRTTBthhdKM9g5gwBxFBNPz8vVG2VPQXRK2pE&zc_Header=false&zc_AddRec=false&zc_EditRec=false&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_RecLimit=false&zc_SumRow=false&zc_Summary=false&zc_RecSelect=false'>Loading
HTML view + css: Chrome [blocked] The page at ... ran insecure content from
Hi everyone, I'm using a couple HTML views to display some contents on my website. The css formatting for the view is processed through a link to a css stylesheet on my server. Everything works fine on Firefox (see for ex. http://www.meridian-online.com/about-us/ -- scroll down), but I discovered Chrome blocks the loading of the CSS stylesheet... According to the developer tools, Chrome detects that this is 'insecure content.' Any way to circumvent this issue? Without the CSS, these views are rather
Show record data in form - but not allow edit
I have a function which brings up a stateless form and populates it with the current record information. The user then will edit some fields and click submit to update the record. I would like to make certain fields like redord ID, Name, etc, show up as plain text rather than in a editable textbox -- in order to show the user which record they are working on, but not be able to edit the information. Is this possible?
Search and Auto Complete
We are experiencing a problem with the Search and Auto Complete feature on some pick list fields. Our users love that the forms load faster in the case of very long lists and love that the search feature in addition to 'starts with' handles 'contains'. But, the pick list does not always populate with all the available selections. We understand that with the Search and Auto Complete option selected, by design the pick list only partially populates until the user requests additional items via search
creator custom domain for app
hi how can i share my app with custom domain name? for example appname.mydomain.com or custom-domain.zoho.com
Focus Traversal in forms seems to be vertical only
I've created a simple two column form like this: But I find that when I use / preview the form, the "focus traversal" is not horizontal but vertical. When using the form, after I fill the value for the left field of the first row, and I hit the tab key, the focus goes to the left field on the second row, instead of the right field of the first row. I think this is not intuitive, and I can't seem to find a way to make focus traversal be horizontal rather than vertica. ¿What can I do about this?
Has JSON Changed?
The url for viewing JSON data https://creatorexport.zoho.com/adminname/appname/json/viewname/ Used to display the feed data in the browser. Now it wants to download it as a file. I think this may have messed-up my application. Cheers, John Whitney
JSON feed does not display all fields in combined view
If we have a combined view and it happens that a field from the related form has the same script name with another field displayed in the view, the JSON feed does not display both fields, but only one. For example, let's say that we have a view based on Kids form The form contains the fields Name , FatherID (lookup field to Fathers form, which also contains Name field) , MotherID (lookup field to Mothers form, which also contains Name field). If in the view I display Name, Father Name (FatherID.Name),
Connect to an existing SQL database/server
Hello Guys, Apologies if the same question has already been asked, but i am having trouble understanding how to connect an existing SQL database to Zoho applications or if it's even possible to do that? Our current system is currently using an SQL database, so we would like to use the existing SQL database with Zoho creator applications. Any advice would be truly appreciated.
Invoking user input within a custom action
Hi, I'm a newbie and am struggling with how to approach this. I have two custom actions in a view - Pass and Fail. An example of pass is as follows: void test.PassTest(int id) { rec = Testing [ID == input.id]; rec.Outcome = "Pass"; } What I would like to do is when this button is pressed in the view the function prompts the user for one or more additional fields. I have created a stateless form but cannot see how to invoke it or pass the values from the form back. Is anyone able to provide
Edit data directly
In addition clicking on the 'Edit' icon to edit existing data, I would like an additional quicker way of editing data. Specifically, I would like the ability to double-click directly on any of the data fields of a 'View' which would open the field up for editing. Thanks.
forms and permissions - is it possible
Hi all, I have a question regarding forms and permissions. I have two forms:- People - Project The User inputs data in the form Project. Fields also include fields from the form “People”. When User inputs data in the Field “Name” in Project, he firstly is able to check whether certain person is already present in the database, if yes he can simply add this person to the project. If no he inputs new record, which is automatically copied to the Form “People” User does not have access to People View:
Internationalizing an application
Hi, I am building an app for a recruiting company that takes applications in four different languages (English, Spanish, Tagalog and Hungarian). Is there an easy way to 'internationalize' the app? By this I mean I want to be able to re-label all of the text fields in the appropriate language. My initial thought was to use stateless forms to populate the main form. However, this won't work because I am using sub-forms. The only other option I can think of is to just duplicate the form and change the
Free Flow Script - Chrome visibility
The problem occurs in the Chrome browser. When I view script via "Free Flow Script", I do not see and cannot edit anything. When I change to "Script Builder", I can see and edit the code. It was working fine yesterday but I cannot edit my views, forms or functions using the free flow script editors. Can someone please investigate? I have tested it with IE and Safari and it appears fine.
SQL statements in Zoho
I am now beginning to understand Zoho a little better. Obviously there is some sort of database in the background that is at work when we use a Zoho app we have created. 1) Is there any way to have access to the database for my app through SQL statements either to execute some sort of transactional statement or statements? Ex. "Update mytable join mytable2 on . . . set myfield=1, myfield2 = 2 . . . where . . ." "Create table . . . " Etc. In some of these cases we would need to know to to access
I need a piece of code to clear certain fields on user edit.
Alright, Basically, I have a form (current form). Once I add/update a certain field, the records of that row of that field is copied to archives. So I need it to clear certain fields (on the current form and not the archive form) once I update this certain piece of information. For example, (This is a bike application) Customer checks out bike 1, once the customer brings the bike back (actual check in date), that row of records will be moved to archives. i need it to where i can clear certain records
openURL - popup window works but same window and parent window do not
I have multiple stateless forms embedded in my website. When the first form is completed the user presses a button which is supposed to load the next form. I am using - openUrl("#Form:Client_Information_SL?Client=" + input.Client_search, "same window"); behind the button. When I click the button which runs the openURL command nothing happens. If I change "same window" to "popup window", the correct form is loaded as a popup and overlays the previous form. In other words, the "popup window" parameter
sharing form with public
I cannot seem to understand how to allow the public to access an online form I create ... I simply want to create a registration form, then send out a link to the form ... how can I do this ? I am a free member -- does this functionality require upgrade ? I am missing something here, I think :) Thank You Bill Clark kappclark@yahoo.com
Criteria in a view of a form with a subform
Hi all I have a form (treatments) with a subform (payment cards). In the subform I store each card payment. One of the fields is the due date of this card payment. I want to show in a view treatments that have their overdue payment last letter (dated before today). The problem is that it shows all the treatments that have some payment card with the date before today, instead of displaying only those with the date of last treatment before today.
Bug: Red line covering on-click
This is under my other account: sigroup/si-ni-chemical-inventory using IE 9.0.8112.16421 The red line prevents me form editing the code. Also this form is not working. Shared with support.... Cheers, John Whitney
Can't edit our apps - Enterprise user - Urgent!
The Zoho Creator app editor appears to be broken for our main enterprise account. The main account holder is Danny Quarrell, dannyquarrell@altaplanning.com. Neither Quarrell or any of our assigned developers can access the app editor for any of our shared apps. URLs such as https://creator.zoho.com/dannyquarrell/form/286/edit/ load blank screens. The editor appears to work fine for personal apps in other accounts (e.g. https://creator.zoho.com/dmoskovitz/form/14/edit/). I tried different browsers
Any tips to show embedded slideshows?
I'm looking for a way to build a small knowledge base that will include Zoho Presentations. 1. User opens the KB view to see all the articles. 2. User clicks a custom action (button) on one of the rows to display the record. 3. The record pops up in VIEW mode and has some descriptive text along with an embeded Zoho Presentation. Is something like this possible? Thanks, Jeff
Need to Setup Schedule for Jobs 2 Months Out
I'm trying to use the Zoho scheduler to remind employees of jobs that are 2 months out (from current date). I'm using the custom schedule option. So, I'm trying to first fetch records with the following criteria (in the fetch records GUI): zoho.currentdate.addMonth(2) >= Job_Date1 Job_Date1 is the date field in my Jobs form. It's listed as a "Criteria Fields" in the fetch record GUI, but its not in the "Variables" area of the GUI. I assume that it needs to be in the Variables area which is why
Remove "null" values from email
Hi Is it possible to remove the fields with the value "null" on the email notification that Zoho sent out? BR Dennis
How do I split up applications?
I was just wondering how specific I make an application. For example let's say I have 3 clients. Do I make a single application for each of them them put their appropriate forms in that application? Right now I have different applications for each appropriate "table" and then for each client. So I have applications for "Company 1 Clients" , "Company 1 Staff" and "Company 1 Jobs". Then "Company 2 Clients" etc. Should I just make 1 application called Company 1, then make a form called clients, staff,
Next Page