How can I search a field using Boolean operators?
Hi I'm developing a bookmarking application using Zoho and a central piece of functionality is to be able to search the bookmark tags field using boolean operators, e.g. contains TV and RADIO but not PODCASTS. I'm astonished to find that (given Zoho Creator is a database creation application), this doesn't seem possible. It's not possible to execute the search via the GUI (I can only search for one tag as it doesn't accept boolean operators), and I can't execute the search via a stateless form and
How Can Users Enter Data and Choose to Share or Keep Private
Hi: Zoho Creator is great! We are creating an private application which will have about 50 users. We would like to keep the application data private (not viewable by the public), but allow our users to enter data. We would also like our users to choose whether to keep the data that they enter private only to themselves, or to alternatively choose to share their data with the other users of our application. Is this the kind of thing best done through a script? Thanks!
Seeking help to customize inventory app
I am new to Zoho and am not a highly techie person. More of a fairly sophisticated end-user. I have worked with MS Access but now require an application that is available for inventory control over various locations. I downloaded Danholmer Anderson's app and have no idea where to start with making it right for my organization. Any suggestions?
Added_User == zoho.loginuserid in Set Criteria Does Not Work
Hi: I am trying to create a view that shows only the records added by the particular user. I found that you are supposed to use the Set Criteria feature with Added_User == zoho.loginuserid, but when I configure it that way, it returns no records. Does anyone have any suggestion what might be going wrong here? Thanks!
Report to View Personal User Data Only
Hi: In Zoho Creator, is there a way to create a report to view only the current logged in user's data? Thanks!
Need Help: Sorting records by Date is not working -- ?!
I have a simple form that includes a date field. I'm populating a checkbox list with records for the user to choose from. The code below shows that I am fetching the records and sorting them by date: clear Choose; rec = Workshop_Descriptions[ID != 0] sort by Date_of_Workshop; for each r in rec { Choose:ui.add(r.Workshop_Name+": "+r.Day_of_Week+" "+r.Date_of_Workshop+" "+r.Start_Time+"-"+r.End_Time+" [ $"+r.Price_Per_Workshop.round(2)+" ]"); }But, the output is not sorted by date! The output is:
Zoho Creator outage?
I'm trying to add some fields to a form, and when I click on the "Done" button in the dialog box, nothing happens. I've had this happen before, and I think it was server outages on Zoho's end that was causing the problem. Is this the case again? Thanks.
How can I set up nested categories for a bookmarking application?
Hi I'm trying to create a Bookmarking Application where information about each bookmark can be stored, i.e. Title, URL, Favicon, Screenshot, Description, Tags, and Category. And I'm having difficulties with the last of these. I want the user to assign each bookmark to just one category which in turn may have one or more sub-categories, e.g. Computing>Internet>Online Storage On the main bookmark entry form, I only want the top level category field visible, with subsequent sub-category fields only
Inserting New Record from a Stateless Form
I have a stateless form with a button designed to add multiple records to another form based on values populated on the stateless form. When I click the button I receive the Error "Error occurred while executing on click script." The script appears to be correct and I can not determine why I am getting the error. Here is the script: for each steprecords in Steps [Process == "T&D - Backlog"] sort by Step { insert into Processing_Details [ Added_User = zoho.loginuser Authors
Very Slow Again
We are having issue loading Creator forms and view again. This is effecting both niskypto and sigroup accounts. And there's also this: John M. Whitney
form creation help
I'm trying to create a form I want phone_type to be hidden on page load and I want it to show only on user input from phone_number field. I want phone_type to show up when some one enters their phone number, but when I click save script I get an error on part of the form that I didn't even modify (see picture) what am I doing wrong. the code that I used I got from zoho website, http://help.creator.zoho.com/Hide-and-Show.html, number 3 the blue highlighted word, on line 64, in the picture is Webpage
Getting odd <For input string: ""> error trying to compile HTML view -- CANNOT SAVE SCRIPTS
When attempting to Save an HTML View, I have been getting the following error almost immediately: The problem is, this error is appearing with nothing wrong with the script... I just load the script, make a minor legal change and the error pops up. This error and some other odd behaviors of the system tonight make me suspect someone's tinkering with things on the server back-end. I cannot compile my scripts until this is corrected. It's Sunday night here, so I wonder if anyone else is experiencing
Client API does not load
Please, I need some help: I'm trying to integrate a form ZC public into my Webpage using Client API. But it loads only the buttons submit and reset. What am I doing wrong? Note: when generating a permalink, instead of appearing the encryptedLink, theZC adds "ZC_PUBLIC_REQUEST" in the URL. Below is the html code of my web page (public url: eciclo.trendimoveis.com.br): <html> <head> <script src="http://creator.zoho.com/appcreator/js/jsonform.js" type="text/javascript"></script> <script scr="http://creator.zoho.com/eciclo/form/json/11/ZC_PUBLIC_REQUESTED"
Help with understanding API
Is it possible for a form at my website to send information to zoho records? What does this process look like? what would the form at my site need to be written in? php? html? I would start with a simple contact us form then try my test_reserve form after that ( and no please don't tell me to embed a form, already tried that, customers are coming up with "there is no such form at zoho creator" at my embedded form on the site and it works perfectly fine for me even when i am not logged into zoho)
Code field for email
Is there a ready made form or is there a field that can be put into a "contact us" form that requires a code - numbers and/or letters - to be filled in before the form can be submitted? - tks - jb
Show only columns of the current view while editing?
Hello, I want just to show the fields of the current view when editing. How can i get the info which view is displayed? Thanks in advance. Markus
Send an email with from View A with details in View B...
Hello there, I hope Someone can help me, I'm trying to develop an application which main function is send available consultants, in oder to do that I have a Conctact Form where we have the comercial contacts with an email field. Then I have another form where we are putting the Available Resources and their skills and what I want to do is send this available resources to our contact list. Forma A: Contacts (with email info) View AZ : List of contacts , on this view I have generated a Custom
Import updating existing data : pb with "else" please !
Hi all, I know that importing data today is just to create date, not update. Will you (soon?) developp this feature ? I do need to import data matching for example on ZohoID or any another field (formula field witch concatenate several fields could be useful too). We also should ba able import data into multiselect fields, where data are separated by , or ; Waiting, can you propose us a script to do this please ? Thanks Zcreator !
Maximum size of a column cannot be reduced
I am trying to update a form via the Form Definition page, but I get the following error message when I try to save the script Error modifying the page Maximum size of a column cannot be reduced, when the table is not empty -- tableName : t_116668000000015301 -- columnName : City_116668000000015428 I am not even trying to modify the "City" column. How can I resolve this?
How can i attach an iframe in my Form?
Hello Respected Members of Zoho. I am in trouble, i want to add an iframe with my form. i am use Add notes field for attach an iframe in form but i seems it doesn't support iframe option. Like i want to add iframe in my form. So users didn't go anywhere for getting any information, also in another window or another page they get their information in my form. just take an example of iframe option:- <iframe src="http://www.w3schools.com/" width="100%" height="300"></iframe> Please provide me solution
Why can't I control the view column widths?
Creator seems to ignore my column width settings (n pixels or percents) for a view. The view definition is shown below -- do you see what I am doing wrong? list module_View { displayname = "module View" show all rows from module ( Title ( width = 200px ) Description ( width = 300px ) URL ( width = 100px ) Keywords ( width = 100px )
Popup size
When viewed with Internet Explorer 8, all my html popups are cut off on the right side ("Close" is only partly visible). I call the popups like this: openUrl("#View:Testview", "popup window"); Even a dummy html view like this one doesn't display correctly: htmlpage Testview() <%{%> test test test test test test test test test test test test test test test <%}%> Thanks for your help. Filip
Can you use cURL, REST or some method to script file upload?
I am migrating some applications from Dabble to Zoho Creator and the migration tool only migrates the text data, not the attachments. I tried using cURL and a public version of the form I created to POST data to the application, but I could not get that to work due to there being javascript and several other forms on the same public form page. I tried the REST API but again could not upload files. Is there any way to script the uploading of files? My client has thousands of attachments and they can't
Update for challening problem
couldn't edit my previous post for some reason did more work on the database ap Test the question I have is written in red Gaev built a text to string and back to date:time function/expression, wondered how to use it for my application
Using external API
I am trying to send a post request to an external api but cannot figure out how... DS keeps giving me error messages. is there an example of how to do this? Thanks, Damien.
Update Deluge Language
Dear Sir, We bought Zoho Creator, but we found the Deluge Language is not enough (5000/Time) to setup our System. So can you help me to improve the limit of the Deluge Language to 10000/Time? How the payment?
Please Help Migration Tool Problem
Tried to upload this information to make a new application called Time using this menu option Yes I have room for one more application Yes I have .Net framework installed Only has two fields Text and Date:Time How do I solve this so I can upload my database with list of date:time and text field
How can I force CSV export from creator to ALWAYS use double quotes around data?
I would like to export to a CSV file and have all my data fields be double quoted. Is this possible at all? normally the fields are only double quoted when I have a comma within the data itself. thanks!
Embedded Form - Move to another page on success - send an email with attachment on success
I have built a form - lets call it a survey - a list of questions. I embedded the form in my website. Worked great. On clicking the submit button (on validation) I have an email form that is sent. Still good - got it to work. Two requests: - first, I want the viewer to be moved from my page with the embedded form to another page on my website - a success message. -second, I would like a pdf copy of the information submitted on the form to be send attached to the email sent to the party completing
Example source code for PHP Post Method call to Creator Form (from PHP Command Line) - seems to work.
Hey all, after some happy hacking...I appear to have been able to get this working from a command line call like this... C:\PHP_TESTS>php testcalltoZohoCreatorForm.php ...the PHP seems to work OK whether from a Windows (XAMPP PHP) or Linux environment. Being able to do this is useful if, say, you ever need to schedule some activity, such as a nightly or hourly data transfer from one server to another. Thanks to some other forum posts, I was able to get this working from a HTML form (i.e. webpage)...and
Grid views values being blanked out
Hi, I had posted the same problem in August 2010. We have been facing this problem over and over again and there doesnt seem to be any logical reason. Can you kindly look into this problem again. Here is the description. I have a form A in which the name, registration number and other details of a student are stored. I have another form B in which the name, registration number are imported from form A and marks of the student are stored. I have a GRID view based on form B in which I use the lookup
How to control window dimensions in opened URL link from HTML View?
I have an embedded iframe containing a ZC HTML View, seen in-part here: I want the "More Info" button to open a new window containing another ZC HTML View, and the window is *sized* and preferably *centered*... i.e. a popup. But since ZC doesn't allow any Javascript, I'm at a loss for how to do this. Though the openURL() function does have a popup size parameter, it is an immediate-acting function... i.e. it can't be triggered by a click on a button in an HTML View, as far as I know. Anyone have
Update field based on selection of lookup from another field
Hi, I am new at Zoho, and I am starting a new database. Right now I have 2 forms: Client and Call Log. The Client form stores all contact info: name, company, address, phone numbers, etc. The Call Log form will track all phone calls, emails and meetings with our contacts stored in the Client form. I have created the relationship between the two forms using a the Client Name field. Now what I want to do is have the Company Name field on the Call Log update automatically based on the selection of
Condition Display in HTML View
Hello, I am trying to create the Delivery Note after adding the values through Forms & HTML View. I am successful in doing so. I am facing some problem with - The HTML View on top is displaying Powered by Zoho Creator Logo, Can i eliminate it? I need to conditionally load values from record in the HTML view. Like if srno is not empty then only the html row will be display.Thanks. Umesh
Action on all records?
I see how to define a Custom Action that can optionally be invoked on selected records in the live view. What if I want this to happen without any user involvement other than opening the application or a view? So, I want to invoke an action on all records when a Creator application is opened, or possibly when a View is opened in the application. A typical action would be checking a date field in each record against today's date - if today is later than the date field in any record, another field
how can i create a particular Form View
hello zoho I am create a application in which i am use some formula field, now i want to that when user enter data then after the submit button they redirect to the Form View and in this form only shows the formula fields, the view doesn't contain the user input fields. and please suggest me is there is any way by which i can group together many Fields of View : like the Form View contain - USER NAME USER EMAIL ID USER ADDRESS USER PHONE_NO. then these all four fields are grouped in one - like that
jump to a view
hi i have an app with a form where my employees enter their inventory for our store at night. once they are have completed and added/updated it i want to jump to a view where I have some specific instructions on what to do next based on the data they have entered. how would i do such a think?
Looking for a Developer! Anyone interested?
I've been recently struggling greatly in trying to find the correct individual to assist me in the development of my Creator application. I had a developer I was working with that now just seems to have disappeared into thin air. I'm not ware if any of you have tried seeking a qualified developers' assistance before, but there aren't too many people who know the platform well enough it appears ;). So...... I thought I would turn here to see if anyone is interested? I would ideally like to find someone
How can i create such type of View?
Hello Everybody I am in a problem. i am creating an application that keep records on sales. In my application there are various View and on these there are various Reports. now in a View- Daily Report provide me the all over records of earning from the different locations op the today's date. It have following two fields: Location and Earning this view works well, and the report which attach with it also work fine but it's only provide me details where is sales happened. and if any location there
Hi, help with another look up field value problem
HI there, thank you for your hard work!! How can I export a value from Field1 FormA to another Field1 FormB while still staying in screen at FromA? Field1FormA needs to hold same value as Field1 FromB while still on same screen at FromA I have two Forms Reserve_Ride With fields Number of Seats Total (which is set to 8 as set value) Number of Riders (Customer enters the number of rides to purchase) Current Seats Available (has a formula that has 8- number_of_riders)
Next Page