How to use Zoho Creator as a
Hello. Has anyone successfully been able to use Zoho Creator as a "front-end" to their own hosted and managed Database Server using MySQL, MS SQL 2005/2008, or Oracle? If so, how did you do it? Was the response time pretty fast? What were the obstacles and challenges that you faced? Any ideas and suggestions to this would be greatly appreciated. Thank you.
Email data
When using Zoho's email data feature, is it possible to email data with a formula field? For instance, if I have a formula field (fmlaContact) that will concatenate the data of a first name and last name, can I update the database via email by simply leaving the formula field blank? Eg: FirstName:Leo LastName:Leonardo fmlaContact: Thanks, Leo
Fetch Record: select from two different forms
I am creating a donor form. I already have a member and a constituent form (two separate ones) -- they need to be separate. I would like to use one ID code from the member / constitutent code to fetch a record from either form. Here is an example: MEMBER: Student Jane, ID 33333 CONSTITUENT: Benefactor Organization, ID 22333 Member donates $50. Constituent donates $100. In the DONOR form: I want to fetch either Member or Constituent in one field and have their address record show up (just address,
Payment Information: Amount split to different codes
Is it possible to take one amount and divide its purpose among several categories? I have my donations divided into CATEGORY & CAMPAIGN. My example: Donor gives $260. $200 is for Annual Fund, $30 is for Merchandise, and $30 is for Supply Donation. Is it possible to split one entry into 3 allocations without having to create three records>
Need Rnd() function
There's something I'd like to try to do with Creator, but I need a Rnd() function (return a random number between 0 and 1) and a Randomize Timer function to seed the random number generator. Or a way to include some JavaScript or something. Thanks! fredramsey
Migrating from MS-access to Zoho problem
I need to convert my Access database to Zoho Application for testing purpose but I keep getting the following error popping in "Migration from MS access to zoho cloud" software: Problem encountered while creating the application Encontered "#" at line 1211. column 29. was expecting: <DATE> ... I was wondering if you are going to enable the right to left text in anytime soon or if it is available already please direct me toward applying it.
Bugs in views with criteria on look-up field
Hello, I am trying to define a view for a sub-group of elements of the database by defining some criteria for this view. When the criteria is on a field with a standard type (text, list of elements,...) it works, but when the criteria is defined on a "lookup" field (fetching the list of values in the database) it does not work anymore. A simple example: I have 2 forms, one for the definition of a client, one for the definition of a sales person in my company. Each client is linked to a sales person
Formula field to pull value from another form with specifc criteria..
The Lookup field only allows me the following types: Dropdown, Radio, Checkboxes, & Multiselect. I need the ability for a Formula field to pull a single, specific value (text, number, etc) from another form based on specific criteria (i.e. ID == ID). How can I do this? Is it possible via Deluge scripting?
add multiline-records by email
I want to add records with multiline-fields by email. My problems are: Line breaks get lost: Line1 Line2 becomes Line1Line2 and record containing ":" can not be added: a: text1 b: text2 c: text3 becomes because the content is automatically allocated to the field a, b and c (even if they do not exist). Please advise me how to solve these problems. Hannes.
Zoho Web Developer
Hello I think Zoho Creator is a great enterprise application generator (EAG). I think it could also be the basis of a great web application framework (WAF). As an EAG, I think it pretty much hits the mark; I don't think it needs much more. As a WAF, I think: its pricing is inappropriate, it needs some payment processing features, and it would be a good idea to better leverage Google's App Engine. I suggest Zoho introduce a new product, perhaps called Zoho Web Developer. This should have all the features
How does Zoho Creator Licensing work for Multiple Applications with Different users?
If have a Zoho Creator 5 user license as an example, and for my "Beatles" application I have the zoho users: John, Paul, George, Ringo, and myself as the Developer. Can I also have another application called "Van Halen" and allow the users: Eddie, David, Michael, Alex, and myself as the user? or am I just limited to the have the users under my "Beatles" application? Thanks.
How to influence the working of the Cancel Button - for example redirecting to another page
I supposed that the Cancel button could bring the user to a different page or something like that when clicked. I do not see how this ought to work. Can anyone help me with this? Point me to something? Kind regards
URGENT!!! Re the Deluge Script builder don't work now!
Hi I got black screen when I used the "set varirable" task , even the previous "set varirable" also don't work,if you click the "edit" will get balck screen , what's happen? please reply as soon as possible. waiting your help and thanks Stanley Guo
My app is gone
I just began to try to use Z. Creator for this first time this afternoon. I started an app that I called "Moody Log," modeled on an old Palm Pilot program. It was not difficult to create. I was able to enter and save data with no apparent problem. I'm sure I did everything that was necessary to save it. Nonetheless, only two hours later it has now disappeared. I am not happy.
Integrating existing application in to Zoho
Hey guys, hopefully someone can answer this question. Pretty new to Zoho, so just poking around. I have a PHP app that requires users to authenticate with a database. I want to be able to add this app to zoho for other users in my group to access. It seems like my app runs in an iFrame on zoho, so my question is, is there anyway for me to bypass authentication and use Zoho authentication of the user that is currently trying to access my app. In other words, user clicks on my app from within Zoho,
How to Alert the User on whether their Web Browser is a Supported Browser
Hello. I'm interested in writing a script within an HTML view or within the html coding of the View to notify the user of whether or not they are using a "supported browser" on my Zoho App.(I got over 100 Zoho users on my App) I get a lot of help desk calls and most of them are related to unsupported web browsers such as Safari & IE version 8. Any suggestions for this would be greatly appreciated. Thanks.
Why is Data Retrieval for Dynamic Picklists So Slo-o-o-o-o-o-w?!
My app collects state, city, and school data. I have one table (I know zoho creator calls them forms) with a single field and 51 rows - one for each US state plus DC. I have another table with state (lookup) and city. I have another table with state (lookup) and school. My actual user input form has (obviously) state, city, and school. The city and school fields are picklists that get auto-populated from an "on user input" script on the state field that looks like this:if (count(City[State ==
Can't See My Form Anymore - What Did I Do?
I go to edit my Form at http://creator.zoho.com/mcgeepj2/form/9/edit/ and I no longer see all my data fields all I see is this screen shot below. What did I do? Where did my form go with all the data fields? The form still works on-line at http://creator.zoho.com/showForm.do?formLinkId=9&link=true&sharedBy=mcgeepj2 Thanks
Can limit on outgoing mail (from Creator sendmail) be raised from 500 to 2000?
My org's mailing list is currently 2000 email addresses, and growing. But I can't send more than 500 per day from Zoho. This seems like a very low limit for any organization using Zoho Creator for a contacts database. How can the limit be raised to higher numbers? Please advise. Thanks. Greg Malone Santa Fe, New Mexico, US
Is a random() or rnd() or rnd(x,y) function available in Creator?
I want to display a randomly selected record in an HTML view. Try as I might, I cannot find any workable references on how to get a random number, or select a random record, etc. Any help? Thanks. Greg Malone Santa Fe, New Mexico, US
Criteria for embeded view: how to implement 'many-to-many'?
I have an html view in which I have implemented deluge script to fetch a list of cities from a certain "Form A" record (multi-select field). Below that (in the same html view) I want to embed a view that shows all "Form B" records where at least one of the selected cities are the same (Form B also has a multi-select field with cities in it). Is there something like: <div elName='zc-component' viewLinkName='TestView' params='Cities={London:Paris:New York}&Cities_op=99>Loading View...</div> where 99
Sort drop-down alphabetically
I would like to sort the lines in a drop-down (lookup) menu alphabetically. I have checked the box "sort entries alphabetically" (or something like that) under the drop-down menu options. But the entries still appear in random order... Is that an application error or is it me? :-) And ever more important: how to make it work? Any thoughts? J
Can't import csv or xls files
This is the first time I've used this so it might be something stupid. I created a form by importing an xls file. This had a single 'record'. I am now trying to import a similar xls/csv file but with multiple 'records' ie rows. The file has exactly the same row headings and I am checking the 'first row' is column headings.
Issue with date format when importing data
When I import data into an existing form, the import defaults to assuming any date is in a dd-MM-yyyy format, and sets the format to MM-dd-yyyy if it detects that the date is invalid in dd-MM-yyyy format but is valid in MM-dd-yyyy format. For example, if I import the following data:Transaction Date Transaction Amount 9/5/2008 52.39 9/12/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39 Zoho puts the data into my form as: 5/9/2008 52.39 12/9/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39
Font and Size will not change ina NOTE field
The FONT will not change in a NOTE field. The FONT SIZE will not change in a NOTE field. Please advise.
Can't share with developer, can't duplicate, can't import
I really need to give edit access to a coworker for one of my applications (currently shared to support). I've followed the instructions found in other posts, but I cannot share with my coworker as a developer - I continually receive a "please try again later" pop-up when I try to change the application settings. In an attempt to work-around the issue I've hit brick walls in trying to duplicate the application, as well as exporting and re-importing with a different name. How can I allow another user
Rendering of File Upload field contents
Aparna: This is a followup of the discussion here ... http://help.zoho.com/portal/en/community/?ftid=2266000000540065 ... starting a new Topic to explain my exact situation. One of my first projects included the following that worked perfectly ... a) Form called Staff Records has ... - a File Upload field called UploadPhoto - a Formula Field called Photo with this formula ... ("<img width='64' height='75' title='Staff Photo' alt='Staff Photo' src='http://creator.zoho.com/DownloadFile.do?filepath=/"
How to copy application.
I created an application. Now i want to create a new application based on it. I click duplicate but nothing happens?
Separation of digits (thousands, millions etc)
Make, please, a separation of digits (thousands, millions etc) in formula fields and in total row.
Position & Hide/Disable Buttons just like Form Fields
Hi Zoho developers, I have a small request. Would it be possible for you to implement the following: For Buttons in the stateless form, 1. Hide/Show 2. Enable/Disable 3. Reposition buttons, exactly like Form Fields 4. Change the "text on this button" via script --------------updated--------- 4. These buttons would have several 'States' 5. User can add, remove 'States' 6. Button will be switched within 'states' like this: If ( input.nameverify == input.name ) { Changestate button1
Integrating Zoho Creator with Zoho Docs
I've created a form on Zoho Creator; and I have a doc library in Zoho Docs. Based on the values inputted into the form, I want to open a doc from my Zoho Docs library for editing. The doc selection is dynamic - depending on the inputs into the form, the name of the file (to be opened from Zoho Docs) and its folder location will vary. How do I get this done?
having created form sent
ok here is what I am trying to do: I created a sports registration form that I embed on my website. The goal is to have a parent of a child access the site, fill out the registration form, and then have a copy of the actual form get emailed to the person who filled out the form, as well as to the treasurer of the association (we are a non-profit church group). So far, I have been able to have the form filled out and the database updated without a problem. I believe that I have the access so that
URGENT!!! Zoho Creator Form Issues!!!!
My application is continuing to have major issues. It is taking 10-15 minutes to load a view or to add/edit a record and I can't add any additional form fields. Now any views that are associated with my form receive the following error message: "We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com" I've contact support by e-mail and phone with NO resolution. Please HELP!!! My data is locked up and my sales team (40 agents) can't
Make it stop!
I have a simple "on user input" invoked function to make some text conform to a standard. input.RMC = thisapp.inventory.RMC_CHECK(input.RMC); It works, but the "on user input" keeps running forever (little spinning arrow next to input field). How can I specify this function to only run when a human changes the input field, and not when the function itself acts on the string in the field?
New String Function
Here's a simple request to compliment the built-in string function: xyz.removeAllAlphaNumeric() Please support: xyz.removeAllNonAlphaNumeric() Thus "OUCH! I banged my little @#$% toe!" would become "OUCHIbangedmylittletoe" Thanks!
how to create an editable multi select dynamic picklist?
for example dynamically create a books_i_like picklist from all the books. then allow a person to check and uncheck their selections without destroying their previous choices by rebuilding the picklist.
multiple pop-up windows / dialogs
Hi, I wondered if it's possible to have a pop-up dialog on top of another pop-up dialog? I've tried this myself, and it seems to have some odd behaviour. So I'm guessing it's not valid, but I just wanted to double check? Here's what I did: I created a view, with custom actions. The custom action is to pop-up a view (as shown in the attached picture). The pop-up view *also* has a custom action, which is supposed to pop up another view. But this second pop-up just seems appear momentarily, and
Creating an Image View that can be printed
Hello. I've created a form that lets me upload image files. I'd like to create a HTML view that lets me see a particular image in a full page size and have on the bottom a button or text that would allow me to print the image shown on the html view. What would be the best way to approach this? Thanks.
Strange behaviour on HTML embedded views that receive params
Hi all! I'm making an HTML view called 'Test' within 2 embeded HTML views. Both embedded HTML views are the same HTML view, but receiving diferent parameter values to print. See the code below: htmlpage Test() <%{ <div elName='zc-component' viewLinkName='HTML_view_A' params='message=FirstMessage'>Loading View...</div> <div elName='zc-component' viewLinkName='HTML_view_A' params='message=SecondMessage'>Loading View...</div> <%}%> And htmlpage HTML_view_A(message) <%{%> <%=message%> <%}%> Ok,
Permalink will not work
I created a permalink with a success message and nextURL and it will not open. I get a vague error: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to HomeI created the permalink throughout the More Actions--> Permalink in the Embed in your website creation box. I tried to recreate the link, tried logging out and back in, tried different browsers. It is not working. This is the second issue I have had today.
Next Page