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
New to Zoho Creator, 2 simple questions
I am trying to use Zoho for the first time to manage contacts in my university's christian club. Zoho seems great, but there is something I thought should be very easy to do but I couldn't figure out how: 1) I have a table for Current students, and I have a table for Graduate students, they have some different fields (for example, the Current students have a student number assigned to them but the Graduates do not). At the end of an academic year, some students graduates and I have to move some from
Client API doesn't answer?
I'm trying to integrate a form from Zoho Creator into my Webpage using Client API. I followed the explanation at Zoho API Guide (http://api.wiki.zoho.com/Zoho-Creator---Client-API.html) . But I'm only get a white page. It looks like there is no interaction between the html-page and the zoho form or the API!? My questions: - Do I use the API key and the ticket for the Client API? - If so, how do I use the API key and the ticket? - Is there more to do as described on the help page above? Thanks for
criteria for views
Each of the users of my application belongs to a given firm, and each firm can have several users. The association between firm and users is established in a form, called Users, with fields : FirmCode, UserEmail. The UserEmail is the same as the zoho.loginuserid. I now wish to construct a View on another form, called Orders, such that all users of a given firm can see only the orders of that firm, irrespective of which user of that firm has placed them. In the Orders table I have a "FirmCode" field
Inviting users to new version of the same application
I am not sure what happens when I invite users : if I make changes to the database it seems that these are not immediately available to users, I have to share the application once again and the list of previously shared versions of the same application still appear and are available in the user account !
Autofilter list fetch?
We have a list of clients on a table. That table has 'Active' and 'Inactive' radio boxes, this indicates if the client even attends our program anymore or not so it is very important. On that same form/table we have a list of days Monday through Friday in checkbox form. We have another form and table that we track attendance on. I would like to do 2 things, but would be happy with just one for now. I our attendance doc is to be done daily by our staff and volunteers. The attendance doc has simply
Creating an external document
From inside my creator app - I would like to be able to create a document (ascii or "word"). I need similar ability to creating an email message - but instead of it being an email message - I'd like to name the document and just save it to my hard disk. Any way to do that? Thanks
Counting the number of times a word is displayed and then inputting this number into a new field
I am trying to get my application to count the total occurences in a view and then get the result into a field in another form. For example, one form has a field that will be used to display the total number of times that the word "Human Resources" is input into a field in a separate form or view. I need to calculate the totals so I can then create a chart with the total number of occurrances. Any sample code ideas would be appreciated. Thanks!
Composite Keys
Hi, I have a simple data structure to implement. I have 3 entities; Lecturer, Module and Allocation. A lecturer can have more than one module and a module can have more than one lecturer. This creates a many-to-many realtionship which I've resolved by creating an additional entity called Allocation. Lecturer has a unique key called Staff ID, Module has a unique key called Module Code and Allocation has a unique key which is a combination of both of the others i.e. StaffID and ModuleCode. I've creating
Auto Populate List
Hi I cant seem to get my head around the following: I'm creating an app. One of the fields require a int value > 0. For example lets assume "4". How can I built a list to contain 1, 2, 3, 4? If the int was "5" then list must contain 1,2,3,4,5. I need this for the following reason: Int "4" means that certain field values in the form must be copied to another form on submit, 4 represents the amount of data rows, so: 1. Name, Surname, Mobile 2. Name, Surname, Mobile 3. Name, Surname, Mobile 4.
Allow edit access to support?
Is this why my forum questions have gone unanswered? Was I supposed to allow edit access to support? If that is not the purpose of this option can someone explain what it is used for? I searched the creator forum for the term access support and nothing came up. I am sure I missed something somewhere, could someone point me to a forum post regarding the option or a wiki article on it or something? Thank you.
Render Uploaded Image
Is not working. It's really serious guys. I have several apps in my clients that are not rendering the uploaded images. why?... I'm using the formula that is that is told in the Zoho Help document: ("<img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/" + Image + "&sharedBy=" + zoho.adminuser) + "'/>" please tell me how to fix it? Rodny :( Blist Solutions
Print My Form
Gosh, some people still like paper copies. I have a request for a print button be added to a form being viewed. The user wants to fill-out the form, then print it, then submit it. Under "More Actions" a print option is expected. Possibly a view PDF is also OK. Is the only work around to populate an html view after submission and then prompt for printing (or PDF)?
Test data / test application -- how do you do it?
Aside from copying applications to do test, how do the ZC creators structure test scenarios? Is there a way to two applications act on the same dataset? Curious about test/production setups... Ian
Next Page