Cancel button stateless form?
How do I implement a "Cancel" button on a stateless form which simply closes the form? (The form in question is opened in a modal window via a custom button action in a view.)
Rebuilding Equipment
We are just starting with Zoho. We rebuild mechanical equipment for customers. Similar to an automotive repair facility. How would I want to: 1) Receive the customers equipment, Tear it down. 2) Recommend parts based on our database/inventory. 3) Have them agree or disagree and approve certain parts. 4) Give them a price based on labor and parts. 5) Repair, record repair procedures and tolerance that they can look up later I have been trying to use creator for my main form (PO, Equipment#, ect),
Auto-fill field based on pick-list field and current date field
On a form I have a pick-list field called Proposal Owner which contains values like this: JD - John Doe On the same form I have a date field called Current Date whose date format is MM/dd/yy. There is also the following (on load) script governing the field: //Lines 1-5: Current Date field scripting // Assign the value of zoho.currentdate to the date field input.Current_Date = zoho.currentdate; // Disable the date field from being edited by the user disable Current_Date; On that same form I also have
How to fetch a Product tax value (or taxes) in CRM?
Hello! We have different tax rates for our products in CRM. Using "zoho.crm.searchRecords" we get something like: ..."Tax":"Tax name 1;Tax name 2".... Is there any way to get the tax actual value and not only the tax name (or name tag)? Thanks
24-hour difference in time
I have a function built that converts time into decimal. The user inputs the time (e.g. 2:30) and it converts it a decimal equivalent: float totalTime(string timeIN, string timeOUT) { time = ((input.timeOUT.toTime("hh:mm") - input.timeIN.toTime("hh:mm")) / 60000 / 60).round(2); return time; } The problem is that it doesn't support 24-hour time (e.g. 14:30). Any times from 1:00 to 12:59 works but after that I get null. Is there an easy way to get this to work?
24-hour difference in time
I have a function built that converts time into decimal. The user inputs the time (e.g. 2:30) and it converts it a decimal equivalent: float totalTime(string timeIN, string timeOUT) { time = ((input.timeOUT.toTime("hh:mm") - input.timeIN.toTime("hh:mm")) / 60000 / 60).round(2); return time; } The problem is that it doesn't support 24-hour time (e.g. 14:30). Any times from 1:00 to 12:59 works but after that I get null. Is there an easy way to get this to work?
XML RPC API edit record requires all mandatory fields
We are using the ZohoCreator XML RPC API to update records in our application. Normally we need to update only single fields in existing records. In the past it was possible to specify in the XML only those fields, that we want to update, as long as the other mandatory fields already have a value. Since this week the XML RPC API seems to require the values of ALL mandatory fields, even if the values of those fields don't change. Otherwise the update fails and an error "Enter a value for xxx" is returned.
How to create formula with values from LookUp fields
I have a lookup field called LessonType to a view with the fields {name, wage, cost} I need to display LessonType.name as the choice but then I need to apply wage and cost to a formula that uses value in another field on the form. I try LessonType.wage and get errors, how can I get the values out of the lookup fields?
API, Error checking and check boxes
I cannot seem to get form validation to work for checkboxes in the website using the API. If run the form inside Zoho Creator, it runs my error checking and alert boxes. It does not do so from the website, even though it is on the submit button. This is the code I have on add > validate if (input.EggDishes.size() > 1) { alert("Only one option is permitted"); }My goal is to limit to only one out of two selections. I don't want to use a radio button because I have fields where I will need to
Creator API and close window
Hi everyone - I've been working on this for a while, and can't seem to get Creator to do what I want. I am using the Creator API to submit data. I am able to get a new page to open using javascript, in a new window. But, in the original window, the data submission is shown. I want to be able to close that window so the users don't see it. I've tried a bunch of things, including window.close in "on success" in Zoho itself, to no avail. Here is the code: <body> <form name="foodorder" method="post"
Creator API Issues
Hi, I have been corresponding by email and it seems the problem still hasn't been solved. I'm posting it here hoping that someone else might have some insight. Here is my issue: I am working on a client application that needs to interface with the Zoho Creator API. I had a question about relationships and your REST API. We have a data structure in such a way that there are Customer_Contacts and they have Delivery_Locations . We have views for these records and I want to be able to fetch Delivery_Locations
Import data in view-perma
Can i import data to zoho creator in a view-perma??? i only see this option in the aplication, but i need import from xls to creator in a html view....
Preset Dropdown selected item while make use of Lookup function
Hi Developement team of Zoho Creation, We have face to a difficult on handling Lookup function that fulfill the system requirement specification. Form A, for customer to input registration form. Form B, for admin staff to handling registration data. On Form B, we have successfully create a Text field for lookup any record that created by Form A. While the record has found, we are "copying" the Form A record data to Form B as new record. But, ... We are not able to make the Dropdown boxes to pre-select
Users creating their own account and login
I am trying to build an app for about 1500 users. I start with a private stateless form embedded in a website. Because the form is private the user is prompted to enter their account info (Zoho, Google, Yahoo or Facebook). See the first screen shot below. For the first time user I then want to use the share statement to share the appropriate sections of the application. But I don't know where to place the share statement. All that happens now is a message saying the user does not have access to the
Logo Customization on printed Records
Hello, I am curious as to whether we have the ability to customize the logo which appears when printing the records of a form, displaying our company logo vs. the zoho creator logo? I appreciate whatever information you can provide! Thanks!
Staying logged in for the day - is it possible?
In a therapeutic setting we have many activities for individuals to choose from. We monitor their activity in 10-15 minute intervals. I would like to do so through a single form throughout the day that I can use the dropdowns to choose a list of a dozen or so activities. The problem is I want to tab over to 8 or 9 different forms throughout the day and mark these down using my tablet pc rather than a paper and ink clipboard. I think what I am looking for is a way for the form data to be retained
storing and retrieving data
i want to have a feedback form which i can send it to my own choice of people and i want to store the results of the feedback as well. how can i do this
Application to manage magazine subscribers?
Hello, I am in need of a Creator application to manage subscribers to a magazine. The magazine has 1 and 2 year subscription options for both USA and International, so 4 possible subscription types. I would like the app to keep track of when a subscription expires and possibly email the subscriber when their subscription is near the expiration date. Is there a sample app out there that I could get a start with? I have searched but haven't had much luck. I could build this from scratch, but would
button for "approval / decline" and textfield "comment"
Hello everybody! I'm new. I'm trying to build an application that allows my colleagues to post requests for expenses. Once the requests are posted my boss wants to be able to approve or decline the requests and in addition to leave a comment to tell why he approved/declined. Putting in the requests and seeing them all in the "view" works just fine. I also put the buttons in the form. The problem: When I put in a a comment and press "approve" or "decline" nothing happens. How can I get the application
Variables and Functions in View Criteria
I am trying to be as forward-thinking with my application as possible. I know I won't be around to maintain it forever, so I thought that I could build a settings into a form: settings[string key, string value] I created a few functions so that I could access the settings easily: settings.get(key_) and settings.set(key_, value_) string settings.get(string key_) { return settings[key = input.key_].value; } void settings.set(string key_, string value_) { existing = settings [key == input.key_];
I want to display two buttons in a view, and then depending on which is picked add text1 or text2 to texttotal.
Hi there, I am a Scotman living in South Africa and have just run across Zoho and it seems great! I basically am trying to write a way so people can draft their own legal contracts based on making decisions online (in this case 54). I have already got a form where I enter all the options (all 1 of 2 choices at the moment) and the question they need to answer. The data is entered. I now want to display just the question and a button for option 1 and a button for option 2. If they pick option 1, then
Embedded form login failure redirect
Hi, I have some forms embedded in a website. Users can only login in to one form. Issue I'm having is: If user enters their correct username and password but on a form they do not have permission to access, they are offered to go to zoho home. I have created the username and password for them as they are not using zoho, just my site. How can I ensure that if login fails or login attempted for form that user has no permissions, they do not get the offer of entering zoho profile page. I would like
OnEdit refreshing the ZOHO form
HI, I created a zoho form. I need to load that form in EDIT mode. For that I created a HTMLVIEW ,which opens the form in edit mode. And then I am using the URL of the HTML view in ONLOAD of the form. The issue is ,while loading the form in edit mode it is refreshing the form twice. That should not happen for me. Please suggest any solution.
Get quote products from CRM
Hi! I try to get quote's products with such code: response = zoho.crm.getRecordById("Quotes", <quote_id>); and then it's not possible to access field "product" as a list, because it's a String. Such code: products = response.get("product").toList(); is not working, it simply breaks a string into parts by commas. How can I access products correctly? UPD: And how then to update existing products? If I pass a map with products to zoho.crm.updateRecord it will append this products to the existing one.
Issue with zoho.crm.searchRecordsByPDC
I'm trying to create a report pulling data from Zoho CRM. The problem is, zoho.crm.searchRecordsByPDC is not working as you can see in the screenshot. I have activated my application (https://creator.zoho.com/jeremy_nagel/nyko-property-group/) to support.
Need Help
Hi , My form has 66 fields and iam trying to add one LookUp to the form.The recently added lookup is not appearing in the form. Please help me out of this.
Bulk Edit remove multiple Upload Fields
I'm trying to clear out the data in 152 upload fields, just remove whatever is in them now. They obviously aren't showing up in Bulk Edit. Is there any other way to remove the data from more than one upload fields at a time?
Function call as a View Filter
While custom filters allow simple filed based expression to be evaluated, has anyone been able to call a function for each record in a view? Background: I have an IT equipment list containing date of purchase & I am trying to create a view called "Warranty Expiring". I have already written a function called isWarrantyExpired() which take in date of purchase & months of warranty included at time of purchase to compute & returns a boolean true/false if warranty is expired. What I'd Like To Do: Create
Print to Word, Print to HTML, Print to RTF
Dear ZOHO, By default, Creator offerts options for an HTML-view to print or to print to PDF. However, I'm actually looking for an option to print to Word or print to RTF or print to HTML. And maybe it is better to say: Download as Word, Download as RTF, Download as HTML. Is there an option to achieve this? Kind regards, Silvester Draaijer
Possible to populate a subform from a stateless form?
Hi Zoho, is it possible to send data from a stateless form to a subform in a 'real' form? The annotated screenshot below describes what I mean. Background I am creating a multi-stage registration process. Currently I've got the form set up using checkboxes to provide a 'wizard' effect: However, my client doesn't like the user experience of this (saying rightly that it's not very intuitive). He wants me to come up with a stateless form approach with "Next" and "Back" buttons down the bottom.
email notification with Advanced Display Option
I have a form that sends an an email notification on submit. This is the option under More Actions. This is a nice simple way to send an email with all the fields from the form. However for lookup fields the link field shows instead of what is set in the Advanced Display Options. Is there a way to change this so the email show the same information that is displayed on the screen and the associated view? Herb Wexler
Duplicate Entry when changing field type
I'm trying to change a multi-line field to a Rich Text field and I get the following error. Is there a work-around? Duplicate entry '218933000003474087' is not allowed as duplicate entries already exist Herb Wexler
How can i display a textbox based on user selecting one of the checkbox option
If one of the checkbox option for a field is Other i want to show a textbox next to it when user selects that option. How can it be done on a form.
Bi-Directional Relationship With A SubForm.
Dear all, I'm struggling with 3 questions for more than 14hrs and still i didn't get solved. So any one can help me on this?? 1) How to fetch records from parent form and update records in subform using Script. Example : Form - Orders SubForm - Products When i select a specific order all the products related to that order has to display in subform and when i save, that has to save to "products form" as well as in "products subform". Even if i add products related to that orders in "products
The number X is not allowed for this form. Only certain numbers are allowed for this field.
Hi, I have a form created with Creator that I use on my laptop and my Android device. The form on my laptop is still working as before, but on my mobile, since a number of weeks, the form does not allow the input of decimal values anymore into an input field. The field is set up as Currency which worked perfectly before, but when I enter a decimal value and press the Submit button, I get the warning: "The number 2.5 is not allowed for this form. Only certain numbers are allowed for this field."
Formula field that calls a function that seeks records from another form does not seem to be working
Here is my scenario (simplified): I have a function - GetCount(string Name) that queries a certain form collection say Form2 and returns the count. I have another form From1 that has a formula field that calls the GetCount(Name) function. When I introduce this formula field, it calculates the count and correctly shows me in the View of Form1 at the begining and then all the values stay as-is even though the records in the Form2 have changed. If seems to be that the formula field in Form1 was just
Lookup Field error
hi please help me what is this error
what system field to use for manager's ID on every entry?
hi i have few managers with separate logins in zoho creator's app. i need mark every creator's database entry with ID of manager who add this entry. what system field i need to add to app's code so that this app will automatically add manager's ID to every entry?
hide/show fields in subform row based on input. how?
Hi, Say I have an invoice form and included a subform that should hold lines of payment details for cash/cheque/credit card. Based on a dropdown field "payment method" I would like to hide/show enable/disable certain fields. E.g. if "Cash" is selected then I would like to hide or disable all input fields relevant to CC or Cheques etc, Kindly advise, Regards, Idan
look up formula
I need to some how set a field so that when a store # (i.e 11193) is chosen from the drop down list, it's populates the district # ( i.e. 222) automatically in the proceeding field. I am not in any way good w/ formulas and need help pulling this info from an excel spreadsheet. and please don't tell me to refer to the help guide like the person on the phone did. :) Thanks!!! -Melissa
Next Page