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 +
Google Maps
Hi there, I'm a new zoho user and I'm having some problems trying to work out how to get my address from zoho creator into google msps. My addresses are formatted like, field 1: house number; field 2: street; field 3: surburb I have looked through the forums and this looks like the way to do it, but where do I enter this code? do I have to create a new HTML view? if someone could please walk me through how to use the code, that would be much appreicated. ------------ The script uses the
zoho.calendar.createEvent: (a) need API; (b) these events do not appear in Zoho calendar
Hi, I'm a new Zoho Creator user, and am trying to create a Deluge script that will take a date record and a recurrence record, calculate the event repeats from start and end date, then fire off a zoho.calendar.createEvent() for each one. I have two problems: (a) I am unable to find the full API (full set of options) for that createEvent() function; (perhaps the API already supports recurrence, and I could use that). (b) The function runs and completes without error, but no appointment appears in
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"
How to import data from Zoho Reports
I am trying to import data into Zoho Creator from a table within Zoho Reports on a regular basis. Is this possible? Preferably automated, from the onload area of script. Additionally, it would be great if when loading a form, the zoho reports data actually updated a different creator form than the one loaded, but which had information accessed from the form via look-up fields. this thread asks the same question: https://help.zoho.com/portal/en/community/topic/importing-tables-from-zoho-reports-into-zoho-creator
Customized application with locale
Hello. I'm write from Spain. For every form that I make, i must traslate the button (Submit, Reset, Update, Cancel). I's possible to fix this values in spanish so as not to have to change at each. Also, in spanish Monday is the first day of the week. It's possible to fix this value for all the aplications? Regards
Best practices for working with dependent fields
Hello. I need work with 3 dependient lookup fields in a new aplication. Is goog using system field ID to link diferent fields. For example: I'have 3 form Areas, Groups and Subgroups. I have text fields with the names of Area, Group and Subgroup. When i insert a record in group i must select also the Area and when i insert in Subgroup i must select Area and Group. I want have dependient dropdown lookup field so that when i select a Area in Subgroups form, i only can select the group than belong
Import Photos
Hi, Can i import photos (from directory) to zoiho app? thanks in advance
How do I disable the More options in VIEWS?
Please I want to disable the IMPORT, EXPORT and PRINT options on VIEWS? How can I do that? Thank you for your help.
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
Dropdown Numeric Fields, Workaround?
After reviewing the user guide and a few searches, it seems that the dropdown field can only be defined as a string. I need to offer users a limited number of options, i.e. 1, 0.5, 0.25, 0.125 (even better choices in a dropdown menu would be 1, 1/2, 1/4, 1/8, etc. but creator doesn't seem to be able to separate labels and values in a dropdown) I need to also generate reports using these numbers such as adding up the values for the records. Are there any simple workarounds you've used to use numeric
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
Reusing fields/questions in different forms and applications
Hello, I wonder if anyone can help me out. I'd like to be able to reuse fields in different forms and/or applications. That is to say, if I have a First Name field in one form, I'd like to be able to use it in a different form, but still have it populate the same part of the base data. Does anyone know if this is possible? Thanks James
Performance
Things are incredibly slow this morning...record updates, screen refreshes, code saves. I can be pretty patient but this is extreme...just me or anybody else having this issue.
Max characters of multi line field?
What is the number of max characters of a multi line field? I have a form which is used to receive the email data. But if the email body is too long, it seems Creator cannot receive the email. I assume the word count exceeds the max characters of the multi-line field "ZC_Content". If this is the reason, how could we have the Creator application receive and process long emails? Could anyone help answer this question please? Thanks a lot!
Lookup Field In View at Wrong Position
I am just starting with Zoho. Bear with me. Also know that I chose Zoho to avoid scripting. After touring this forum, I have to wonder if that's really possible. Anyway, I placed a lookup field on one form relating it to another form/field. It is positioned precisely where I want it in the "Editor." In the form "View," however, it has moved to the end/bottom of the form. Why?
Margin Calculator Help
Hello Everyone, I come here in frustration and fully aware of my lack of adequate knowledge, hoping that someone out there can point me in the right direction. I'm toying with the project of creating a margin calculator app for our company that allows our reps to see our product costs and calculate what selling price would be based on what margin they wish to sell at. The catch is that I would like for the costs to be reflective of the value associated with them from a spreadsheet (Ex: widget A=
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
Cannot access restricted records once I set "Criteria" options?
How do I display restricted records set aside by conditions I set manually in the criteria options? I have an app which is kind of a production schedule. I basically need to hide a job once its completed which I managed to do with the "criteria" option. However, when I need to refer back to the completed jobs, I can't seem to access any of them. I have set it up to in the filter options but on clicking it there still shows me a blank page. Any suggestions? FYI:- The Completed jobs is part of a dropdown
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?
Set Criteria Based on Related Fields in Lookup Field
Hi, I am new to Zoho creator, and am hitting a wall with my know how, and was wondering if someone might be able to help me. I have a form called Graphics which has a LOOKUP FIELD called Scene in a Form also called Scene. In the view called 'Graphics_Worklist_Shooting_Order" that I show this lookup field, I have it display a RELATED field, called DATE from the Form Scene. What I am trying to do is set a criteria on Graphics_Worklist_Shooting_Order where I only show dates from today into the future.
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.
Formula Add/Edit item disappears on the context menu
Hi, I have already share a report within the group and selected appropriate user to act as a Developer on helps on editing the report. But they can't see the full functional context menu. What was going wrong? I have missed something for that purpose? What should I do? Best wish with thanks, NetTim
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?
Self registration of public customers so they can log on and view their account
Trying to do the following :- 1. Allow customers to make a purchase and give them an option to enter their email and preferred password so they can register 2. Send confirmation of their username and password via email 3. Enable them to log-in in future using their username and password 4. Pre-populate their address information etc based on login 5. If they cant remember their password provided a link send an email reminder of it (or a reset link) This is standard on a whole
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
How do I round figures in reports?
Hi, I have tried rounding figures in reports using the round function but I get an error..see below What am I doing wrong? Thanks, Jerry
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....
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
Searchable Bibliography
Has anyone used Zoho to create a searchable bibliography? We are looking at creating one with approx. 1000 items including articles, books, book chapters, whitepapers, etc. Searchable criteria examples: author, key title words, topic, year, etc.
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
Any way to get the "view record" popup window on a long view to pop up to the top of the form instead of the middle
I am very unskilled when it comes to using any kind of program language so I mostly use ZoHo as simply as possible. The one problem I have that is real annoying is that when I create a veiw that has a lot of data in it so it becomes very long and embed it in my website the popup window when you mouse over "view record" appeares half way down the view so anyone looking at the website would not even know it was there. How can I fix this? Thanks. Yehoshua
Suggestion: Add Import DS to Create Screen
Working with clients, I had an issue explaining how to import a .ds file. They were looking for an import button on this page: https://creator.zoho.com/create While the link is only available in the help section here: https://help.creator.zoho.com/By-writing-Deluge-Script.html I'm suggesting that you add a new button to the https://creator.zoho.com/create for importing a .ds file locally stored on the user's PC. Cheers, John Whitney
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?
Creating a rich text report or email with fetch data
Hi. I have 2 forms. 1 is a job input form and another a job update form. I want to create a report or email with information from both of these forms. The report will have a specific record data. This data will be fetched by an ID number. Any ideas on how to accomplish this. Ideal would be if I can have a schedualed email that goes out with data as the job update form is updated with the name of whom needs to get this email. thanks
Next Page