Image fields
Can I auto populate the image fields Source, Title, Alt test and Link Thanks
Supported Browser Versions ...
Over here ... http://help.creator.zoho.com/FAQ-General.html ... it says ... What browsers are supported by Zoho Creator? Zoho Creator supports the following browsers on Windows and in major Linux flavors. - Internet Explorer 7 & 8 - Chrome - Firefox 1.0 - 4.0 - Mozilla 1.7 above I am currently running Firefox v3.6 ... and the Mozilla guys keep nagging me to upgrade ... only problem is, the upgrade would be to v7 ... which is not on ZOHO Creator's list ... what is a user to do ? When I replace my
Does Stateless form submission bypass all other form scripts
Hi need to check I have a stateless form which is inserting values into another form as the form is referenced in the insert statement i am wondering if the insert will pass through any script (on add/load/submit/success. Reason, the stateless form submission has different rules than the normal form submission Thanks
How do I enable date specific search options when the date field is specially formatted.
Hi there, I followed this forum post: https://help.zoho.com/portal/en/community/topic/how-do-i-format-a-date-time-value-in-a-view And used this to format a Form date field into formula field: input.givendate.toString("EEE, MMM d, yyyy, HH:mm aaa") The problem is that in my View, the date specific search options are no longer visible. ie: Next 7 days, Previous 30 days etc. Is there a way to enable those for the formula field that is holding the formatted date? Thanks, David
Import Deluge Script
Dear Zoho Team, I cannot access the link "Import a creator app through a DS file", which you mention is displayed at the bottom left corner of the Create New application dialog. I have a free user account.
Announcing : Subforms in Zoho Creator
Zoho Creator makes building customized business applications a breeze for thousands of business around the world. Today, we are happy to present to you the latest from Zoho Creator. Introducing Subforms . Zoho Creator users are familiar with the Look Up field. A lookup field establishes a relationship between two forms in such a way that each parent record is associated with only one child record. Subforms are the next logical step. Subforms are of use in scenarios where each parent record needs
Importing with a date that isn't auto-selected hides the "date format" option.
So, this is fun. I'm migrating data from an old Zoho account to a new one. Steps: Create a form that has a date field, where the label has a space in it. (In this case, "Confirmed On".) Add a few records. Export from Zoho to CSV. In the new app, start an import: CSV, local drive. Upload the exported CSV file, and click Next. The issue: "Confirmed On" isn't selected, even though the first row has labels, and the old form's label matches the new form's label exactly. There is no Date Format option.
When can I use zoho creator to develop mobile applications (full support for Deluge Script)?
Hi When can use zoho creator to develop mobile applications (full support for Deluge Script)? Thanks! Stanley Guo 2011-10-6
How do I post raw code into a Rich Text field without executing?
Currently, when I paste sample XML scripting into a records Rich Text field, the record updates with the tags removed. For example, I want to paste <name> john </name> after updating the Rich Text field shows as john I don't want anything to be executed in this field. I've put in a Plain Text field as a workaround, but even those tags disappear when in a records view mode. Please help! The whole purpose of us creating this application is to track XML protocol information. Thanks, Brent
can't edit individual record
Hi all, For some obscure reason, I can't edit individually any record from my main list view anymore. The black loading screen appears, with the "Please Wait..." message, but the more I wait the less anything happens. Editing form simply never appears. Strangely enough, I'm able to "bulk edit" records (including records one by one). The form is also slow to load, but it works. Any suggestions? Cheers, D_
Import - Delete if exists
Hi! I have downloaded some data from my application and made some changes en-masse because I changed the structure of my database. I now want to re-upload the downloaded file to the relevant form and update the data. From what I have read, it looks like using the Migration Tool is the best option as it allows adding of data to Zoho Creator. However, I have been unsuccessful in updating the data as I cannot match based on the field that I would like to match upon. I only get an option to match based
Linking to outside sites
Can you link to an outside site from a zoho creator application. For example instead of a view or form appearing on the side bar, you just had a link to a regular website?
RSS Feed From Creator?
I fished around a bit, but did not see a straight forward answer... So, I will ask... Can you create an RSS feed from Creator. I plan on using a form to have businesses enter info into Creator. Then, I would like to use an RSS feed to display the business info on a web page. One more question... Can I password protect the form so that only authorized users can submit the form? Thank you. R
zoho creator Send Email issue
Hi I have created a zoho Form and when submit button of form is pressed an an email is sent automatically.It is working fine on my PC. But on my clients Computer It gives following error when submitted using IE or Safari "Error occurred Please contact application owner".But it is running fine on even client's pc on Firefox. So i m stuck with this issue because i m not being able to understand the reason of this error. Regards Rana Ammar
View Criteria based on variables
Hi All, My goal is to launch a view with criteria set according to a variable, ie: show all rows from Employees [empid == my_var] I've tried a workaround with the openurl function, but the edit/delete buttons on the resulting window are not working, and I would like the user to edit the Employee form he just accessed... Any way to make this work? Thanks, Tal
Formula updates triggered by?
When are form formulas updated? In other words, what triggers a formula update? 1. I know manually editing a record w/o a single field change will do it. 2. I've updated a record through deluge script and that worked on one form but not on another. Thanks for your help! -Stephen
Update a records Subform value or values
Hi Have fetched a record which contains a subform and i want to update (maybe later add) a subform entry to that records subform fields Script builder shows me the subform in the collection variable but from there i am lost Is this possible to do ? What is the syntax procedure thanks
Custom printout in Creator
Hi. I have a database called Laptop Sales. In the database I have listed all the laptops I have for sale in my shop. When I want the display sheet for the window showing details like Make, Model, Memory that I have in my database, I use MS publisher to create the nice looking display sheet manually inputting the data. How can I use Creator to produce a display selling sheet using the data I have stored. Thanks
Record id question clarifications
Hi Am about to embark on another coding adventure but need check on the following 1) If you delete a record in a form will its record ID ever be used again when adding a new record to that form 2) Are record ID's unique to the entire application or are they only unique to a particular form Thanks
Getting a list variable to work in a script
Hello, Was wondering if you could help me with how to set a variable derived from a list as a suffix on a field name, Below is my 1st attempt at scripting. Basically I want to do the same If and else statement for three form fields. I thought I could use Custom function but it does not like the 'Clear' item in the if statement. Child_option_1 Child_option_2 Child_option_3 //// Script optionno = {"1", "2", "3"}; for each Option_var in optionno { if (count(Testform2[Parent_option == input.Product_Parent])
Lookup Field by ID
I have a form with lookup field "Employee" reference to the employee form by Internal ID. with Display field "Name" For some reason I cannot have 2 records referencing to the same employee. if I select Employee that is used on another record, Employee from another record disappears. Problem 2: maybe related to the same issue, I cannot delete record now. Zoho loops
How to sum a separate table
I have two forms, an Expense form and a Purchases form. I want to very simply set up the expense form so it is: Account Number Budget Spent Balance xxx-xx-xxxx $15,000 $1,294.56 $13,705.44 yyy-yy-yyyy $20,000 $0.00 $20,000 Very simply I want the Spent column to automatically pull the total sum of all the records in the Purchases form that matches that account number. I tried doing all this scripting
Easy step by step instruction on how to make an image appear in Zoho Creator from a url
I have read many Zoho posting on how to add images and render them into Zoho Creator but find them confusing. I am a small business person but can follow detailed tech instruction when they are laid out with simple and complete step by step instructions. I want to include an image in zoho creator that refers to a separate image. I think some the existing posts refer to the creator before it was upgraded as some of the screen shots are not consistent with what now appears in the program. Can someone
importing application from a DS file
On the create an application screen the "Import a Creator App through a DS file" does not show on the bottom of the screen. Has it been moved? How do I import a DS file? Herb Wexler
Group the views menu (in edit mode) by their form/html/stateless
It get's really difficult to find the view you are looking for the way the view menu is laid out right now. I think grouping the views by their underlying form, html, or stateless would be very helpful to developers. Thanks in advance for your consideration ;) -Stephen
Help with some Deluge script please
Hi, If there are any budding script writers out there, could you help with this one. I need a script to populate the 4 fields of the image field as follows. I have 2 forms 1st form is called Dealers the 2 fields from this form we need are Picasa_URL and Picasa_folder 2nd form is called Laptop Spares The 1 field we need from this form is Item_Number now on the Laptop Spares form when I input the Item_Number I need the image field to auto populate as thus... source = Dealers.Picasa_url + Dealers.Picasa_folder
Importing Data From Excel
Hi, Can someone please advise if I import data from excel how do i avoid duplicate entries being imported. I can't find that feature but I might not be looking in the right place Regards Jodie
filter for a lookup field in a view
I have a form with a lookup field "Employee" that references to the internal ID field. In Advanced display option, I selected Display As: "Name" When I create view for that form and select Employee, column, it properly displays "Name field, however when I try to use this field in filters, the displayed values are internal IDs. Displayed values in the filter should match to whatever is selected for display. Another option would be to allow filtering on referenced fields, It would be even better,
error Sharing Creator Application
I am trying to share my new creator app and I get an error message: "[My_Shared_Pages] null, message from server: "Duplicate entry '660708000000021617-660708000000021531' for key 1" I shared it at one point and then unshared it. What is the problem?
Tool tip to be list items?
Hi, Right now, the tool tip shows the "help" description you put in the field configuration. But can the tool tip be configured to show each list item when it is hovered over? In other words, I have a drop down list. But some of the items are longer than the field length which makes it harder to read them. Can the tooltip be used to extend each list item's text? I've seen this done before elsewhere, but can it be done in Creator? I'd rather do this than expand the length of the field, which
What happens when an email fails?
How does Creator handle an email that is sent to a person in which their inbox is full? How does Creator handle a mis-typed email address? Etc...
Date validation
Hi all ! I have date fields and date-time fields with the formats [dd/MM/yyyy HH:mm:ss] or [dd/MM/yyyy] Some of users hit the date as dd/MM/yy (Hiting the year as yy or yyyy is frequent). Then the date : 30/09/11 is submitted in Creator as 30/09/0011. Is it possible for creator to detect it and submit the data correctly (2011), or what kind of script can I write for this please ? Thanks Cyril
NView not defined in the Workflow
For the second time in two days (two different applications), I got this error message when attempting to save a section code ... NView not defined in the Workflow ... this last time, I restarted ZOHO Creator, navigated back to this section code and (without making any changes) attempted to Save it ... and still got this message. Please explain ... a) what this undocumented/undecipherable message means b) how does one get around this ? Gaev
List Support in Reports
Reports currently do not support lists as a filter criteria. In order to view a report that meets some limited criteria, you have to edit the view criteria first and then regenerate the report. John M. Whitney
Browser Testing
Adobe offers a service for free that allows you to test your ZOHO Creator pages in different browser/OS combinations. For example in my testing, Firefox on OS X required a page load time of 10 seconds, while Chrome allowed 0 seconds load-time. Also, every now and then I'd get the dreaded "Error: Contact Application Owner" page while other browser/OS combinations were fine. Here's the link: https://browserlab.adobe.com Enjoy! John M. Whitney
My Functionality based URLs is not stable
Hi, My client have a html view which passing parameters in the html view url, and fetch records by using the parmeters. However, after keep on testing, there are 30% chance that we can't fetch record in category and subcategory. I guess I make some mistake in construct the url parameters. I already enable support access. Could you please help me to take a look? Thank you. My client also intensive enter a lot of symbol in the database which cost a lot of problems. For example, " (This is for size,
Dynamically adding items to a drop down box present in a subform.
Hello just looking to get an update for when functionality to dynamically add items to a drop down box present in a subform will be available in Zoho Creator. This would be very useful for the application I am building to manage product configuration selection for customer orders. Cheers
Deluge script in for Schedules
i have a problem with my schedule, that falls for deluge scripting limits.. But i don't understand why: i have made many attenction to the scripting to not update all record but only the necessary records.. Thanks for urgent reply..
Dynamic Picklists Within Subforms
I've started trying to integrate the new subforms into my application, but have found that my dynamically crated picklists, don't dynamically change, when they are used as a subform. Is there a way to keep the dynamic nature of my fields, while having them as a subform?
intermittent issue with notification bar failing to update
The service is very slow at the moment. For example, saving a short script is taking 30-60 seconds. (EDIT: To clarify - as mentioned below, it later turned out the script is in fact saving ok but the green notification bar is sometimes failing to update.)
Next Page