Reset radio button on edit record?
Is it possible to reset a radio button to a certain value when I edit a record? I have a radio button with the simple options of "Yes" or "No". How can I make it so that when I click "Yes" and then submit that the next time I edit that record the radio button goes back to "No" automatically? Thanks in advance for any help
How do I assign an image to image upload field?
I have an image upload field in my form. The image upload is optional - but I want to provide a default image for those cases when the user does not upload an image. Sorta like a "no picture available" type graphic which gets stored with the record. How can I get the form to pick up my "no pic avail" image into the image upload field? And where would I store the image so that the script can access the image?
For each record criteria & formula fields
I have two forms (A & B). Form A has the following fields: Lot Description formula field combining the two fields Lot_Desc. Decision box Form B has a lookup to form A using the Lot_Desc field. In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria? for each x in Batch [Lot == input.Lot] works for each x
Google Calendar iCal feed setup question
I am trying to add a Zoho Creator ical URL to Google Calendar without success. In Google Calendar I go to Add/Add by URL then paste in the following ical URL and select 'Add Calendar'. I get the following error...."Failed to add imported calendar at https://creatorexport.zoho......... for user@gmail.com" I followed the ical feed steps at http://help.creator.zoho.com/iCal-Feed.html My Zoho App is private, so I selected the link that adds in the encrypted code. I've tried two versions of the URL.
Set a variable in a FORM from a VIEW
I've figured out how to do some custom actions / functions within zoho -- but now I'm trying to figure out how to have a custom action in a VIEW populate 2 fields in a FORM. This is an application that helps us manage child sponsorships in South Africa, Moldova, and Brazil. We're trying to add a little more functionality -- and have photos, ages and first names available for people to look through as they are setting up a new sponsorship. User Action would be like this: User goes to VIEW - which
script for returning values in a Multi-Select field
Dear Friends: I'm a newbie to databases and scripting, so I need a very basic helping hand. I've created a database to collect data about metrical events that occur in lines of poetry. The fields I've created, together with abbreviations I use for the individual events, are these: Lines (Single-Line) Properties (Multi-Select) Penthemimeral (Single-Line) (pc) Hepthemimeral (Single-Line) (hc) Bucolic Diaeresis (Single-Line) (bd) Homodyne in 4 (Single-Line) (hm4) Heterodyne in 4 (Single-Line) (ht4)
In a view, how to prompt for text and then set specific fields to that value for all selected records
Subject pretty much describes it.... Want to have a custom action which prompts for some text, which then sets a specific field of all selected records to that text. Any pointers anyone? Thanks in advance
Syntax error: function doaction(recType)
I have a form that has three fields: one drop-down, one text entry, and one checkbox. I have this code in the checkbox, on user input: if(input.Tickybox == null) { enable DropdownField; disable TextentryField; TextentryField=""; } else { disable DropdownField; enable TextentryField; DropdownField="-Select-"; }When I go to the form, I can check the box once and have it work as it should, but subsequent checkings don't work. In Firefox's error console, this comes up:
Query a XLS table
I'm new to Zoho creator and I wonder if it's possible/where to find a working example of what I plan to do. I basically want to create a status checking application where I will import an XLS sheet that contains email, password, status and other info. The users will be present with a form that contains email and password field. When submit, it will query the table and depends on the value of the Status column, will return different custom message. I will update the XLS offsite and upload the XLS
Can I create an online calculator for my website?
Hi, I am a wedding photographer and I am considering building an online calculator which will cost up wedding packages for prospective clients online. They would enter information from dropdown lists like year and month of wedding, then choose which services they want with radio buttons and checkboxes - this will then calculate a price for their package. They should be able to print that quote out - and I should get a copy of it emailed to me. However when the page gets refreshed it should go back
Ability to perform an action at a future date
hi im new to creator, so this might be a stupid question, but an answer to this might get me to work on creator. you could even point me to the right direction i need to create a very simple tool where we feed in a future date and time with the comment and the comment goes to a web URL on that date and time. basically like a reminder thing. is this possible with creator. thanks in advance
How can I sum the field of all the entries of one form?
How can I sum the field of all the entries of one form and show it in a field of another form like a "formula field" for example. I have two forms, one with people and another one with bills. The bills form have also one field with the price of the bil, and another field with the name of the person ( of the person form). I wanna do a form that shows me the sum of all the prices of the bills that have one person, for example. is the solution a formula like "count"?? Which formula? Who it works? Thanks
Opening pop-up views with multiple criteria
I have created a relatively easy function to open up a pop-up view: openUrl("#View:vwLangAvail?cboLanguage=" + input.Language + "", "popup window", "height=100,width=100"); Is there an easy way to have the view open with multiple languages selected? Thanks, Leo
Zoho Sign-in Box
Is there some way to have a Zoho sign-in authentication box in my form, or as a pop-up, or DHTML type floating object?
I would like to create a consultant book system
Looking for a template to modify for the following application I would like a user to check a calendar for a particular geographical location to see whether a consultant is available for that town at a particular time and date for one of 4 training courses. The consultant must be able to modify an online calendar to say whether they are available or not and which courses they are qualified to deliver etc. Once the user tries to select a date and time it should be reserved and the consultant will
Need help with login question
Hi friends, I need help with a workaround. My users are not on Zoho, so I have a simple login form to determine if they are registered to use our appointment system. they enter a login (their email) and password in a stateless form . If that email is in our database with the correct password, the login form sends them to a url with a second form to schedule an appointment. I needed a way to save the logged in "state" of the user so that when they get to the second form, I know who they are and
Not duplicating app
Hello, I'm trying to make a copy of an app that i created, but it's not working, so I tried to save as script and load it, but this did not work either, then in my Home sectons I clicked the button Duplicate but also didn't work. So I tried to import from a MS Acces database using your migrations software but again, it did not work... Is it a temporary bug or am i doing something in the worng way? Thanks Rodny :(
How to create a relation 1-200+?
Hi I have one form where I can enter stakeholders. For each stakeholder, I would like to select his requirements. Around 20 requirements per stakeholder. These requirements are stored in a table, about 200-300 requirements. How can I create a from where I can "add" requirements in a nice way? If I do it like here http://zohocreator.wiki.zoho.com/Creating-relationship.html I have either 20 very long dropdowns or 200-300 checkboxes. Both not very userfriendly. I would prefere something like a dropdown
Stateless Forms
There three distinct types of buttons: Submit, Reset and Custom buttons in Stateless forms. So Could you tell me what is different about the 'Submit' and 'Custom buttons'?
Limiting the Amount of Text Displayed in a List View
Hi. I have a table displayed in a list view which has a couple of multiline fields. Because these can be up to 65k characters, they can grow quite large and make a compact display impossible: Is there any way, for display purposes only, that I can limit the amount of text, while not disrupting the actual underlying data? Thanks very much! matt
Passing key fields to other forms as a global variable
I just started with Zoho Creater this morning - it seems like fantastic scalable application !!. !I am having problems with creating a common key field called DEAL_ID and using this to pass to other Forms as the key field. I have tried various ways such as using a script on the form called New_Deal DEAL_ID4 = input.ID + "_" + input.Deal_Name; share form("application", DEAL_ID4); But this does not seem to pass the DEAL_ID4 variable to any other Forms in my application ? Would appreciate any answers
Infinite loop when using replace function
I have tried multiple ways to get zoho to stop replacing text when the first replacement is done, but cannot get it to work. The code I have right now in the on user input section of the Reference Name 1 field is: refName=input.Reference_Name_1; if (input.Reference_Name_1.contains(" ")) { refNameReplace=(refName).replaceFirst(" ","%20"); input.Reference_Name_1=refNameReplace; } else { }but it does not seem to stop the loop. Can anyone spot the error in this code that is not stopping the function?
Lookup Function On Creator
I added a lookup field on form B which references a single line field in form A. However when I am on B View Mode. The data does link automatically to form A database. I've been using Zoho CRM for years now and I love this functionality where I can map field dependencies across application within the CRM. For example, you can do a look up of contacts even if you are under the Invoice module. Is there a way to do this in creator? Eugene
How to generate reports using search interface in Zoho Creator?
Hi, I am creating a patient record database for a small doctor's clinic in Zoho Creator. I have two forms: 1) Patient Info with information like Name, Address, Telephone Number; and 2) Visits with information like Name, Date of visit, Illness that day, Treatment prescribed. Each patient has one record in the "Patient Info" form, and one or more records in the "Visits" form. This is my question: I would like to create a report for each patient with their information and a summary of each visit.
Return statement
When presented with this error message: Encountered "exit ;" at line 22, column 13. Was expecting one of: "if" ... "for" ... "delete" ... "insert" ... "inserthtml" ... "share" ... "unshare" ... "%>" ... "input" ... "." ... "=" ... ":" ... "hide" ... "show" ... "clear" ... "enable" ... "disable" ... "select" ... "set" ... "info" ... "alert" ... "success message" ... "sendmail" ... "cancel" ... "return" ... "(" ... I was wondering what return does. Anyone? Leo
There is security hole in such URL http://creator.zoho.com/kunjichen/test1/#Form:test4?recLinkID=216507000000428104&viewLinkName=test4view_added_by_me
This kind of URL is very useful for me. However there are security hole in it: http://creator.zoho.com/kunjichen/test1/#Form:test4?recLinkID=216507000000428104&viewLinkName=test4view_added_by_me Th filter of View "test4view_added_by_me" is: Added_User == zoho.loginuser Currently there are two rows in View "test4 view". One is added by user "kunjichen", the other is added by user "chenkunji". See below: http://creator.zoho.com/kunjichen/test1/#View:test4_view name Added_User ID b chenkunji
Help needed for build up
Dear All, I would like to have a table (basis data) with two fields in it: · Record User · Record User link Then I would like to have another table with an upload possibility; - here I will upload a txt or excel file with two fields in it: · Record user · Record user link Now I would like to compare the “upload”-file with “basis data” and have following as output: · Unique Record/Record User links -> if they are on the upload but not on the “basis data”
Form to user questions
Can you cc: only users on your account? I am assuming so and that we can only use the adminuserid. If this is the case, I would like to send a copy of a form submittal to zoho.adminuserid but to only one of my users, not both of them. How do I do this? Also, Is there a way to have a form submission land in a user's email box with a link that they click that sends back a verification that they received the form, or better yet a link to a page/form where they enter form data? What I have is a form
best way to generate appointments for a scheduling app
Hi Zoho friends, I really need some suggestions! We are writing a small application to allow our clients to chose an appointment for massage. Appointments are always 15 minutes. We need a way to generate the appointment slots if we give the app a start time and stop time. We don't want to have to create each appointment manually! ;). I'm a bit new to this kind of application. Can anyone help me? Devorah
Tie 3+ forms together with lookup?
I'm trying to develop a workflow for project management. My first step is to have the sales rep fill out a basic form called "New Project." In this form the sales rep fills out a few fields, including the "Project" field. Once that form is submitted, I direct three different people to three different forms, all of which need to be tied back to the Project. In the Promo Form, for example, I can use a lookup of New Project->Project to get a drop-down of all projects. Then the user fills out the rest
remove 'view as grid' access?
I have a cust status column I derive based on other column values so I disable this column when displaying it on my add cust form. My question is it appears anyone viewing this data in a 'view as grid' format through a view can simply edit this column (and other disabled columns) to a different value? Is there some way I can prevent a user from editing 'disabled' columns in a 'view as grid' view display? Or possibly remove the 'view as grid' display option from a given view? Am I not setting the
Why this descerpancy ??????
@ ZOHO Creator Team: This is case-sensitive (only counts records where field Last_Name starts with EXACT value of Client_Last_Name) ... matches = count(ClientInfo[LastName.startsWith(input.Client_Last_Name)]); alert(matches);... but this is not (counts records where field Last_Name starts with UPPER/LOWER cased value of Client_Last_Name) ... baseURL = (("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname; thisURL = baseURL + "/#View:gkMatchingClients?LastName=" + input.Client_Last_Name
Creator and tickets for API
in the api reference http://writer.zoho.com/public/help/zohoapi/fullpage in order to get a ticket you need to identify the service name servicename -- ZohoWriter, Zoho Show or ZohoSheet So is Creator included in this as well? this needs to be clarified asap! How do we get a ticket for Creator? thank you
Issue using Zoho API
Hi. Does anybody have this issue? I developed an application that retrieves data from a Zoho creator app, it was working properly 5 days ago, but suddenly it stopped working, no code change made. I try using the direct link according to Zoho docs: http://creator.zoho.com/api/json/<applicationName>/view/<view_name>/apikey=<API Key> but even though it was working well before, now I get the message: "There is no such view in Zoho Creator" I have double-checked the info, everything is ok, but I don't
Problem viewing data using CSV RPC
I've successfully used CSV RPC to add records to my application, but when I followed the steps in "CSV RPC - View Record ", I always get the following: Error Code , message 2903 ,The Criteria is in-complete, the final relational operator must end with dot(.) Any help would be appreciated.
Using Google Custom Search to search a database
Has anyone tried using Google Custom Search to search a Creator Database? I am interested in an easy way to embed a database search without customizing an html view to do so. I would be fine using creator's interface but you cannot search across fields... you can only search one field at a time. Thanks for any input. Mike
limit view access to db rows using zoho.loginuser
I want to have view criteria that will only return db rows when the current loginuser matches the added_user on rows on the db OR if a given loginuser other than the current loginuser is using the view. I am able to accomplish the first part using the following criteria without an issue: added_user == zoho.loginuser But when I try to include an 'or' condition that would allow a manager to view all of the db rows regardless if their loginuser matches rows on the db or not I get an error message 'adding
Lookupo Criteria
My problem may be the same as issue 87851000000853007 http://help.creator.zoho.com/Issues-List.html I have three lookups on form A looking up information from form B. When I add criteria to the Lookup and click Done the field disappears from the form. It reappears when I refresh the screen but the criteria is not saved. I was able to get this to work by coding directly in the Form Definition. Herb Wexler
Cannot retrieve application data.
Hi. I'm not sure I am the only one having this issue, I developed an application that retrieves data from a zoho creator app, it was working properly 5 days ago, but suddenly stopped to work, I didn't change anything in the code, so tested using the direct link http://creator.zoho.com/api/json/appname/view/viewname/apikey=xxxxx&ticket=xxxxxx but it always return the message "There is no such view in Zoho Creator". I have double-checked the info and tested too much times. Do you know if anything
Display name in view is not read as the field name
I am not able to sort data by year in a view. I have noticed that in the "Column Properties" of the view, the "Year1" column is listed as having both a display name of "year" and a field name of "year". As such it seems that ZC does not recognize it as the year, since it is referred to as "Year1" in the actual script. In looking at the view description, it is listed correctly. I have tested this by changing the display name of the "Year1" field from "Year" to "Year1" This means that the display
Next Page