Parameter passing
I am new to Zoho, can any one help me out in the concepts of "Parameter passing". Can any one share the link were do i get the concept clear. I am stucked up very badly.
com.adventnet.workengine.task.TaskExecutionException
Hi, My system return this error for several schedules used to update a form. I don't understand what happened, it was working fine last month. Who can help me? To explain: I've got a form A and a form B. I import datas in the form B (6200 records) and I use this records to update monthly the records in the form A (6200 records too). Because of the limit of executable statements per deluge action, I use form schedules delayed in time (2 minutes) to detect the import of data and update some fields
Populating a picklist with values in another form
Hi Guys, It's been a while since I've done this - can you assist please? Form1: 'Job_Numbers' Has two fields 1) Job_Number & 2) Client (lookup) Form2: 'Job_Elements' Has two fields 1) Client (lookup) & 2) Job_No (lookup) I want to populate the lookup field Job_No with the Job_Numbers stored in the Job_Numbers form where the client is equal in both forms. I hope this makes sense. Many thanks, Martyn
Formula field does not work on currency input?
First , I tried to create a formula field with a Currency field as input... it does not work? Second, how to round up the calculation result in a Formula field to 2 decimal points? Thanks a lot folks ! Love your apps!
Printing Current Date With View
Hi, I am wondering if there is a way to add the current date to the title or header of a view. I would like to have the current date appear at the top of a number of my views when they are printed. Thanks, Emma
Problem deleting record(s)
I cannot delete record where branch name == "junk" from https://creator.zoho.com/mllwydberger/#view:company_info_view I am in the middle of experimenting with converting an existing database with lots of relationships. Today, I also could not delete records in a form with multiple lookups after I uploaded the same record multiple times to do testing. That time, I just deleted the form and started over. As for the record listed above, I think I created the company form the first day I started playing
Unable to see Customer Table when creating a New P.O.
I just got this problem. When I try to create a new P.O., I suppose to search customer from a Customer Table. But now when I select the table, I am not able to see the list of customers. Please help!
Excel formula to Zoho Creator formula
I am trying to replicate this Excel formula into Zoho Creator; but it's not working. Can you take a look for me? =IF(INPUT>2000,(INPUT-2000)* 5%+2000*0.07,IF(AND(INPUT<=2000,INPUT>500),(INPUT-500)*7%+500*0.1,IF(AND(INPUT<=500,INPUT>100),(INPUT-100)*10%+100*0.14,IF((INPUT<=100),(INPUT)*14%,0)))) It works fine in Excel.
Dynamic Form Embedding
I join the request for RTL support in Zoho Creator - especially critical for me in form embedding. Another possibility is to allow users to add ANY html code before and after the form is embedded, this will allow us to change direction (and also fonts, css, etc).... This would allow us to insert a <div dir=rtl align=right> before the rendered code, and </div> after.
Can't Update data in CRM through Zoho Creator
Hello Zoho Members and Programmers I am created an application which puch data in Zoho CRM Contact module, everything is fine data is successfully stored at both locations Zoho CRM and Zoho Creator. Now i want that when i am edited any data row in Creator then corresponding Zoho CRM contact module row is also updated. So for this i am follow following post: https://kbase.creator.zoho.com/crm/how-to-get-the-id-of-the-crm-record-that-is-created-using-the-zoho-crm-create-task and use following Coding
How to send a filled form in my own email
Hello, I am new to this so all help is welcome. I have succesfully created a form and posted it on my web site. How do I get the filled form into my email and not into the Zoho creator Contact View. I trired changing the set email notifications, the TO: email in to my own but I still do not get the filled form into my own e-mail. What am I doing wrong? Thank you for taking time helping me, Erja K
Tell a Friend about Zoho Creator - Win Cash Rewards!
A lot of you have used Zoho Creator for building your customized business applications. Some of you have also told your friends and colleagues about Zoho Creator and how simple it is to conjure up a custom application in minutes. Thank you, each and every one of you, for spreading the word on Zoho Creator's awesomeness. Here's one more reason for your to continue doing this wonderful deed. Presenting the " Tell a friend " program. Tell all your friends about Zoho Creator - its simplicity, its many
Counting Checkbox selections?
Hi, I'm trying to count the checkbox selections in a form and then use the result to calculate a currency amount and populate another field with that amount. I have a checkbox list and in its On User Input event I have: NumSigs=0; for each r in Members { NumSigs=(NumSigs + 1); } input.Total=(input.SIG_Fee * NumSigs); This works a little, meaning intermittently, but not consistently. When I put an alert on the NumSigs=(NumSigs+1); line, I consistently got an alert that said NumSigs was "1," "2," and
Print HTML View - Suppress Header & Footer
Is there any way to either suppress the headers/footers when printing an HTML view or to set a text value to be printed?
View
Hi, Can a "View" be customized based on user's login id? Basically, I want a user to see info related to his user id only on the view and not about other users. Thanks! V
Schedule criteria not saving
Hi, I have a decision box on a form for sending out a task reminder 10 days before the event and the schedule code looks like this: Task Reminder { Execute on 10 days before of Tasks[day_reminder == true].Due_Date at 01:00:00 } It saves fine and no errors appear but when you reload the schedule page it changes to this: Task Reminder { Execute on 10 days before of Tasks[day_reminder].Due_Date at 01:00:00 } Need to get it run the script only when the decision box is ticked..... Any ideas? Thanks
Application Ownership
I have added an administrator to my account who created a new application. While my current account states I have 10 user capability the application the new administrator created says it can only share 3 users on a free account. Since he is an administrator on my account shouldn't it be possible to share with all users? Thanks Bilmathis
Subforms on views attached to scheduled emails shows record ID
I have a form with a subform which shows correctly in a view. However when the view is attached to an email as a PDF in the schedule system the column only displays the subform record ID. Herb Wexler
CASE INSENSITIVE EXAMPLE PLEASE
I don't know coding and i would like someone to post an example of the contain() functions. i want the search field of my stateless form to be case insensitive.
Creating full-fledged app with Creator
I've set up a basic Creator application, with several tables. It's intended to keep track of application specs, functional tests against the specs, and defect reports. However, it's unclear where I go from here. I'm used to doing database apps using C# and SQL Server. I realize that one option would be to keep using C# and the Creator API to manipulate the tables. But I'd rather do it all in Zoho. So I'd appreciate help in getting started. Maybe there's a tutorial I've overlooked. Anyway, here's
crm.create doesn't seem to be working for me
Hello, thank you for your help in advance I am trying to do a simple zoho.crm.create("potentials",map) I have placed the script under the submit onclick button, but when I look in the crm I do not see the new potential added. Any help would be greatly appreciated (I also have it so you can edit the application already) it is under test/add_potential this is how the script looks NewOpp={ "Description" : input.Plombier, "Nom de l’Opportunité" : "Test!", "Nom du Compte"
Column Widths
Hi, In trying to adjust column widths I'm not seeing any significant decrease in size. I need this app to be as straightforward as possible as I have users logging in that are not very computer literate. Having to scroll through multiple pages of data is going to be problematic. Any help would be appreciated! I'll make my application accessible to Zoho staff. Thanks, Diana
I have two identical (lookup) (checkbox) lists. I need them to have the oppsite selected
Okay, I have 2 fields. Each field is a lookup field that looks up the exact same data in another form. I have them set to checkbox fields. What I need is for them to be opposites as far as what they have selected. Say for example I have them lookup the following data: (A, B, C, D) So the form will look like this (the "X" will represent a checked box and a "O" will represent an unchecked box) FIELD 1 X - A O - B X - C O - D FIELD 2 O - A X - B O - C X - D I'd like it so that whenever you check or
Limitation With Multiple Calls to Function?
I have an HTML view that creates a table with 15 x 10 cells. Most of these cells contain a number that is called from a function. If I include this function-call (line 20), the view fails to load. If I remove it, it works. If I call it just form one cell, it returns a number. htmlpage SUBSTATS() <%{ TABLE = "<table width='400' border='1' cellpadding='1' cellspacing='1'><tbody><tr><td>Mailing List</td><td>Total Subscribers</td>"; for each sec_list in LISTS [LIST_TYPE = "Secondary"] {
Lining up a Decision Check Box
When using a decision check box it lines up to the left edge even when the Field Alignment is set to Right. This makes the form difficult to read. This is the only field type with the label to the right of the data entry portion. Perhaps the label can line up with data entry portion of the other fields on the form. Herb Wexler
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com. Noticeable changes: Short Circuit evaluation is supported in Deluge IF statement - more info OnEdit -> On Validate/On Success actions will get triggered when values are updated through drag/drop action in calendar view - more info Dialogs (eg: alert/warning messages) in IE are positioned exactly in the center of the window Complete change logs are documented at https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html.
Excel formula to Zoho
I'm trying to adapt the next formula from Excel to Zoho but, it changes the formula: This is the formula what I'm trying to insert: 4.6 + (0.182258 * (Kilometers * 1000) / (minutos + (segundos / 60)))) + (0.000104 * (Kilometers * 1000 / (minutos + (segundos / 60)) * (Kilometers * 1000 / (minutos + (segundos / 60))))) And this is how it channge: (4.6 + 0.182258 * Kilometers * 1000 / (minutos + segundos / 60)) Please, someone can help me, I've tried everything.
using payment form
when submit is clicked and it goes to payment, if the payment is not completed, the form still creates a new record. i don't want it to create a new record unless the payment is successfully completed. can this be done?
Find maximum date/time
I use deluge scripting to find the record with the maximum value in a date/time field. To fetch that record I have to advance the maximum value with AddHour(2). Does that make sense to anyone?
ALL APPLICATIONS MISSING!!
Logged on to my personal account this morning and found ALL MY APPLICATIONS with my data MISSING. I Tried to edit the application but no application in Zoho was found. Is there something wrong with the service??
Subform edits not persisted
After updating a form in which subform data is changed, we receive the "Data Successfully Updated" message, but sadly, the subform data remains unchanged.
On Add --> Validate : Script Action Fail
What I am trying to do is have an alert box pop up if a field value is null, but I only want this to happen once on validate and if the user decides this null field is ok then the user can submit again without having an alert box pop up. Currently I am trying: if ((input.Radio_1 = null) && (input.hiddenvalue != "nullcheck")) { input.hiddenvalue = "nullcheck"; alert "You have not completed the form are you sure you want to submit? To submit click ok then click submit again."; cancel submit;
Report based on date range
Hi, I have created an application to track jobs performed by each individual. I would like to generate a report based on how many jobs a particular person performed based on a date range and get a total amount of jobs for example: Example. ......DateRange: 06/29/2012 - 07/02/2012..................... UnitSize: QTY: Rate: Total: 3 Bdroom 8 $10 $80 4 Bdroom 10 $20 $200 GrandTotal
Trying to autofill potential using the creator
Hello and thanks in advance for the help, I am new to Zoho but know how to program. I am building a form that uses labels to find 1.a contact (using Zoho CRM label) 2. an item serial number(using the database lookup) 3. and then creating a simple activation code for a product(using a function that returns answer in a label. Now I want to have the user to create a new potential (that will be set up with a Zoho CRM label) but on creation it autofills the values that have already been input (the contact
Again, what script will the new Drag & Drop calendar date change feature call?
I'm desperately trying to negate the effects of the drag and drop feature because it does not allow me to control the manner in which users change record dates. I haven't been able to get any script to call upon a drag and drop[UPDATE: the problem was on my end...I was testing older dates that didn't have my control field value loaded.] If someone would please post here an example of calling script with the drag and drop I would greatly appreciate it.
joining two forms
If I have a form of orders that includes zip code and a form of userid/zipcode (they can service more than 1 zip code) how do I create a view that shows each userid only the orders that match a zipcode in their userid/zipcode list?
Issue with duplicate entry
Hi, I have a form that asked user choosing an id channel (a device), a timestamp and a value. I would like my application does not record the value for duplicate timestamp but only if the id channel is the same. If id channel is different, I would like my application records value even timestamp is the same. In attachments, the 1.png shows the different id channel. the 2.png shows the first record I made for id channel Z0 the 3.png shows the issue I met : The id channel is different but as the timestamp
Messages section error
When I enter in my account - Messages section, I can see the following Regards, George
service not responding
The service is unresponsive or has slowed to a crawl. Our internet connection is working fine. Please resolve urgently.
Help Writing a Script
Hi All - I have a form that I need script form and I can't get it to work. I have a series of five check boxes with the responses ranging from 1 to 5 and want to add those responses together in another field when the user enters a response. For example, if the user enters the response of "5" for each check box, I want the total of each check box to show as "25" in another field. How do I write script for that? Thanks.
Next Page