Incorrect Record Summary displays for report
I have three reports that reference the same view. Two of the reports do not have a custom record summary template created for it. One report does. When I look at the report with the custom record summary, the radio button is selected correctly and this custom record summary will display ok if I just updated this report. The problem is that whenever I run any of the other two reports that do not have a custom record summary and then run the report with the custom record summary, the default record
Configuring add notes field after fetching data
Dear All, I have a form (Hotel Details) with a single Line field (Hotel Name). I also have a second form (Seasons) with an add notes field. I used the following <font color="#ff0000" size="5">Add your Note here ...</font> to change the size and the colour of the field. What I am doing is to fetch the value from the single Line field to the add notes field. I used openUrl(((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Seasons?plain11=" + input.Hotel_Name, "same window"); and it works fine.
Filter lookup and populate filed in a subform
Hi. I have created forms: 1st form: Roof Type - which has different types of roofs we service in one field 2nd form: Problem/Solution Roof Types - lookup based on the Roof Type form Problem - Field which is a common list of items we find based on Roof Type Solution - Field which has the solution for the selected problem. I have another form with the work order request. On this form it also has a lookup related to Roof Type. I created a subform for multiple records with a lookup for Roof Type. I added
hide names of hidden fields in form
hi just make number of fields in form as hidden for user. but when editing entry - user can see all list of all fields in form. and pick hidden field for changing. how can i hide for user name of fields that are hidden for him in form?
how to make backup scheduler?
hi how can i make scheduler which will be backup whole app every scheduled time?
Roles in scripts?
A couple of months ago I had this application dropped onto my lap when the previous admin moved on. They gave me access to the application, the URL and a hearty good luck. I have web development background so I have a basic understanding of the scripting and how most of it functions. In the scripts it refers to Roles, but I am unable to find where the roles are defined in the application. I have searched Google and the forums, found several articles like CRM Help - Creating Roles, it refers to clicking
Lookup field content does not display in a view
Hi I have one lookup field between two forms. When I select a view combining fields from both forms my lookup field appears in the report header but the contents of that field are empty. Do I need to link the two forms in some other way in addition to the lookup field? I have followed "Creating_a_relationship_using_single-select_lookup_field in the documentation." The form builder links the two forms and I can select the additional fields from the second form and enable them in "column view".
Update Multi-Select Field in another form based on input.Course field
i have a multiple select field under Students form with the available sessions for January. Field name is January In the Course form, I have a multi-select lookup field for the students. When I save the Course form, I want to update the multi-select field of the selected students to reflect the course name Course name in the Course form is the same as the options in the multi select field under students. Is this doable? Thanks!
Generate duplicate count in each record using formula
how to write formula to generate a duplicate count in each record, example: FormA Name Age Count(auto generated number of same age) Lily 16 3 Lucy 20 2 Kate 30 1 Bill 16 3 Jean 16 3 Carl 20 2
Report emailed is not same format as template
I have taken the time to make a report template of two columns and when I fill in all the information and click on submit it emails me a copy and when I get that copy the form is not the way I have it set up. It seems like once I hit submit it reads the from from top to bottom of the left column and then from top to bottom of the right column and emails it as such so my cells and the information is not side by side.. Example would how it should be is.... first name last name pax 1 name
XML RPC API Zoho CRM lookup field
I have a Zoho CRM lookup field in my form that looks up the customer's name from the CRM. When I attempt to import data using the XML RPC API, I receive the error "Failure, Invalid column value..." I have tried to use both the customer's name and the customer's ID from the CRM. How do I fix this problem?
Linking two tables in HTML View...
Hello everyone, I am working on an automated script to pull menu information from two different tables based off of criteria in only only one table. I will attempt to illustrate my problem below: We have two tables i need to draw from: Beer_Locator & AVLBeerManager. AVLBeerManager contains all of the information about specific beers (ABV, Description, etc.) Beer_Locator contains all information about where the beer is currently on tap (we are a chain of beer bars that has multiple locations with
Redirect to another page and set default value
Hello, I have a form called Employees with a field called Name (Single Field). I want when I click Submit then to redirect in another form (Details) which has a lookup field (connected with Name) called User name. I did it with the usage of openUrl urlStr = ((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Details?"; openUrl(urlStr, "same window"); My question is how can I set the value (which I will insert every time in the Name field) as default in the lookup field? I did this one but it
Contacts Sync with Google Apps
Dear Team: We have created a Contact Form in Zoho Creator. Can we set a sync in a way so that when a contact is added into Google Apps, it creates a contact in Zoho Creator as well. Please suggest. Thanks
submit via email problem
hi submit through email works fine if i send direct email to zoho app's email address on site i can install zoho app's email as first or as second recipient and when there are few emails in recipients - entry do not adds in app. why? zoho app's email is in recipients sender email is email of zoho app users
Write field contents to two tables
Hi there, I have a form named "Observation" which has in it a multi line field labelled "Issues". We enter items into this field separated by commas. When submitting this form I would like the contents of this "Issues" field to also be written to another table from a different form. I'm guessing I need some sort of on-submit script but don't know where to start. Is this feasible? Many thanks!
Report to show only users info
i created a pivot chart to track employee vacation time. showing vacation requests approved and total vacation accrued. My report is pulling all the vacation accrued from everyone. "vacation accrued" is a field in a form that is manually updated but is located in another form other than the leave request. Thanks for the help.
Creating a field selector based on the value of another field
I have fields A, B and C of which A is a drop down with possible values X or Y. I want both fields B and C to stay hidden when the form starts up. If A = X, then I want field B to show up and accept an entry. If A = Y then I want field C to show up and accept an entry. I tried this but it is not working.. For field B and C, I have "hide fieldB" and "hide fieldC" For Field A, I have if (input.fieldA == "X") { show fieldB; enable fieldB;
Import to Subform does not work with lookup fields
I am trying to import data to a main form with subform information. I have an excel spreasheet with 2 tabs. The first one with the form name with all the fields (form: Distris Elite y Premier) The last column is the subform ID field. On the second tab i have all the fields filled in with data (form: Contacto de la empresa) And a column called REC LINK ID with numbers that doesn't repeated. The idea is to add Accounts names and data to the main form and contacts names to the subform. The problem is
How to declare a variable in an HTML page?
I seem to have forgotten (or never knew) how to declare a variable as float or decimal. If I use the following statement: invoice_total = 0; and then go on to use this local variable as follows: invoice_total = invoice_total + (sales_invoice_item_record.Unit_Price * sales_invoice_item_record.Quantity); the app builder tells me the variable, 'invoice_total' is defined as BIGINT and incompatible with the other fields in the statement which are both defined as decimal in the form. I have looked for
User Id without the email.
Hi, I have one application that has a user with id without the email.com in it. e.g. "name1" Now I added another user but it is not able to log in without adding the whole email. e.g. It doesn't work with "name2" It asks for "name2@gmail.com" as the user id.
Paydates
I have a new form as Paydates. I also have a main form called Timesheets. In the Timesheets form is a field with a calendar. I am looking to try to get this field to show next pay date automatically based on a bi weekly pay schedule. ex: 01.01.2014 Next paydate 01.15.2014 Have it auto populate based on current date Maybe something like zohodate == input.paydate
Getting Full Page Data Added Successfully Message
One of my forms gets a full page "Data Added Successfully" message. The normal little pop-up message displays briefly and then my data form is replaced by a display that is nothing but the words "Data Added Successfully!". What is it and how do I stop it? My data form is a standard data form with nothing in the "go to URL".
How to show Calendar View depending on User Type
Hi All, Is it possible to filter the Calendar View via script? Users in the application I'm building belong to various company sites in different physical locations. I'm trying to find a way of displaying the Calendar View, filtered by the user's location, without the user manually selecting this filter. In addition, it is important that Site A cannot access Site B's calendar. Currently all the Tasks go into one Calendar View. I don't think it is an option to create additional Calendar Views for
Refer a Friend
Is this referral program still active?
Report Calculation
Hi, I have a report which shows data from two forms which are linked. Is it possible to do a calculation in the report? Example Form 1, Field = Quantity Form 2, Field = Length Report Fields 1- Form 1, Field = Quantity 2- Form 2, Field = Length 3- Form 1, Field = Quantity * Form 2, Field = Length Thanks for your help
Call function from other app
Hi, I have a simple function defined in order to debug why our functions do not work.. void Testfunction() { openUrl("http://www.url.com", "Same window"); } This is called in an app report as custom action and works well. In an other app we show the report in a page, but then the function does not work and just spins forever?
Formula
I am looking for a formula that would pull a field(s) based on a date range. Example: Show all software licenses (field) between x and y date range expiring in 30, 60, 90 days. Thanks
Embedding a pie or bar chart
Using the HTML View, how do you embed a chart next to a form or view on the same page. I only see that you can embed a "widget" or a "Form/View"
Api calls fail on listing views and listing formsandviews
Hello, I am trying to create custom views outside zoho and api calls gives a 500 (Internal server error) code when I try to consume the following apis: https://creator.zoho.com/api/<format>/<applicationName>/view/<viewName> https://creator.zoho.com/api/<format>/<applicationName>/formsandviews/ Raw response gives the text: An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Add,update api calls gives expected results. Trying to list the views in this
Question about creating a VBS registration form
I've created a form for parents to register their children for Vacation Bible School (VBS). Here's the problem - some have more than 1 child to register (some have 4 or 5) & I'd like for them to not have to fill out an entire new form for each child. A lot of the info will be the same for each child (parent name, address, phone #, etc.). If I just add extra spaces on the original form, then new fields (columns) are created in the database. I'd like them to be seperate entries in the database.
How to rehide a field when a user deselects a checkbox
Hi everyone, I mastered the show field for checkbox selection earlier today (thanks to Herb) using the contains function. But need to ensure that when a user deselects a checkbox, the data is cleared from the field and the field hides again. I have tried notContains later in the script, so the system checks if the checkbox is clear, but it causes errors. I have also tried isnull, but cannot get this work. Any help would be appreciated. Thanks very much
htmlpage syntax
Hi What is the syntax for htmlpage <view>() what parameters can be passed in the () ? I can't find anything on this in docs but from some of the sample applications I can see that parameters are used. Dave
Unable to fetch data from a specific view based on form
Dear Zoho Creator team, I request your help to regain normal functioning of STATS form and its associated views of application called GT. https://creator.zoho.com/f1ps3online/gt/#View:STATS_View Today I wanted to update the field called "Categoria" (picklist) and something did not work. All related views do not show any record since the code definition of the form STATS has been corrupted. I have given edit access to support. Thank you very much for your time and effort.
Checkbox 2-column/Single-column option lost on edit.
Steps to reproduce: 1. Create a form with a check box field. 2. Add several values (say 6). 3. Set the layout to 2-column display. 4. On user-input action, modify the list of values available (clear the list and then add new values). (Application: Imagine a Survey. A user has options "A", "B", "C", "None". If a user clicks on "None", I want the rest of the values to be removed from the list since ZC doesn't allow disabling of individual values). You'll notice that the 2-column layout option is lost
Client Database Subform Question
Hi! I'm very new and on the trial run for this program. So far, I like it very much, but I've run into a catch. I imagine that the solution is simple but I'm confused by the glut of options available. What I'm creating is a basic Client List for my tattoo shop which consists of a form (name, phone number, ect) and two sub forms. SubForm A is just a date and money amount to keep track of when each client comes in and what they spend. SubForm B is to record any cancellations and no-shows. The problem
404 Errors when trying to click on forum topics
Why am I getting errors when trying to click on forum topics? Is anyone else experiencing this? I submitted a ticket and haven't heard anything.
String to Number in Dropdown
I have a Dropdown R1, where the choices are 3, 3.5, 4, 5.5 I want to multiply the Price of an item by R1 as a percentage Have tried returning R1 as R1.toNumber() as toLong(input.R1) but receive error messages
How can I add a barcode number to each field, that will pull a specified feild when barcode is scanned?
I want to add a barcode to my records , so that when the barcode is scanned it will automatically pull up the corresponding record. Is this possible?
Editing Records from Reports don't link to base Form (since about 30 Minutes)
I've been working on a Creator application for the past couple of days and all of a sudden things don't work as they used to (since about 30 Minutes). Previously, when I clicked on the Edit button in the left-most column of a Report, the original base Form would appear with all the fields and all the validation logic, etc. Now what I'm getting is a dialog box with just the fields from the report. I have rexported the application and diff'ed it to an older copy, but I can't find any difference that
Next Page