Creator as a Production/Live System
I was wondering if anyone is using Creator as Production System that requires substantial uptime. I have been reviewing the Creator and have determined it will likely meet my clients requirements, however I want to get some feedback on what sort of uptime we can expect. How stable the Creator is, and whether it can be used as a live syste, that is used throughout the business day. Is the Creator ready for daily and frequent use, or should I be looking else where? Glenn.
Can we make two databases "talk" to each other
Hi We have different branches in cities. We want user to add certain data in different columns. Next I want to be able to do mathematical calculations on those fields. Based on the result of the above calculation using ( > or < or = ) if then else I want it to another database and add 1 or subract 1 from another database and also trigger and email and SMS alert. Essentially what we are doing is we have broken a persons salary into daily w tasks with different weightage. Based on this we have
Question Regarding If Statements - OpenURL - OnSuccess
I have created a questionnaire that asks a series of questions. Upon submission, I want a specific URL (there are only 2 possible URL's) to open depending on the answers to the specific questions. For each question the user can only select "Yes" or "No" as each input field is a radio. Once one answer satisfies the condition to open URL2 and the user submits the form, I want URL2 to open. If no answer satisfies the condition to open URL2, then URL1 will open. Right now, it appears the code below
How to fetch a record and create HTML like a compare site?
Hi, I do real estate listing business. How do I fetch a record from Zoho Creator and create HTML showing top-down information like comparison site below? David
Is it possible to count the elements in a picklist?
Hi, I'm trying to do count(input.Picklist_field) but zoho is rejecting it. Isn't it possible to do this?
Justify data in a record (Right/Center/Left)
I'm trying to center justify data in a record. Some records/cells default to left and others to the right. I can't seem to find where I can change this in Creator. I searched the forums and couldnt find much of anything related to creator. Thank you in advance.
Linking forms
Is there any way to link the information in two forms without using look-up fields?
Look-up fields - not in drop-down form?
Hi, When linking two forms with look-up fields, is there a way for the user to enter an answer in the look-up field in Form 2, rather than selecting from a drop-down which was populated from answers from Form 1? After a while the drop-down list gets very long and messy looking. Thanks, Elizabeth
Obtain data from drop box using lookup field.
Hi, I'm just having a bit of a issue trying to get data from a drop box in one form and recreate it in another form using a lookup field dropbox. Pretty much I have a add staff form which takes the first letters of the staffs first names to create a initial code in dropbox "Initials" which I then want to be shown on my add bookings form so it can be shown which staff member made (and stuffed up haha!) the bookings. If I try make a lookup field in add bookings it will not show me the Initials field.
Purchase Order Database
I want to create a Purchase Order database whereby I can create a unique Purchase Order number and add a quantity of product lines to the order and have it total at the bottom. Is this possible in Creator? Thanks, Martyn
to move app to another user; to change app as shared app
I have two questions: - is it possible to move an application to another user: I made an app, I share the app, the user I shared with keeps the app and I delete it ?!? - if a app is shared as developer, is it possible to make changes? (show as grid, change something and save it)
help
ive put my profile in twice how do i delete one of them???
Schedule sometimes says "An internal exception occured ", but why ?
Hi forum readers, I have written an interface using CRM API that's retrieving specific records from a view, then sync a creator table. As far as I know, here is no problem as I know of with the script, and all the records are currently retrieved, and creator tables updated. Every night, a custom schedule runs and calls this script. However, when I looked at account usage log for this schedule, I realized I sometimes get "An internal exception occured" message (see capture “Schedule Log.PNG”) After
Is it possible to have a pop up or other action when a person chooses a particular option in a drop down?
Just wondering if this is possible. I have a question on a form with 4 possible choices in drop down format. However if the person chooses option D I would like a message to appear in some format, either pop up? or some obvious way they can see it ! many thanks
Password and email
I was wondering if there was any way where you can get a fetch record (witch i dont know how to do) then find the email that they put in and have a password they have to have that is correct and it will let them move on and if it is wrong it will ask them to redo it. I dont want just one password i want every user to beable to do it. i also would likea way so that it will create a list that can be modafyed with all the passwords and emails so they are always there and if you delete the records they
Batch update lines
AFter a bulk-edit of a few lines, the "on edit success" email is not set. Can I enable this?
Using data from one form into another
Using data from one form into another Hello I have the form number of the Called To use the number entered in this form to pass as a standard script in a form in html Thanks
Prompt for input on record-level custom action
I'm developing a view with a custom action for each record, but I want to be able to have a prompt for one of the variables passed to the function. Right now it looks like all the arguments must come from the record. What if I want to customize a different message that is sent to each record's email address via a custom action? I want to be able to click on a button next to the record "Send Email" and then be prompted for custom input to pass to the email function. How would I do that? Thanks!
How to be a view filtered by a value of another form than the form of this view?
How to be a view filtered by a value of another form than the form of this view? Example: I have a view of a form with several fields. I have a second form with just one field, this field and numerical approaches. I want to filter the values of the first view of the numerical form with the information of the second form. Thanks
can't get field.select("XXXXXX") to work
I have a form <Contacts> with a field <Roles> (Lookup, Multi Select, Checkbox). In a script I want to select one of the values. I use the following statement (after fetching the appropriate record in <Contacts> using Collection x): x.Roles.select("Volunteer"); I get a message that this is not a valid statement. What am I doing wrong? thanks Henk
Adding records through email and Auto Increment field
I have a form that has a field whose value is auto-incremented on load (as per your auto-increment code examples). It works fine when I add a record using the form. Now I want to add a record through email (using the email template and email ID of the form). I tried adding a record without giving any value to the auto-increment field (because I cannot guess the value), but it does not add the record. My question is how do I add a record through email to a form that has an auto-increment field.
Sorting fetched records from a simple formula
I have a simple formula: First_Name + " " + Last_Name + "-" + EID where the result of such is being used as a lookup field across several forms and apps. My problem is that the data in the lookup is not sorted in any manner (i.e. the list in the lookup resembles this: Stephanie, Bill, Nancy, Carl, Steven, Ashley etc).It would only make since that the list of names were at least alphabetized by the first name. Where can I set and/or manipulate this sort? Thanks, Chris
"Function doesn't exist" error. When referencing outer app function
I'm getting the following error when I try to reference a function in another application. Last I checked this is totally acceptable.. "Function doesn't exist"
Rendering Issues creator.zoho.com/mobile on iPhone iOS 4.2.1
Anyone else having issues getting Creator forms and the My Apps page to load correctly when accessing creator.zoho.com/mobile from their iPhone? All of my forms pages show the top and bottom header/footer/links but the middle form area is a white box. If I click on the My Apps link it loads a white page. I have javascript on so that shouldn't be an issue.
Removing shared app
A number of apps have been shared to my account that I no longer need. Is there a way to remove them from my Shared Apps list? Herb Wexler www.preventingmediocrity.com
Designer PDF Forms for Zoho on you own server
DESIGNER PDF FORMS FOR ZOHO I thought I would share this because it took so much of my time to figure everything out. I wanted forms that looked sexy and professional. The export pdf function of Zoho was very limited as are most pdf export options of many programs. Only high end expensive programs have options to really make fancy forms. I liked the simplicity of Zoho in building forms but I wasn't happy with the output. My programming object of the PDF form was simple. 1. Take Form data using
getURL() hangs on me for (what seems like) a valid URL...having trouble with APIKeys too
If, when logged in to Zoho Creator, I type:- http://creator.zoho.com/liamzoho2/sfit-email-templates/rss/Employee_Detail_View/ into my browser address bar, I get a nicely laid out response which shows the records in that Form View... But...when I use 'getURL()' within another form to try and replicate this...the system just hangs....here is a code snippet...suffice to say, if just hangs on the first line... response = getUrl("http://creator.zoho.com/liamzoho2/sfit-email-templates/rss/Employee_Detail_View/");
Problem inserting new record
When I tried to insert new record I suddenly encountered this problem. As you can see I got 3 FORM in this apps. Stock In & Stock Out Form contain 3 lookup taken from StockList Form named "Category/Code/Description". I dont know how to identify this problem. Please HELP me asap..
What happened to the PHP Expense Tracker application?
Hi, I was looking at using PHP from an external website to access a Creator Form and cam across this blogpost which looked interesting... http://blogs.zoho.com/creator/apis-for-zoho-creator But the link to the example provided (or at least I got the impression that this example was PHP source code)...http://creatorapps.zoho.com/ is broken... Is there an alternative I can look at, or can anyone else provide some PHP code examples for accessing Zoho Forms from external websites? Regards, Liam
Lookup fields problem
I have a lookup field that draws from another form, but the other form has some fields with the same value. Is there anyway to leave out multiple values and have it show up as just one entry?
Beginner questions
I just arrived at Zoho Creator today in search of a simple way to embed some databases I have in my web sites. Totally basic... table view, ability for my web site visitors to sort and search, NO editing capabilities and NO form filling by any site visitors. I tried a basic setup with the trial version after I signed up and what I ended up with using the embed code is overkill. Edit controls are there as are form views, etc... stuff I don't want. Who wants their web site visitors to change their
PreparedStatement Error in Data-Dictionary.
1 . [t_621460000000013065] Exception occured while setting value in PreparedStatement for the Column [Appointmen_621460000000116141] Check whether the datatype for this column is given as specified in the data-dictionary .[t_621460000000013065] Exception occured while setting value in PreparedStatement for the Column [Appointmen_621460000000116141] Check whether the datatype for this column is given as specified in the data-dictionary This is what displays when I try to add an appointment in my
Can't fetch record
Hi, I have an html view that generate a print page (in pdf). I can't fetch records, I think that I do a bad use of fetch command, but I can't find the error! Any help? Mic Here my application
i18n and l10n via export-import of app as script
Zoho Creator does not provide any kind of i18n or l10n facilities. However, the applications can be fairly easily made translatable. mark all visible labels in the app with a prefix to mark them as message ids export the app as script extract the message ids translate them (re)generate a new translated app using the app script file and the translations (re)import the app script back to Zoho Creator Thoughts? Is this proposed or described already somewhere?
Is it possible to show a related field on mouseover hover on a Zoho Creator Chart?
I have a bar graph of "daily distances covered" (my running log). I would like to show a related "daily notes" field (which is a text field associated with the distance field, like how I felt, or what the weather was like) when I hover over the bar in a Chart View within Zoho Creator. Is it possible to set up an action on mouseover of data displayed on a chart? Many thanks, Nick
Code to add multiple file upload fields?
Hello, is there a feature in the creator where I can make a file upload field with an option to add more files? I am trying to do something similar to Gmail when sending an email you have the ability to continuously attach files. I only need it done for about 5 files at most but for the sake of organization and cosmetics, id like to only show one at a time.
Input Field Behavior
Would it be possible to have the ability to correct a field input within the field input without the problem of reiteration. This would work well for range problems. The only work around is to have additional fields that have call functions to fill in values or to try to do this in Validation which does not allow the user to necessary see the corrected values.
Forwarding contact responses to my email
I'm having trouble finding where I type in my email on my contact form so when someone fills out the form, the responses go to my email address.
Need help relating forms!!!!!
Hi, I a new to this but here is my problem: I created a form (Requerimientos) that is going to be filled by some person, then I created another form (Informe) that is going to contain the info that was filled on Requerimientos. I am trying to place a lookup field and opens the box where asks me to select the app where I want to get the info, the app is OK but then I cannot find the info I want to get from the other form, it is too general and does not relate to a specific form, therefore I can't
How to show forms in iframes in "Rich Text" fields? Works for views, not for forms
I set up a rich text field and inserted as html the iframe snippet for a view, and it works well. However, fields do not show when the same is done for forms. The header shows, as does the sliders; however field names and the fields themselves do not. I tried customizing field sizes and colors, but it makes no difference. Also not shown if done as a form-perma, though again the view equivalent works fine. Would make it neat to insert affiliated forms into other forms and even into views, were
Next Page