Using a Check Box field as a Lookup source field
Is it possible to have a Check Box field as the field that is "Looked Up"? I am able to link simple Text Boxes but not Check Box fields.
How can I create a report by specific search criteria?
I am building a database using Creator and am close to finishing it up but one thing is still not clear in my mind. I can't figure out how to create a form to simply generate a report. This database is for employee performance and all forms and views are built. I'll try my best to explain what I need. All forms have static fields meaning the same fields in all forms as well as fields specific for that form. One field in particular that is on every form is a dropdown field and is named Overall Impression
Changing Section for a form or view is not convenient
I created a application with more 50 forms/views. In "Customize>Rearrange Link>", it is very unconvenient and is unendurable for me to change the section for a form or view if I have more than 50 forms/views. Sometimes it take me 1 minute to move a form from a section to another section. Kindly watch the attached vedio. Kunji from Baihui
Set default date in On Load to specific date (not current date etc.)
I have a garden app that uses a "last frost" date that is always the same for each record. Can I put code in On Load of the form to auto populate a specific date into a date field. Other forms have lookups back to this form that fetch this date and perform calculations based on this date. Example: Planting Date = lastfrostdate.addDay (input.prepostlastfrostdays) Right now each time a plant group is added the user has to choose the date and it would be quicker if that field could have default
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”
Edit pane does not show all fields
My Form is working correctly and I can add new records however when I edit my form the entire right column is not visible to edit. Also any field I add in the edit does not save.
It is possible to add image from api??
Im working on an creator.zoho application almost done.. all is perfect except images cannot be added from api.. im using the rest api for test porpouse.. the text is added in the target view but the images does not shows.... just wondering is there any way to do this.. any help would be appreciated. thx!
Cycle 2: Scheduler
Suggestion: Scheduler Purpose: Allow admin to create timed actions without any user inputs Motivation: This is already on the list of features Zoho is working on (http://zohocreator.wiki.zoho.com/Working-on.html). However, I think it would greatly benefit the user community to have this feature available now. I'm constantly comparing Zoho Creator to SharePoint workflows with my colleagues. But this comparison falls down in the case of timing future actions. You can do it with SharePoint, so why not
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
How to avoid repeated data entry in a stateless form?
Hi, I am trying to use a stateless form to populate another database on creator. When a customer enters the data and clicks the submit button, the data is stored in the database. However the customer can do this over and over again and there is no way to stop this. Is there anyway to disable repeated submission? Thanks
Import Data Error (on dates it brings 0009 instead of 2009)
Dear Sirs, I'm currently trying to update values in one of my tables and I see you have changed the import form where now we can select a file. However, when I import dates the values come either empty or the year is short because it says 0009. It doesn't matter if I use the new import method or copy paste. I haven't changed anything in the way I've operated in the last few months to have these new errors that I thought you might need to know. I've tried to import the same as paste, but the error
Automatic print after "Submit"
After looking through the Forum trying to figure out how do this I still cannot get this to work. I absolutely know nothing about HTML so therefore I am at a loss when it comes to doing what I'm trying to do. I have about 45 forms each with it's on view. After each form is filled out I would like it to print each form each time I click "Submit" and possibly "Update". Is this possible? Thanks, Chet
Zoho Creator slow
I am experiencing extremely slow response form Zoho Creator these days. Is this normal?
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
ZOHO Creator Is Extremely Slow ...
In the last hour or so, ZOHO Creator is extremely slow ... e.g. switch from Script Builder to free Flow scripting took over 30 seconds !!! ... normally about 2 to 4 seconds. Also slow when switching from Running to Editing an Application ... and when navigating between Application pages. I am working on new Applications ... so there are miniscule number of records Happens on different Applications ... but other services like ZOHO Forums are not slow ... so it looks like problem is confined to ZOHO
free-flow script problem
Error modifying the page java.lang.RuntimeException: java.lang.IllegalStateException: No transaction.
Free-flow scripting broken?
Is anyone else able to see their form definitions "with action"? I'm getting nothing but a grey page.
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
Source for html view tutorial or html templates?
Is there a tutorial or template source for creating html pages? The templates on the html view creator are more like examples. It would be so nice to have pre made html that included clear placeholders in the html for where to put the script. I just can't seem to figure out this part of creator. I need a nicely formatted income vs expense or profit loss report that can be printed out.
Search Interface Help!
I need to create a very simple one-line search form that will allow users to search any field in the database. It can include a dropdown that would allow users to choose which field to search. The results would then display in a grid, similar to the default Zoho view. I got as far as creating a stateless form with the single field, but need some assistance with the actual scripting. Help please?? Thank you!!
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
Can't Import Data
Is there something wrong? I've tried cut and paste and also file upload and no luck. It's a standard upload that do all of the time and today, it's not working: https://creator.zoho.com/scausatf/sca-road-running/# There's no error, but the little hour glass turns quickly, and then nothing - no error, but no import either. Thanks for your help. Linda
Numbered fields
Hi, I would like to add numbering to the fields in my form. Does anyone know if this is possible? Thanks James
Edit pane does not show all fields
The form was built successfully and loads properly. However it is not now possible to edit this because only the top few fields appear in the edit pane and it is impossible to scroll down to the others.
How do I make one field equal to another?
How do I make one field equal to another? I know this must be simple, but it's eluding me tonight. Field 1 is an email entry field & Field 2 contains a default email address specified as it's initial value I would like user input into field 1 to change field 2 away from the default to the new value. Any help with this would be hugely appreciated... Thanks everybodyDusty
Embedded View Won't Update Record
Hi - The view that I have embedded in my own Web page will not update the record and/or proceed to a refreshed screen of the updated record. To clarify: • The view for a given form is embedded in my Web page • I click the 'Edit' link and then get to the screen for editing the form contents • I make edits to the fields then click my 'Update' button • The 'Please wait...' graphic displays on screen and simply cycles there endlessly - doing nothing There may be something rudimentary and simple that
Need help with determining Households / Families Counts
Hello I have a Zoho Form that contains both Individual Client IDs and Household IDs that are imports from an external database. Fields: Client_ID & Household_ID I am trying to figure out the best way to determine a Zoho script that would calculate the total number of Households or Families using the Household_ID field either if they are Single (only 1 Household_ID) or Multiple Members (more than 1 member having the same Household_ID) and tallying the results. I would greatly appreciate any assistance
Form Order / Sort Forms by Name or other criteria
How can I sort my forms by name or by other criteria? When I go to the Application (not in edit mode) there seems to be no ryme or reason as to the order in which the forms are listed. Let's say I have the following form names: Form A, Form B, Form C, etc. Might show up listed as: Form C Form A Form B etc. I may want a particular form to show up first in my list and another particular form to show up last, etc. Please help, thanks!
Reports and Creator
I have not found any way to format reports - even basic needs like headers and footers. Please tell me that the ability to format reports has not been overlooked? thank you!
Private/hidden fields in embedded form?
Is it possible to have entries that are stored in a private database that are not displayed in the embedded results? For example, name and email recorded but not displayed publicly?
Edit Records without showing all fields
When clicking "edit" in a certain view the user sees all the fields, which can cause confusion if you have many fields in a db. Any way to restrict the fields that show in an edit to just those defined in a view? When you click "view" it properly restricts those fields that are defined in the view - which is correct. thank you! rg
Problem Importing into Dropdown Field which is dynamically populated from another Form ...
@ ZOHO Creator Team: I have a Form (say FormA) which contains a Dropdown (ListBox) Field (say FieldX). FieldX is designed to be dynamically populated from a field (say FieldY) in another Form (say FormB) ... I have the script in the on Add on Load section of FormA to do this. When I add records in FormA via the Add Form, everything works as expected. But this Table (FormA) has hundreds of records ... so Client setup a Spreadsheet ... so contents of FormA can be uploaded via the Import link. I find
Option values added by Deluge for Radio field get diffrent value in IE and Firefox.
Option values added by Deluge for Radio field get diffrent value in IE and Firefox. It is corrent in Firefox and wrong in IE. Steps: 1.create a new form with a dynamic radio filed, the script e.g: on add { on load { clear Radio; Radio:ui.add("one"); Radio:ui.add("two"); Radio:ui.add("three"); Radio:ui.add("four"); } 2. On user input of radio, the script e.g: alert(input.Radio) so, it will pops the checked value when clicking the option of radio 3.Access the application, and click the option of 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
Fetch Records Issues...
I am attempting to display my employees' name in a field automatically. Right now, the field displays their Zoho Username. This is as far as I've gotten, let me know if I'm on the right track, or not. I have created another form in the same application called Employees. In this form I have 2 fields, one the houses the Full Name of the Employee, and the other the houses their zoho email id. Next, I went back to my fist form, and added a Fetch Records script on the Form Load. Right now, the script
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
problem uploading access data base accdb with zoho migration tool
I got a problem message Unable to upload. Contact support... something like this. This is my .ds file application "ORDENES" { section home { form Certificacion { displayname = "Certificacion" N_ORDEN ( displayname = "Nº ORDEN" Type = picklist values = Ordenes.N_ORDEN ) N_TRABAJO ( displayname = "Nº TRABAJO" Type = text ) N_CERTIFICACION ( displayname = "Nº
Application Disappeared
Logged in just a few minutes ago to do some work in one of my applications to find that it is gone and there are no listed applications for my username. Is the service under maintenance or did the app somehow get deleted? I can not find the app on my home page or access it directly.
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.
Next Page