submit through other email
hi there is some description how to add entry to creator's app via zoho form https://www.zoho.com/creator/help/forms/email-data.html#Adding_form_data_via_e-mail_in_user-defined_format is it possible submit through email from other forms? i need submit next entries: 1) entry of incoming/missing call (online phone system sends me this email with phone number). 2) entry for consultation (from text form via my site) 3) entry for order (from text&file form via my site) can i add entries via REFORMATTING
Birthdate field format
I have a birthdate defined as a date field. People want to type in the date because the calendar icon takes too long to go back decades. The date format for the application is [E,MMM dd,yyyy] because in other parts of teh application showing the day of the week and month are very useful. No matter how much I instruct the users they want to type the date in as mm-dd-yyyy. The problem is that it seems to take 01-02-1980 as Feb 2, 1980. Is Zoho planning on having date formats that are specific to a
Grid views for mobile?
Hi, my client wants to build a mobile friendly attendance tracker app for his soccer club. His vision is for his coaches to be able to access the attendance tracker on their iPhones. I've been playing around with this and have created a basic attendance tracker with the bare minimum of required info. Grid view seemed like the most sensible way to display the tracker because coaches will have 5-10 students per class and this would allow them to quickly tick people off. However, when I try to access
Statements and Invoice
Can anyone advise if they have produced statements and invoices from a Creator application. I am wanting a reasonably formatted document with company logo etc. Please advise. Thanks. Kind Regards, Russell.
Lookup fields Not Sorting
Create two Forms, FORM_A and FORM_B If you create a lookup field (in FORM_B), and within the definition of that lookup, you enable : Display Type = Dropdown Show a link to add new entries in FORM_A and also select : Show choices in alphabetical order When you then use FORM_B, and use the link on the field, to generate a new record in FORM_A, once saved, that entry does not get sorted in alphabetical order in the drop down list. Only by exiting the form and re-selecting the form, does the correct
alert text is double spaced
I'm using an alert box to show several lines of text. The text shows as double spaced. I made sure there are no hidden line breaks or paragraph markers. Is this a function of the browser? I've only tried this in Firefox. Is there a better way to conditionally display a text paragraph? Thanks Herb Wexler
find null values with searchRecords
I wanna find null values and then update it with a new value in my accounts from zoho CRM with this function in zoho creator: zoho.crm.searchRecords("Accounts" "(Field Name|is|null)"), but this don't work i try with is EMPTY too, can i find null values with this function (searchRecords)??
How To Pass ID From One Form To Another Form With Out Using The Querystring Functionality?
Hi, I am using a single "Stateful Form" and "Three Stateless Forms". I am passing the ID Created in the Stateful form to other stateless forms. So that i use the ID passed using query string to stateless forms for updating data to the record in the stateful form. The problem is as the ID is passed as query string, it is stored in browser history. So when anyone logs in they can view the records using those url's since i have written some logic to retrieve data "On Load" based on some things.This
Subform actions
Subform and Form actions options are not in sync. I have a subform and have copied the logic from the Form Comments to the Comment subform. The only logic I can't replicate is the "On Add On Success" and "On Edit On Success". Is there a way for subforms to inherit the Form code so there isn't double entry of code? Or alternately, can you add on add success and edit success actions for subforms to make it consistent with the forms?
Error fetching data from another app
i keep getting this error "Error modifying the page Encountered "[" at line 84" while trying to fetch data from another form. here's the code - input.currency_from_app = app6.form1[Currency==input.Currency].Value; i can't use a lookup field because it requires the user to choose an option (it will be only one option, but still the user will need to mark it). i also tried this code- if (input.Currency=="Euro") { input.currency_from_app = app6.form1[Currency=="Euro"].Value; } but still - the same
openURL is not passing parameter on mobile
I am trying pass an ID from a stateless form which doesn't work when on a mobile. The URL gets altered in a new way. The mobile URL becomes APPNAME/form-mobile/Login#Form:Weekly_Form?ParticipantID=1005& instead of APPNAME/#Form:Weekly_Form?ParticipantID=1005& Relevant script of the Login form: validParticipant = AddParticipants [Participant == input.Participant]; Linkstring_Weekly = "#Form:Weekly_Form?ParticipantID=" + validParticipant.ParticipantID +
XML responseText missing opening tags and other data
for some reason when I get data back from a particular web service, it is missing opening xml tags and a bunch of other XML data. I have removed sensitive data and only included a portion of the response body but you should get the idea. here is what I get in responseText: "Ok<\/resultCode>I00001<\/code>Successful.<\/text><\/message><\/messages>..." here is what I should get: <getTransactionDetailsResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
Create Status for Form Submission
On App form is it zoho best practice to create hidden field and attach a status record on submission? I'm coming from Salesforce, where it was standard to submit the record and on submission new record rule would trigger a status creation to the submitted record. Saw a few things in the help docs, but just wanted to know what most do here. Thanks, Dustin
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?
Next Page