HOLD DATA IN A DROPDOWN MENU FROM FORM TO FORM
I have a dropdown menu that I want to hold data after submit button is hit. I want the dropdown menu to remain the same unless the value is manually changed. I cannot determine the script to accomplish this task. Thanks for your help. PZ
How do you specify two criteria in the "Set Criteria" portion of a lookup field?
How can I have my lookup field key off of both criteria I show below? It will work with a single entry, but no matter how I put the second one in, it removes the second option when I click the Done button.
Conditional X-Axis Dates in Reports
I have a report that tracks some activity on a monthly basis. Is there a way to adjust the x-axis of months to a custom range like July 2012 to July 2013? Or is there a way to only display months that have data?. Here's an example Cheers, John Whitney
Updating Related Record on Case (Case Add Comments)
I am trying to update a related record on cases. Specifically, I want to add a comment to the Add Comment area on the case. It seems like that field is in a solution record that is related to the case, and trying to pull the id out to update the Add Comment field on the associated Solution record. Any help much appreciated! if((input.ZC_Subject.contains("Case#: "))) { input.Case_ID=(input.ZC_Subject).subString(11,29); input.Case_Response=(input.ZC_Content).subString(0,(input.ZC_Content).indexOf("---------------------------"));
Link two forms filled one after the other by the client
Hello, in my application, I have a form called "contact" and another with "service order". The client will fill the form contact with his contact information and will be redirect to the next form (after clicking the submit button) to define which service he wants to order (let say between a transcription and a translation) and the related informations. A client (with information saved in the contact form) can later have many service orders. This is why I need two forms. Now, I need that the service
Create a Filter that works across divisions in an HTML view?
As an example, lets use students on a bus: The HTML view has a top division view of Bus records with fields: Bus_ID_Number, and Total_Count_Students_On_Bus. The bottom division has a view of Student records showing who was on a given Bus with fields: Bus_ ID_Number , and Student_Name. My goal is to enable users (public or Zoho) to filter the HTML view so that each division is filtered for the same Bus_Number and therefore presents in one concise view both a summary above and detail related to
Need in-row function to populate values in HTML view...
How can I make a function that will open an HTML view which recognizes the record of the row the function button is placed in and allows me to populate the HTML with values from that record?
Hidden fields in a form are being shown as subform.
Hi, I have put some fields as hidden fields for the rest of the users in a form. Then I am using that form as a sub-form in another one, but the hidden fields are shown. I know how to solve for my application, but that is a bug, it should work differently. Kind regards, Mari.
Example for a valid delug criteria
Hi, http://api.creator.zoho.com/REST-API-View-Records-in-View.html The Api above has a criteria field as post parameter. I'd like to see and example how can I use that. It says I should enter a valid delug criteria, but don't know how is the format of that. I can set it from GUI, though. To be more specific I'll give an example. I have a two forms, Accounts and Lists. A List belongs to an Account so the List have a lookup field in it for Accounts. I'd like to create the deluge criteria for Lists
Export file size / column amount / line amount
Hello together, short question - what will be maximal file size column amount line amount We have to export at least file size - greater than 6MB column amount - 160 line amount - 20.000 What export options are recommended and which are possible? Thanks!
How to disable action buttons while the scrit is running.
Since the application that I am developing should run several scrip before loading the next step after submission, the user could push the action button again although the script is still running. There is a way to disable the action button in the meanwhile? Kind regards; Mari
Fecth records in a subform depending on a field in the form
Hi, I am developing an order management application. We want to have all the product pre-loaded so the user doesn´t forget any item. For user experience reason, we want to show him the products of a specific category. I am pre-creating all the products in the subform, but I want to fetch the records to show just the information of a specific category choosen by the user. It is possible to do it. How could I do that? Thanks, Mari
Suggestion in how to implement a validation on a view
Hi Zoho creator guys, I want to implement a validation in a view that should be activate when the user start it. Basically I have a view of "orders to be processed" and I want to check another view with the "products unavailables", and let the user know about these products. What do you suggest to implement this feature? Thanks in advance, Mari.
Multi Customer Application
I want to create a single application for multiple customers. Each customer will have their own Zoho username, when they login they must only be able to see their data and add their data. However, me, as an administrator must be able to see all customers data and create and modify data on their behalf. Is there any general guidance and best practice for this?
What Can Zoho Do for you Today?
I have been spending some time working in Zoho and I must say that I am very grateful for a tool like this. It has all the features to allow my vision to become a reality without me having to depend on programmers. I have a good working knowledge of database and form communication and as I get deeper into my project there are a few questions that arise. I searched all over the forum but did not find answers. I was hoping that some of the community members might be able to answer my questions: 1.
Generate Turnover Graphics
Hi, I don't understand how i can create a Turnover graphic per month. (i've created a CRM) Have you got any solutions ? Thanks
How can I send an email from Form A that includes data from Form B?
I have a Zoho Creator application with multiple forms. I need to trigger an an email to send when a checkbox is checked on Form A that will send to the email address listed on Form A, but I need the rest of the email to pull in fields that exist on Form B. How can I do that?
Fetch selected record
I seem to remember using Form [ID==input.ID] in order to fetch the record selected in a view to be used within a function. Now I get an error message: "Variable ID is not declared". Please help me remember the correct way to fetch the selected record.
submit to local sql db
Is it currently possible to submit records from Zoho creator to a local SQL database? I am pushing records from a local sql database into creator, but i want to be able to push into A local sql database
Calculating distance between two points
Hi all, I have built a ridesharing app in Zoho Creator. The problem is, right now, users can't filter the rides by their 'from' location. For example, it would be ideal if I could search for rides that were within 5km of my home suburb. I have a vague idea of how I'd do it but I'm stuck on one point (step 3). My proposed solution 1. Get longitude and latitude (see here). 2. Get a list of the rides within 5km of the search point by converting this PHP script into Deluge script. 3. Filter my embedded
Call Centre to Add Records Only
HI I have a call centre taking details and want to send them a link to my Zoho form. The thing is I only want them to be able to enter new records - not to edit existing ones, and I'd like them to do his without having to log in (since it could be different members of staff entering these details.) How can I do this? T
Some Fields not clickable in a form
Hi I have a simple form with couple of single line, multi line and file upload fields. The single fields when I click using mouse I get the typing cursor. For multi-line field when I click on the upper part of the multiline field I get the typing cursor, but when I move the mouse to the lower half of the multiline filed, mouse cursor changes to arrow and when I click I don't get typing cursor. Also file upload control, I am unable to click on the upload button. I have enabled the form verification
Cryptic error msg
Does anyone know what this error message means? I have a function that does a for each through one table and matches to another table based on one field. If a match is found then some fields are updated. I don't know if this error is from a mismatch on some field data or I'm over some Zoho processing limit or something totally different. Execution Failed Error details: Error executing the workflow Combine_Master : Error. Error executing ITERATE_TASK task : Error executing IF rule : Error executing
Login page issue
I want to make a login page for my application ... can anyone plz help in this matter ... as i am not able to map userid and password after doing customer registration ..
Checkbox value limitation
I have built a form that dynamically displays checkboxes based on variables that have been previously entered into the system. I am using the contents of a multi-line field to appear as the value for the checkbox fields. This works well as long as the contents of the multi-line field remains fairly short. Unfortunately, most of the records that I want to use as values for the checkboxes are fairly long. (My application can generate 7-10 paragraphs on a form, each associated with a checkbox. Each
How could I run scripts related with the reset button
Thanks for all your support. I want to run a function when the user click on the reset button. How could configure that?
date filter options not sorted chronologically
I submitted this issue to support 10 days ago but have not had a reply so I am posting it here: When a date field filter is added to a view the filter drop-down list in the live mode does not display the monthly options in chronological order. For example: June 2011 July 2011 May 2011 etc
Email an HTML View
My client has a report generated using html and populated with values from a database. While we can export to a PDF and then email this report, a more elegant feature would be to click to email, and have Creator take on this task. Any ideas? By the way: A potential bug. When we click to make a PDF, the report's embedded logo goes missing! The logo is linked to a file upload url in the same app. Cheers, John Whitney ZOHO Creator Developer
HTML View - how do I add a report?
I am creating a simple dashboard in an HTML View and would like to display a Report. What is the best method?
Print single record
Hi, Some time ago you kindly added the print option to my 2 main views, a feature which was apparently at the time in beta. Since then I upgraded to the new look and the print option has gone (in an iframe). Is it possible to keep the new look but have the print option back? Adam Smith
Conditions in a HTML view
Hello, I'm trying to make Html view with conditions but it doesn't work. <%if (curProposition.Product_ipad1 != null){ <tr class="zc-viewrow zc-row-1"> <td align="left" czc-viewrow="" zc-row-1=""><%=curProposition.Product_ipad1%></td> </td><td align="left"><%=curProposition.Date_ipad1%></td> <td align="right">10</td> <td align="right">30</td>
Where do Bounced emails go?
I used Zoho Creator to send an email to an invalid email address. I have not received any notification that the email was undeliverable. I have looked at the inbox of the email on the Zoho account and the message inbox on my Zoho Creator home page. How do I get notified when an email is undeliverable? Herb Wexler
How to optimize deluge script to run faster
Hi, I have a form that is very complex and it require several fields interactions in order to accomplish all customer requirements. Currently the script is running well, but it is running very slow. Any suggestion on how to optimize it? Thanks in advance.
Suggestions in User Management
Hi, we are developing a solution that required user authetication in order to manage specific data and workflows according to user permission. I am using the user management available in Zoho Creator, nevertheless I want to provide more formal emails of registrarion for the application, where the message of the invitation to the application is more relevant in the welcome email sent by Zoho. Is there a way to customize that kind of emails?. Thanks in advance,
Send mail with "if" command in body copy
Hi, Is there a way to send mail with an "if" command in the body copy? I have two kinds of contact fields and I'd like the email to say: Hi <contact> But if the <contact> field is empty I'd like it to say: Hi <contact_NEW> How can I do that without ending up with Hi null <contact_NEW>? Thank you for any help! -silver
Iterate Values in Subform
In regard to post https://help.zoho.com/portal/en/community/topic/displaying-subform-records-in-html-view marked as Answered, I attempted to understand how to reiterate thru vales in a subform to display on an HTML view. The sample application has a number of strange issues that are easily diagnosed by attempting to edit the HTML view. Please explain how to do this rec = Main_form [ID == input.id.toLong()]; for each i in rec.SubForm_1 { //some code } Cheers, John Whitney ZOHO Creator Developer
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. Suppose say this application is used by many suers,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
How to show the application menus and messages in other language different than English
I am developing an application for a Spanish-speaker country. I want to customize the actions such as edit, export, etc to appears in Spanish instead of English. How can I configure that?. Thanks in advance.
Why is form text so big now?
Hello, One of the things I don't like about the new UI is that fields on forms use such large text (unless it's a notes field where I've adjusted the size). However, recently I noticed that even in the old UI the text is all really big. Under settings, there are only two choices "Medium" and "Big" and they're both too huge. Can we please revert to the previous, normal font sizing? Or at least give us better control over this? Space is already a premium on a two-column layout, and this new size and
Number Calculation
Hello - I have a calculation that I am trying to do and I am trying to figure the best way to write the formula. I have the following fields/information: Funding: I/O, Level 1 Staff to Consumer Ratio: 1:1, 2:1, 3:1 Est. Awake Hrs.: (number) Est. OSOC Hrs.: (number) Est. Weekly Revenue: (formula) The goal is to calculate the “Est. Weekly Revenue” based on the selections that the user makes. There are different rates for each “Funding Type”, each “Staff Ratio”, “Awake Hrs.”, and “OSOC
Next Page