List Initial Values for Variables
I cannot find this in the help section, but think it would be valuable as a reference. When creating a form-field variable or user-defined variable in code, what is the initial value? Some will be null, some zero, some blank...please list list the values for date, date-time, text, multiline, currency, rich-text, etc etc... Thanks John M. Whitney
Send grid and creator?
Right now I export to spreadsheet every week, my creator list of emails. Then I mail merge with outlook and send through sendgrid. Anyone have any advice on how to "auto grab" my current list of emails ( instead of having to export manually)?
Application Forms Editor is not showing my Form but instead 291: Stacktrace:'
Please help, After saving the form I just created, I wanted to make some more changes.. so I went back to the Forms tab then selected my form. Here I get to see the Basic Fields and Advanced Fields things on the left but my Form isn't showing up!! Instead I get the error text: 291: Stacktrace:' Screenshot attached.
Need you help
Ruben I have not received your reply, please check to link https://help.zoho.com/portal/en/community/topic/need-help-for-deluge-script-builder Thanks Stanleyguo
Import App link not available!
where is it???
CSV Import Problem
I am not able to import a csv file into a view/form. I select the file from my local drive, and see the data in step 2, "Preview Data", but when I click on the "Import Data" button, no rows are imported count. Success Count = 0. Please help.
Code for age calculation
This is what I came up with to calculate someones age using a date field for the birthday... probably there are easier ways?! By the way, some scripts (including this script) won't save when you edit it after first save. This is because zoho strips stuff out of the code which kinda breaks it! ( ( ( ( ((zoho.currentdate.getYear())) + ((zoho.currentdate.getMonth()) / 100) + ((zoho.currentdate.getDay()) / 10000) ) * 10000 ).toLong() - (
Choices in CheckBox field get truncated in deluge Script
My Client ... whose Application has been running for about 15 months ... reported a problem yesterday ... which upon further examination shows that somewhere around this Spring/Summer ZOHO Creator introduced a defect related to the CheckBox field ... specifically ... 1) A Stateless Form has a CheckBox with about 50 choices that the user can select 2) In the Click section of the Form's button, there is code of that looks something like ... allSelections = ""; for each selectedValue in input.Music_Selection
Insert record into new form
I need to insert a record into a different form in the same application so that 3 additional fields can be added by user and saved into the other form. I'm not sure where to start, please advise. Thanks in advance for your help.
Referencing forms in other applications
How to reference forms in another applications?
Is there a password fields in Zoho creator
Hi Is there a password field (input characters are concealed) in Zoho creator? Or is there a way to use the text or number field for the password by concealing the characters? Thanks Lakshmi
You have been marked inactive
An application have been shared to some users and I was wondering why some can access the app while the others can't? I shared my app with another account I also got the same error but the user is showing as active on the user management. I also was wondering why the other user who can access the app don't have an edit option for the form.
Reports and Excel migration tool
Hi, I have a big problem, I'm using the MS Access and Excel Migration Tool and it's great. Now I can upload my data to Zoho Creator. The problem is that all these data don't appear in the reports, what I can do? I can see all data that I introduced without this tool in my reports. Thank you
Help with Zoho Creator HTML View please
Hi, I hope someone can help with this problem please. I have a computer shop and I have a zoho database with laptops I have for selling. Now when I want to put one in the window for sale, I use MS Publisher to produce the sales ticket to display with the laptop. What I want to do is create a HTML view linked to my laptop for sale database so if I want a sales sheet for say laptop no 12 the data for laptop 12 will appear into the HTML view. Hope that makes sense Thanks Nigel
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
Next Page