Print HTML View - Suppress Header & Footer
Is there any way to either suppress the headers/footers when printing an HTML view or to set a text value to be printed?
Application Ownership
I have added an administrator to my account who created a new application. While my current account states I have 10 user capability the application the new administrator created says it can only share 3 users on a free account. Since he is an administrator on my account shouldn't it be possible to share with all users? Thanks Bilmathis
Subforms on views attached to scheduled emails shows record ID
I have a form with a subform which shows correctly in a view. However when the view is attached to an email as a PDF in the schedule system the column only displays the subform record ID. Herb Wexler
crm.create doesn't seem to be working for me
Hello, thank you for your help in advance I am trying to do a simple zoho.crm.create("potentials",map) I have placed the script under the submit onclick button, but when I look in the crm I do not see the new potential added. Any help would be greatly appreciated (I also have it so you can edit the application already) it is under test/add_potential this is how the script looks NewOpp={ "Description" : input.Plombier, "Nom de l’Opportunité" : "Test!", "Nom du Compte"
Column Widths
Hi, In trying to adjust column widths I'm not seeing any significant decrease in size. I need this app to be as straightforward as possible as I have users logging in that are not very computer literate. Having to scroll through multiple pages of data is going to be problematic. Any help would be appreciated! I'll make my application accessible to Zoho staff. Thanks, Diana
I have two identical (lookup) (checkbox) lists. I need them to have the oppsite selected
Okay, I have 2 fields. Each field is a lookup field that looks up the exact same data in another form. I have them set to checkbox fields. What I need is for them to be opposites as far as what they have selected. Say for example I have them lookup the following data: (A, B, C, D) So the form will look like this (the "X" will represent a checked box and a "O" will represent an unchecked box) FIELD 1 X - A O - B X - C O - D FIELD 2 O - A X - B O - C X - D I'd like it so that whenever you check or
Limitation With Multiple Calls to Function?
I have an HTML view that creates a table with 15 x 10 cells. Most of these cells contain a number that is called from a function. If I include this function-call (line 20), the view fails to load. If I remove it, it works. If I call it just form one cell, it returns a number. htmlpage SUBSTATS() <%{ TABLE = "<table width='400' border='1' cellpadding='1' cellspacing='1'><tbody><tr><td>Mailing List</td><td>Total Subscribers</td>"; for each sec_list in LISTS [LIST_TYPE = "Secondary"] {
using payment form
when submit is clicked and it goes to payment, if the payment is not completed, the form still creates a new record. i don't want it to create a new record unless the payment is successfully completed. can this be done?
Subform edits not persisted
After updating a form in which subform data is changed, we receive the "Data Successfully Updated" message, but sadly, the subform data remains unchanged.
On Add --> Validate : Script Action Fail
What I am trying to do is have an alert box pop up if a field value is null, but I only want this to happen once on validate and if the user decides this null field is ok then the user can submit again without having an alert box pop up. Currently I am trying: if ((input.Radio_1 = null) && (input.hiddenvalue != "nullcheck")) { input.hiddenvalue = "nullcheck"; alert "You have not completed the form are you sure you want to submit? To submit click ok then click submit again."; cancel submit;
Trying to autofill potential using the creator
Hello and thanks in advance for the help, I am new to Zoho but know how to program. I am building a form that uses labels to find 1.a contact (using Zoho CRM label) 2. an item serial number(using the database lookup) 3. and then creating a simple activation code for a product(using a function that returns answer in a label. Now I want to have the user to create a new potential (that will be set up with a Zoho CRM label) but on creation it autofills the values that have already been input (the contact
Again, what script will the new Drag & Drop calendar date change feature call?
I'm desperately trying to negate the effects of the drag and drop feature because it does not allow me to control the manner in which users change record dates. I haven't been able to get any script to call upon a drag and drop[UPDATE: the problem was on my end...I was testing older dates that didn't have my control field value loaded.] If someone would please post here an example of calling script with the drag and drop I would greatly appreciate it.
joining two forms
If I have a form of orders that includes zip code and a form of userid/zipcode (they can service more than 1 zip code) how do I create a view that shows each userid only the orders that match a zipcode in their userid/zipcode list?
Issue with duplicate entry
Hi, I have a form that asked user choosing an id channel (a device), a timestamp and a value. I would like my application does not record the value for duplicate timestamp but only if the id channel is the same. If id channel is different, I would like my application records value even timestamp is the same. In attachments, the 1.png shows the different id channel. the 2.png shows the first record I made for id channel Z0 the 3.png shows the issue I met : The id channel is different but as the timestamp
Help Writing a Script
Hi All - I have a form that I need script form and I can't get it to work. I have a series of five check boxes with the responses ranging from 1 to 5 and want to add those responses together in another field when the user enters a response. For example, if the user enters the response of "5" for each check box, I want the total of each check box to show as "25" in another field. How do I write script for that? Thanks.
Lookup fields and report
Hi, I am developing an application with lookup fields and I would like to make reports with filters from anther form. https://creator.zoho.com/kevin.loussouarn/consoadapt/# I allow access to support. In form Production -> Usine de Reims, the user select the id channel thanks to a lookup field related to Standardization form. Each id channel have a zone area and a consumption type: Z0 total A1 - South Wing - Air conditioning A2 - South Wing - Lighting B1 - Amphi A - Lighting .... Now, in report, I
Dynamic picklist in Stateless form
Hi, I use a stateless to add or edit existing records in a master form. In this stateless form, some fields have dynamic criteria (fieldB == input.fieldA). My problem is when I need to fetch records from Master Form. I open StatelessForm with : #Form:myStateless?myID=1234 Script in StatelessForm > OnLoad : myData = MasterForm [ID == input.myID]; input.fieldA = myData.Country; input.fieldB = myData.Town; As fieldB has a dynamic criteria, the value stays on "-Select-" instead of MyData.Town. Is it
Calculate Based on Field Entry
Hi, I have a formula I am working on to calculate a weight/score for a particular entry. Basically the part that is giving me trouble is that if there is an entry in the "Program_Manager_2 field, i need it to divide the weight/score by 2 and then multiply by .8, if there is NO entry in Program_Manager_2 then I just need it to multiply by .8... This is the formula i have been working on (I have highlighted the parts that I think are wrong): if((Program_Manager_2 != ""),(Staff_Requirement
Bulk import in Grid view.
hi, Can i have a use of bulk import functionality using Grid View. Please help me out, im not able to get it. Thanks in advance.
how use together zoho creator and zoho calendar?
Hi i use for order entries a date field (date of order performing). how can i unite together creator application with zoho calendar? for viewing calendar view of orders thanx
Employee management System
hey, There was an application called Employee Management systems. I am not able to find in the Market, can any one help me out. thanks in advance.
color text as a return value of an IF function?
Hi, Is it possible to have color text as a return value of an IF function? for example, i set up a priority level. "RUSH" should be red. makes sense thanks
upload data and radio button
I have a form with several text fields and a radio button. The radio button has two choices (Open & Closed) with a default of Open. I upload data from a spreadsheet for the text fields but dont have a column for the radio button. After uploading the data the view shows all the data accurately except the radio buttons field is blank. When I edit a record the radio button is marked Open as I would expect. Is there a way to force the radio button to use the default value specified on the form? The spreadsheet
Email Submission when email addressed to multiple users - no longer working
I have a form that allows email submission (Public). An email is sent to this form and the database is populated with the data. This has been working for about 2 years without fail. The email that comes in address to TWO email addresses. Suddenly on June 1, this stopped working. Was there a change to the email submission to not allow the system to process it if it has multiple recipient email addresses. I know that I used to have to ensure that the Zoho email address was the first address in
Creating subform entries for an existing form
I am trying to implement a comments system for the Bug Tracker template. The comments are implemented as a subform on the main form. This works fine from the Zoho UI. The next step is to integrate this into our existing customer support portal using the XML API. I have managed to create new Requests using the API, including with an initial comment, but I can not add new comments to an existing Request. I can not in fact even update a single field on the Form, even though I'm the application owner
List of Creator objects
Is there a way to programmatically capture a list of names of the objects in my creator database?
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
One of my views is missing and replaced with: [ServletException in:/jsp/edit/view/viewedit.jsp] null' App https://creator.zoho.com/buzzap/ncsd/ shared to support Thanks, John Whitney
Generating email / view based on relationship between forms
I have two forms, the first contains customer information (customer ID, name, email, etc) and the second contains store information (store ID, address, email, etc). Each customer needs to be associated with a particular store. Both forms share the field 'store ID' for this purpose. I am trying to develop a way for a store owner to receive an email each time that store gets a new customer. So in other words a script should check at a regular interval (say once a day) the relationship between the
Problem displaying an image from a form in html view
I'm new to Zoho, new to deluge, and new to html...but muddling through. I'm playing around with a form ("Master Database Configuration") that contains several fields. The relevant fields are "Parameter_Name" (string field) and "Value_Image" (image field). In an html view, I am trying to display the image that matches the record that contains Parameter_Name = "Logo1". I've attached a snippet of code below. Near the end of the code, you can see where I'm specifically referencing the filename in the
Conditional field problem with Excel import
Hi Everyone, I have got a problem developing my application... In a form I have a first field to fill in : "ID appareil de mesure". If the value filled in is 0, some others fields take automatic values (Script in the first screen shot) : Bâtiments/Pièces, Surface en m2, Nombre d'employés, Données mesurées (In french, sorry but whatever) It works properly when I fill in the form manually but when I want to import data from excel, fields with automatic value remain empty (Second screen shot)... Is
Multiplication Problem??
Hello, I am working on a formula that is giving me trouble. I have been successful until I ask it to multiply based on a condition (highlighted)... any ideas?? (Staff_Requirement / 2 + if((Living_Situation == "Community"),1,0) + if((Intensive_Family_Involvement == "Yes"),2,0) + if((Split_Shifts == "Yes"),2,0) + if((Payee == "Yes"),1,0) + if((BSP == "Yes"),1,0) + if((Monthly_Medical == "2 or Less"),1,0) + if((Monthly_Medical == "3 to 4"),2,0) + if((Monthly_Medical
Help
I am new to Zoho Creator and I am having problems learning the scripting, is there any help with actually building the database.
Callback URL for Clickatell SMS API - Please Help
Zoho Staff/Developers, I have a few questions regarding the Clickatell SMS API the Zoho Blog were pushing a few years back. I have a two-way HTTP API set up (not the SMTP API as was detailed in that post, which doesn't allow for two-way as far as I know) with them and am I little disappointed at the ultra-lame incoming SMS reports that they have as the basic option and would like the SMS responses to be delivered into a form in Zoho Creator. I'll start with a few screenshots detailing where I'm
Passing a set of values to a Parameter E.g. #View:SomeView?ParamID IN {1, 2, 3, 4}
In my application, I need to show a view of records which are determined at run time i.e. my logic identifies a variable number of records (code in an HTML View) and I need to display an embedded list view where I want to be able say that ParamID can have any one values from a set i.e. {1, 2, 3, 4} as an example. I have gone through https://help.creator.zoho.com/Functionality-based-URLs.html and I am unable to find any set operator like "IN" when passing parameter values. The functionality that
Exception reports for Zoho Creator
I'd like to receive a daily exceptions report for Zoho Creator. For example, I have a custom schedule executing every a few times a day. Once the monthly quota was exceeded, and only a few days later did I discover that the schedule had been stopped because the monthly quota had been exceeded. So I had to pay extra to upgrade the # of schedule executions per month, to fix the problem. I would like timely notifications by email of such incidences.
Change column/label width into Zoho Creator
Hi everyone, I attach a screen shot that explains clearly what I want. I want to resize the column of form's label into Zoho Creator. I looked for how to do but I found nothing. How is it possible ? Thanks ! Regards,
Can a field auto populate in a secondary form from a primary form?
I have form1 (aka: proposals) which collects... project number customer name sales rep & more... form2 (aka: orders) needs to have some of the same fields auto-populate when an existing project number is selected from a look-up... customer name sales rep IN SHORT: What script or how else can a field auto-populate the 'customer name field' of form2 with the existing data in the 'customer name field' of form1? Nathan
Field Change Question
HI need some help! I have a field (Category) that is a drop down box with category names. (Kitchen, Bedroom, Garage, Garden) I have a hidden number field (Category_Code) which has category codes (001, 002, 003, 004) I would like the hidden field to be updated with the correct code based on the choice selected in the drop down category name box. So choose bedroom and category code will = 002 Can this be done with script? Martin
If statement in Loop (in my HTML view)
Hello, Can someone help me with the following code, it is inside my HTML view - there is a lot of code so I will just post the code I think is causing the problem. I am just getting the error "null" when I press Save Script. <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1"> <thead> <tr> <th scope="col"><span style="color:#a9a9a9;font-size:8px;"><b>ITEM</b></th> <th scope="col"><span style="color:#a9a9a9;font-size:8px;"><b>DRAWING NO.</b></th>
find address of webpage for embedded form
I have one form that will be embedded in two different websites. The functionality of teh form changes slightly depending on which website it starts from. Is there a way to detect information on the starting page such as the url? Thanks Herb Wexler
Next Page