Relational DB with Creator
Can we use a relational DB with or build a relational DB with Creator. If yes, how do you assign the relationship? Thank you - Frank
Truncate Date-Time
Is there a way to get rid of the seconds in a view? Or even in the calendar Date-Time Object? My view shows this: Apr 02,2010 23:01:38 I would like to get rid of the 38 seconds, and just show Apr 02,2010 23:01
Problem creating a graph out of a check box list
I have a form that asks for the name, age of a person (text and numeric fields respectively). It also ask to select dates from a check box list (4 options created). The idea is to organize football matches and teams on that dates based on the amount of people inscribed. I tried to create a graph report that shows in X axis the dates and in the y axis the number of people inscribed for this date. The graph does not read or recognize all dates available in the database, only few of them, so the graph
How to declare variable on User Input
Does anyone know how to declare variable on User Input? Can I have an example if I wanted to declare a field name of "My Variable" Thanks!
Can not delete fields in Database
When I try to delete a single line or multiline text box I am promted with an error message. "Delete Operation Failed - Please try after some time or refresh page" I have tried using different computers and different web browsers. Any ideas?
Integrating Zoho Planner, Zoho Notebook & Zoho Creator for customer maintenance
I'm new to using the Zoho Creator application which I love so far. I'd like to be able to use the Zoho Notebook and tag notes to people that I have stored in my database in Zoho Creator. Eg. If I am taking a call from a customer in my database, I'd like to be able to use Zoho Notebook and then link it back to that persons file in the Zoho Creator database for information consolidation. I'd also like to be able to create events in the Zoho Planner and tag them to individual entries in the same
Can a Script be run for all records "on add / on load"?
Will this script run "on add / on load" and send an email to all the records in my application that meet the criteria? Or, will it only apply to the current record? if (((zoho.currentdate > input.Added_Time.addDay(10)) && (input.Contacted == "null")) && (input.Hired == "New")) { sendmail ( To : input.Notification_Email From : zoho.adminuserid Subject : "Follow Up Required: Recruiting Leads" Message : "Dear" + input.Assign_To + ",<br
Unexpected results in "on edit->on load" event
Can you tell me why the input.Treatment_Diagnosis_1 never gets set in the "on edit->on load" event of the following code? I know this exact code works when used in the "on user input" event of input.HCPCS_Code1. Thanks in advance! ~SirGregory on edit { on load { if ((input.Treatment_Diagnosis_1 == null) && (input.HCPCS_Code1 != null)) { if ((count(Patient_Condition[(Patient == input.Patient && Inactive == false)]) > 0) && (count(HCPCS_ICD9[(HCPCS_Code == input.HCPCS_Code1 && HCPCS_Code.Inactive ==
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you
I want to pull a list of spefic values depeding on an item selected in a drop down menu. Does anyone know how to do this? I really need help! Thank you Example: Choose "A" from a drop down list Then a list of values "1,2,3,4,5" will appear in drop down or any type of field below If you choose "B" from a drop down list Then a list of values "6,7,8,9,10" will appear in drop down or any type of field below
Abuse report?
It's somewhat funny that in the footer of the application I develop for a client, there is the following link: Report Abuse So, if I meet something abusive in the application I develop, I have a shortcut for abuse report? Or simply it's a shortcut to report any abuse I'll meet regarding any ZC application? I don't dare to click the link to see what happens, I'm afraid that my application will be blacklisted. So, ZC support, can you explain why that link is on the pages of the applications I develop
How do I change zoho creator account name
How do I change the zoho creator account name? I want to change the account name to one that fits my business name. How do I do this and retain all of my applications, settings, users, etc.?
Form edits changing
Hi Have just started with Zoho - looks like a great product - but have just spent a long time entering a form. Every time I reopen it the postcodes (In Australia 4 digits) have 1. the mandatory field off and 2. the maximum digits off. I keep changing them but they keep going back. ? Any ideas? Cheers Bellinda
HELP - Form will not allow me to Add or Delete or Rename fields - ???
I have a large app that I've been creating. I made good progress until now when I've encountered several serious bugs. I really need your help. I've got tons of hours invested and I can't go further. 1 - One of my forms will not allow me to add any more fields, and it wont' let me delete certain fields either. Each time I try to do a delete, it complains. If I try to rename, and/or hide the field, it says ok, but those changes do not stick. Help!
Can I use Zoho Creator to create an online form or script to signup for all the zoho apps at once plus Webriq.net?
I am a reseller of Zoho here in NY. I am selling Zoho as a light ERP SMB suite. Everytime, I add a new customer, I have to manually add everyapplication to their suite and double check single sign on with ZCRM. My goal is to have a sign on process like www.eazybusiness.com. You simply sign up on one form and it runs a script to subscribe to VTIGER CRM, ZIMBRA, ORANGE HRM, and Joomla. Very simplle and powerful for the end user to get started. My goal is to do this with Zoho and Webriq.net (
how to create a fast data-entry form?
Any ideas? Zoho Sheet is too slow for this. Think MS-Access' sheet view. Is it possible with Zoho Creator? Any example apps?
Imges not displaying
I've created a form to upload images and then display them in a formula field as described here however the images aren't displaying; all I see is a blank image place holder - see below: Any ideas?
pricing for API usage.
Creator pricing seems to be ased on per user basis. If I'm using API to interact with my Creator application, how will the pricing affect? My applicaiton will obvioulsy be used by many users but their interaction with Creator application is None. E.g. Facebook application that uses Creator application as the backend.
Using count function
I've created the following script which works well - however, I want to pass the count value to a variable -- I can't see any help on this with the count function: if (count(Workflow_Tasks[Job == input.Temp_Jobs_List]) == 0) { alert("There are no active Tasks for this Job"); } Thanks, Martyn
Proper() string function
I would really like to see the "Proper()" function implemented in Deluge Scripting. This function would force the first letter of a proper name to be uppercase and the rest lowercase. Also, this type of formatting could be implemented at the field level; perhaps with a generic input mask string.
Poor performance of Creator
It seems that there are again performance problems with Creator, at least for me... it takes a lot of time to save an html view, to view it (30 seconds for a view which usually is loaded in 3 seconds)... and I tried to see the new applications from the Marketplace and it was a real pain because the loading times are too big. Does any ZC user have the same problem today? Regards, George
Fetch Record for IF statement
I am trying to figure out how to Fetch specific fields from another form, to implement IF statements in the first form. For example: Two forms: STAFF and RECORDS In Staff form is: NAME, Position type, and several Decision boxes -- Do you want to receive email if EVENT A, EVENT B, EVENT C In the RECORDS form: There are many fields, one is STATUS. So, if STATUS changes from NONE to EVENT A or EVENT B, or EVENT C, I want the database to go through each Position_Type, and depending on the NAME
Question - Group By and Sum within a View
Hello - Let's say that I have three records in a form with two fields (Product, Order QTY): Product A, 12 Product A, 37 Product A, 19 In a View, what I want to do is produce an output that looks like this: Product A, 68 I don't want it to look like this: Product A, 12 Product A, 37 Product A, 19 Product A, 68 Instead, I just want it to look like this: Product A, 68 Just one row and ORDER QTY summed together, grouped by Product. Is there a way to do this in a view? I've struggled with this... I can't
Can I fill Checkboxes from spreadsheet data?
I'm looking for the option to have a user pick an option from a pick list, and then have the script check boxes in a list from the data associated with that option. For instance if I picked Tennis from the list, the script would check 'racquets' in the equipment check list 'courts' from the location check list and 'college' from the level list. Any suggestions?
again VERY slow
since yesterday, saving Creator script is again extremely slow ! why is this happening so often ?
Another Lookup field criteria question
Need some help here. I have 2 forms called Action and Request. The Action form has 2 fields Tool_num and Category. The Tool_num is also common to the Request form. I want to add a lookup field to the Request form that will return all of the Category data that also matches the same number entered into the Tool_num field. The user can then picks the appropiate one from the list. I tried to enter the criteria Category == Input.Tool.num . I have now read through a few forum pages and realise that it
Server is temporaly unable
Hello, We have this message : The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Make Form Public but not Data
Hi, I would like the form to be public, and accept visitor's data, but I don't want them to have access to the database. Is that not possible? The link to the form gives access to everything else... Thanks for your help :) Katia
Import data in application/spreadsheet from XML feed
Hi, I want to ask, if there is any way to import data in my Zoho Creator application (database) or spreadsheet from XML feed provided by API server of webpage? I am trying to create online database here in Zoho, previously I imported data from XML feeds ad got neccesarry information from nodes by using MSXML v 5.0 in MS Excel2003. Thanks a lot!
Edit permission for restricted users for a public application (not all apps just the ones I specify)
I have an application that is public. I have given add permission for public to add to my application, however I need to assign edit permission (/admin previledges) to a specific number of people alone and not the public. I could not find a way to do this in creator, any help will be highly appreciated. Thanking you
CSV Import with OpenID?
I created my creator account using a google login. I'm trying to use the CSV import tool, but am not clear what my username and password is. I've tried many combinations ... and I'm a bit suspicious whether the API calls support openid like the rest of the site. I see [Sign Out]johnseq1 and I've tried that, my gmail address, and everything else. Can you confirm which credentials I should be using ( and/or how to identify or confirm these ?) Thanks in advance, John
view-login url not working in IE7
http://creator.zoho.com/<admin>/<application>/view-login/<html view> Works in Firefox, but not IE7. I'm getting "No such view in ZOHO Creator"
picklist width
Hi again, I just discovered that I can't see distinguish between some of the options in my selection field as they are wider than the width of the rendered drop-down list. Is it possible to please add an option to specify the displayed width of these fields? Thanks, Anton AntonL ------------------------------------------------------ This is posted using zohocreator feedback form
New to this!!
In Dreamweaver CS4 I have some images that I would like to 'pop-out' when they are rolled-over. Can anyone tell me how to do this? Many thanks in advance
Basic version reports
Have created only two reports in basic edition, but system won't let me run them unless I upgrade. In the price list it says that I can have two in the basic version. Am I doing something wrong?
Automating a maintenance schedule
Hello, I have created a database with creator where I have the following forms: Equipment Maintenance Providers Recommended Maintenance Schedule Equipment Use History (for example, the hours we put on our tractor each month) I have keyed the unique equipment through the entire database so that it is cross referenced. I would like to automate the process of informing our maintenance providers when a piece of our equipment is in need of maintenance by the hours criteria in the "recommended maintenance schedule"
Specify a Date Range
How do I specify a date range using Advanced Criteria in the View/Edit mode? If found the section on "Conditional Operators" and tried using the operators (&& || !), but I could not get any results.
change or update field button
I am trying to create a used book sale database for our school. Not my first database but my first zoho one. I am stuck on creating a simple script that changes the field from "no" to "yes". From the view I set up a custom action which shows for each record. I just want people to click that button and it will change the book from not sold to sold status.
Seperate User Log Ins
I have one account with 4 seperate forms which are all the same. These are to be embedded into webpages to log in to the form. I want to have 4 seperate log ins for the 4 different users of each form is this possible. Many Thanks Peter
Defined a function and then it doesn't exist.
This error has occurred twice with the same function. In my Maintenance_2 app. I defined a function to generate a code. The function takes three parameters. Generates a code. The checks to make sure code is unique. If it is not, it moves the parameters around and invokes itself recursively. I entered the following code: string codes.code_generator2(string fname, string lname, string full_name) { day_num = zoho.currentdate.getDayOfWeek(); if (day_num == 1) { day_name = "Sunday"; } else if (day_num
Record Edit Error
I am getting the enclosed error when I edit a record in "Grid View" only. In other views the record can be updated with no problem, pls. reply!
Next Page