Global Variable
Hi, Is it possible to have a global variable in Creator? i.e. If I am in "form A" and I say that X = 5 and then I goto "Form b" and say input.number = x, how can I make this work? Nigel
How to set a field to a given value when a record is duplicated
Hi. I have a form in my application which has a field called Status. Status can be "Draft" [Edited - original post said "New", which was wrong], "In Progress" or "Closed". When an existing record is duplicated via the Edit/Duplicate function in the list view, I want all the data to be copied to the new record, except the Status field which I always want set to "Draft" [Edited - original post said "New", which was wrong]. I have achieved this using the script input.Status = "Draft"; under Form Actions
View colors problem
Hello, I fail to change the colors on a view that I have embedded on another website. I have tried all the commands at https://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html#6._View_Customization but they have no effect (although commands for other things that color work). Could anyone please tell me how I can change the colors? Would appreciate any help. Thanks
Added time
The automatic filed Added Time can be used as a criteria in a View. Can it be used as a Filer in a Repot?
For Each Loop values in Text Box
Hi, I have one form where all client outstanding list are there.. FORM A One another form is for Receipt Entry .. FORM B Generally I fetch the Invoice no from Form A in Form B using (for each command). Against receipt we select the Invoice no and on submit the Invoice no mark paid in form A. Now, I stuck at one point if some one give part payment of any particular Invoice then I have to manually modify the entry in form A. Is there any way where I can fetch the Amount of each invoice in Text box
Zoho Creator
Is it possible to set up an MySQL database on Zoho , and then manipulate it remotely from my desktop using MS Access as the front-end?
creator email coding
I have a date field in creator that fires off an email when the date is added. How / what is the coding to get a request "do you want to send the email y/n" as sometimes I don't want to send the email and when I update any other field it also triggers the email a second time!
Best approach for handling multi-page form (with uploads)
Hi all, I am hoping someone might suggest an approach or workaround to meet these requirements. Last year,we used a long form with multiple subforms to have users upload various documents. This didn't work so well as in the midst of uploading various documents user would sometimes forget to add a field or two and when the form was validated the entire content of the form would get wiped out if any error existed. This caused many headaches that I am hoping to avoid now. So I thought I would approach
Maximum fields
Hi, could someone please tell me the maximum fields you can have in a form.
How Do I Add New Line Character To Scripting Expression?
Have tried this.... field1 + "\n" + field2 .. and it gives me field1field2 ..where I am looking for field1 field2 how can i get a new line character into my expression? thanks
Rounding a number
How do I round a decimal value in a formula field to the nearest 0.5. For example: I would like to round the number 24.20 to 24, and round the number 24.40 to 24.50, round the number 24.75 to 25.00?? Thanks
radio button make checked
hi how to make a radio button default checked in creator Thanks hareesh
Deleting children/detail records
When deleting a record in the parent form of a master-detail (Parent form to sub-form) relationship, I am finding that the children records are NOT automatically deleted, they are left as zombies! Does that mean I have to create a foreign-key field in the sub-form that relates to the primary key in the parent form? if so, then I have to create a deluge script on "Delete" at the form level to fetch all the related records in the sub-form and delete them. Am i correct on this, or is there something
Accessing a field in the parent form
I am trying to build a deluge script in a sub-form field (on user input) but I need to use a value from a field in the parent form. I thought they were linked together but I did not see the list of fields in the criteria section, so I tried the following: (Form_name.Field_name), but that didn't work. Example: I have a field "Gender" in a customer form (parent), but the detailed sub-form is where I perform calculation based on the gender of that customer. Can you see/access the parent fields
What's the proper syntax for Else If Condition
Hi, I'm stumped on getting some script correct. Can anyone help? I have three fields: Field1 is a radio field with 2 options Field2 is a lookup Field3 is a lookup On loading the app I have: Field1 defaulted to option1 Field3 is hidden On User Input I have: If option2 in Field1 is selected then Field2 is cleared and hidden and Field3 is shown. After this I can't get the script right. I want to clear and hide Field3 and show Field2 again, if the user changes Field1 back to option1. Can anyone show
Is Zoho Creator Down?
I was working on an App and now creator.zoho.com isn't responding at all.
Creating CRM Task from Creator application
For certain requirements, there may be a need for creating a ZohoCRM task from your Creator applications. This post is about using a Creator form to create a CRM Task. Below is a simple To Do form which creates a CRM Task for each record added. In the above form Client is a CRM Field that refers a Contact Module. Refer this post for including CRM modules in Creator form Below is the code snippet that should be written in the on-Success action of the form to create a CRM Task taskinfo = {
How to use Zoho Produts for my site
I m owner of http://www.freecss.in/ ( Free Css templates ) . How can i use zoho products to make my site better
Edit a sub-form
Hello, I have a main form that includes a sub-form (one-to-many relationships) where the main/parent form has one or more records of the sub-form. When I created the main form view, I set the options to be able to edit, view, etc. When running the app, I go to the main form view and want to edit one of the records that I created (which also includes multiple records in the sub-form field), I discovered that I am not able to navigate to one of the sub-form records so that I can edit it as well while
Payment page
I need to create a web page where an item is selling for $1; my customer can purchase any number of units to make a payment to me via credit card. I have a merchant account and credit card payment gateway..... how can this be setup?
Stateless form: issue with lookup fields
I tried creating some stateless form. The issue with this kind of form is... the lookup fields can't be assigned a default value. ....or can I do something to rectify this?? please let me know. thanks gurus!!!
Reports in Creator -No Value-
How can I get the report within Creator to display without the -No Value- showing in the report?
Form design: segmenting fields into brackets
On my input form there are 40 fields. I need to categorize the fields into 5 to 6 segments.... how do I design this? Tabs? How to put a horizontal dividing bar between segments/sections? thanks gurus.
Selective : Form entry
I need to open up 5 out of 20 free-entry fields for users to enter data online. How can I do this?
Conditional mandatory
For some fields I want to make them "mandatory entry" if some other field's value is equal to a certain value. How do I implement this? Thanks.
Duplicate a form
Is there a way to duplicate a form without having to recreate a similar form? I have followed the instructions to do so via script, however, I am unsure where the code snippet is to be copied to.
launching Skype with hyperlink
With the wonderful little tool for launching Skype out of CRM, it got me to wondering/playing to see if it could work in Creator. I've come oh-so-close, but not quite. I've used a notes field to simply create a 'DIAL' with hyperlink that launches: <other> skype: +xx?call This is enough to open skype and attempt the call. Now I'm looking for some advice on how we might be able to incorporate the phone number from within the form. I've tried all kinds of quote/bracketing without success: skype:
Report accuracy
We have a system with over 8000 records. Our reports are inaccurate and even after refreshing they are still inaccurate. We also need to do multiple "regenerations" in order to get the accurate information. I have enable "edit access" to my applications. Please can you investigate and respond? You mentioned in older posts by other users a year ago that you where working on the problems with respect to reports not displaying accurately. I trust you have ironed out the bugs in your software within
can I add a Link in a form
My form has lots of fields, I want to use a "Line" to divide those, so easier to tell what group is for what. If I have a html web page, only need a <hr/>, but I don't know how to do that in Creator form Thanks
Custom Button
Does anyone know whether we camn create a custom button that can execute a script (i.i., call another form)?
Simple Formula Not Working (Error Message)...
Hi, I am trying to create a very simple formula but am getting an error message each time. Basically I have 2 drop down fields called Hours_Worked and Basic_Pay and I am trying use a formula to calculate the 'Amount Due'. So...as far as I can tell it should be (Hours_Worked * Basic_Pay). Eg: If Hours_Worked = 10 and Basic_Pay = 2 the formula should be: (Hours_Worked * Basic_Pay) - (10 * 2) - So the Amount Due should = 20. However, every time I try this formula I get the following error message:
Iframe width and height not working
Hi, When inserting my i frame in another webpage, the width and height values are not accepted. Please advise. This is only happening for one of my applications, the others are fine.
Updating Customer in Zoho Invoice
I am trying to understand how to update a customers information in Zoho Invoice from Zoho Creator. I am successful at using the geturl and posturl for most API functions. However when I need to update a customer the required I am required to pass and XMLString as one of the paramaters. I am unclear what this would even look like. If someone could give me an example. I am familar and successful with XPath Builder and have several scripts running that integrate with Zoho Invoice, but this is the
Conditional fields
Hi, I have a question about creating forms I'm willig to have an application that gonna contains many froms, one form is going to contain some versions, and in the other form I should display this versions, added in the first form, as a dropdown field. is it possible to do so? And, I'd like to have conditional fields, for example a field is not shown till another field is well filled Kind regards
Grouping members based on their age
Hi I have a list of members, where I have set up a calculated field that calculates the age base on the input of the year of birth. This gives me a list with different ages. However I would like to make a new calculated field that categorize, based on their age, the members into following categories, 0-29 30-39 40-49 50-59 60+ Any idea how this can be done in ZC Cheers DC
going to a specific page
Is there a way to navigate thru an extensive list, by pages or views, instead of the "arrows". I am updating many records, and whenever I stop for the day, I must navigate by the arrows 20 times and more to get to the specific page of 200 records where I left off.
Customize the height of the rows of the view
Html Hi I require a customized view of the high rows of the view inserted , to have more space on the bill, as well as the top of header. attached files
.Net C# APIs
Hi, Please tell me the steps need to be followed for inserting a record in my form created in ZOHO creator by your REST API. Please provide sample code in .Net C#. Thanks Gurpreet
duplicates
I'm sure it has been asked and answered, but I missed it. How do I find duplicates, based upon one column (name, in this case). Before I found ZOHO, I had my data in several different services, and when they proved unacceptible, had to move it. Each time I moved it, errors such as duplicates crept in. My best day in a long time was to find ZOHO. THANKS. Jim West
Zoho Creator printing
When in the Summary View, can I have a page break separating each record? So when I print the Summary View, I got one record on each page. Thanks.
Next Page