Did "Access only through HTTPS connection" go away?
Did the option to "Access only through HTTPS connection" go away? If not, where can I find it?
Alert Function: Comma Invokes Two Windows
Alerts in both IE 8 and Chrome 16.x are showing as two pop-ups when the alert text contains a comma: alert "You have already entered hours for this activity on this date. If you need to edit the hours, please view your personal snaptime calendar and take the appropriate actions."; John M. Whitney
Email
I'm new to ZOHO and am looking for some help/assistance, for which I am happy to pay, if necessary We are using the product in its simplest format, a basic contact screen where are sales people call a prospect and from that there is an action required - the sending of one of say 5 different emails to the individual contact. How do I achieve this in ZOHO or is there someone out there who can help with the script. I need to be able to record within the record which email has been sent and the date
How to pass URL field value to Zoho Creator XML RPC API
How do I pass the value of an URL field to the Zoho Creator XML RPC API, e.g. to add a record? Regardless how I specify the URL, either as "naked" URL, as HTML link <a>, or as CDATA section, I'm always getting back an error "Failure, <field name>*Enter a URL value for <field name>" Thank in advance!
Problems reading tables with html form.
My client has created the tables and views that they need for their application. Everything works great, however I need to read the data in one (or any) of the tables. I went to this location: https://api.creator.zoho.com/CSV-RPC-API-View-Records.html and used that code. I got an API key and a ticket. created the query and got the response: Error Code , message 2832 ,[application owner] parameter is not available in the request I found a response from someone 2 years ago that said I need to add the
Cosmetic Bug on Execute Script for Lists
Please note that the execute script dialogue shows: when in actuality it should read "value1,value2,value3" (no spaces) John M. Whitney
How to create a todate field
I have a date field in my form. however, I would like to create a report based on the date field but convert to date field format from dd-mmm-yy to mm-yy. If anyone can help, it will be greatly appreciated
Record ID Link problem
Dear Sir / Madam I have passed below link thru mail to the user. I want user edit his record only. but when he clicks this URL the user id not capturing in the address bar, which resulted system showing "There is no such form in Zoho Creator" https://creator.zoho.com/hpclmittal/hmel-transport-tender-application/#Form:Transport_Tender_Application?/recLinkID=915357000000047453/&viewLinkName=Transport_Tender_Application_View Please help urgently and suggest if there is another code for this.
Ampersand and Aggregate Records Issue
Using Chrome or IE and the script editor, I have found that && statements in the aggregate record function get converted to "&&" as show below. John M. Whitney
Is it possible to create Personal Custom Templates for Forms and/or Applications?
I would like to know whether users may create personal custom templates of Forms and/or Applications? With Applications, while I am aware of the copy function, this only works within the specific application type, e.g. if I have created a Personal App, I may only copy it to create a new Personal App, and not a Workspace App. Any information is appreciated ~ thanks!
How to Format / Print Individual Record?
I've got a pretty simple database type app where the user input a type of order form. I need for the person fulfilling that order form to be able to print the completed form and format it so that the persons name is presented very large on the paper. How do I do this?
OpenUrl is no more executed in custom actions from the views which are embedded using div tag
OpenUrl is no more executed in custom actions from the views which are embedded using div tag. This is an issue in both views versions, the actual one in creator.zoho.com and the enhanced one. I've tested with the latest Chrome and Firefox versions. I hope that this will be quickly fixed. Regards, George
i need to make a form to be unavaileble for submit after a certain number of records
how to restrict( make unavailable to be completed by user) a form after 10 records have been completed, that mean only 10 user can submit the form .
Record ID
Dear Sir / Madam I have created a stateless form in which the applicant registered himself by entering data. As soon he submits the data a record will generate with ZOHO unique Record ID. I want to know how this Unique Record ID will directly communicate to the applicant thru his email id as soon as he registered himself. Thanks Shiv
how to make a field that is required to not to be necessary
I have a form with a radio button field that have two option , after that field i have two fileds with several option each on. What i want to do is : if the first option a the first field is selected then the first field after this field to appear and to be required, if the second option is selected then the next field to appear and to be required and the previous to dissapear and not to be required. If i put the both filed to be required from start, the form can not be completed because one of the
Help! How to import and link Zoho Form and Database to your website
Hi Guys, I'm new to Zoho, and need a little help here. I was thinking if there's any way if the form that i created (Built from Scratch) could be imported to my website, but the inputs to this form could still be viewed in Zoho database? If its possible, could anyone just teach me how, in simplified steps? Would appreciate any help, thanks!
Display null as " 0 "
Good day Zoho Gurus, I have this in an html filter: <%for each x in VAR_Staff { Person = x.Short_Name; HoursTotal_0_7 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '1W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours); HoursTotal_7_14 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '2W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
Setting up Logic for a Date based on today
Hi - I am hoping to use filters (although filters don't seem to accept manually written logic) or I can just set up a different view. But basically I need to set up a rule that says "If 'Date Emailed' is more than seven days ago from today, then show this record". I can't figure out the logical expression for this. Thanks for your help. Jon
Inconsistent behaviour of null values
ZC Team: it is a really good things that recently you made possible to update fields with null values. But I think that there is an inconsistency in handing null values 1. If I have for example a field, it is allowed to allow null values there Numeric_Field = 1; Numeric_Field = null; But if I have a numeric varialble, the following statements Numeric_Var = 1; Numeric_Var = null; will generate error: The template variable Numeric_Var is of type BIGINT. But you are trying to update it with an expression
How to create an invoice in CRM with multiple items ?
Hi, I'd like to create an invoice in CRM with multiple items. Here's my code. void CreerFactureZohoCRM(string NoFacture) { f = Facture1 [Numero_de_facture == input.NoFacture]; c = Commande [Num_ro_de_commande == f.Numero_de_commande]; itemsList = List:Map(); for each i in Axis_Lignes_Commandes [No_Facture == input.NoFacture] sort by Produit1 { itemsList.add({ "Product Name" : i.Produit1, "Quantity" : i.Quantite, "Unit Price" : i.Prix_selon_format, "List Price"
Set criteria for import picklist to limit choices by date
I need to set the criteria for the import picklist to limit my available choices to today or dates in the future. In the example below (episode), I succeeded in limiting the choices to dates equal to or greater than a specific date - January 1st. However, I could not limited the choices to dates equal to or greater than "today's date".
Generation of one Record Thru many Stateless Form
Dear Sir / Madam Could any body tell me how data input by a single user thru various stateless form (Which are the parts of a single Application) stored as a single record. Eg. If I input data thru a single large form, then only one record will be created. Please help.
Rich-text used in Subform
Hi, I need a rich-text field in a Subform. I can customize the toolbar of a normal rich-text field, but it's fully ignored when used in Subform (Toolbar is complete). Is there a way to fix this please ?
Change Default Date format on Excel Text Import
I used the "paste code" from Excel to get data into my Zoho database. However it defaults to DD-MM-YY. I manually change it, but sometimes I don't remember it. How can I make it so I don't have to worry about remembering? Thanks Jon
Creating a Pricing/Sales Form
How can I create a simple pricing form using drop down menus to generate a total once items are selected? I'm not looking to create a invoice form, but more like something a sales agent can use to generate totals for a product efficiently? Here is an example: Products: - Test A - Test B - Test C User selected "Test B" Quantity: - 1 - 2 - 3 User selected "3" Shipping Method: - Ground - Overnight User selected "ground"
Scheduler
I Have a 2 forms, one is parents and one is children. I want to have a automated email when a parent registration expires. I want it to take each of the children belonging to that parent and mention them in the email. How do I pull those records of all the children belonging to that parent? I've tried to use the fetch but can't get it to work?
Image / Logo in the Form
I tried to Insert "Logo / Image" thru Add Notes by I am unable to add. Could some explain me how i can load the logo or image in the form
One Record Thru multiple stateless form
Dear Sir / Madam Could any body tell me how data input by a single user thru various stateless form (Which are the parts of a single Application) stored as a single record. Eg. If I input data thru a single large form, then only one record will be created. Please help.
Options for actions besides "cancel submit" on validate?
I would like to add an extra step before my users save a form, asking them to confirm that the data they've entered matches our real-world data. For example, when they click submit, I would like a window to pop up with a yes/no question, at which point they can click "yes" or "no", which will save the form data - NOT cancel submit. I would then implement a script in the "on submit" action that saves different data based on their answer. I can think of workarounds within the form - decision boxes,
IE9 Security warning
I have a webview embedded on a website. It is working exactly as expected in Chrome and FF. Unfortunately, in IE9, it is prompting a security warning. It is also refusing to download all content without the user agreeing to download "unsecure" information. This is a huge issue! It is imperative that the use of Zoho is transparent to the user. If they get prompted about a security issue, a lot of users are likely to go away. How do I prevent this from happening? Please don't tell me to change my
Ticket Zoho Creator
Hi, Where I can found the value to Ticket? Is a same value that the SecretKey? Tks
Summary view show only 1 record on website
How do I get Creator to show only one summary record pasted and shown on my web page ( I can only get 10 per page at the moment) and for it to delete the previous data every time you put new data into the form. (So that it only shows the last record). is this possible?
Upload & Download a File
Dear Sir / Madam I am creating an application form in zoho creator, in which i would like to attached/upload a file which eventually applicants download and after filling required data again upload in the form. Please help me how i upload and download the file
Can't create Applications on Workspaces
I would like to report this problem, the strange thing is that with one workspace I can keep creating Apps, but not with some other, account admins said nothing is changed...
freeze panes
dear Zoho team, it could be very useful had the viewers been able to freeze panes in a view just like in an Excel file. thanks, peleg.i@playfect.com
views, hidden columns and Marketplace demo
Hi Forum, Recently I tried to upload an application that I developed to Marketplace. One of the problems I discovered is that views are not displayed as configured in my application originally. For example, many of my views have images displayed. In order to display an image properly in a view it is necessary to have both the field that contains the image name and location as well as the formula field that renders and displays the image. Of course I don't want the image name and location field
Selecting Last Entered Value as Lookup
Sorry if this is a basic question, I'm a noobie to Zoho. To simplify- I have a Form1 that has the fields, Date and Weight On My Mainform, I want to populate a "Current Weight" field with the last Weight that was entered on Form1 (Which should correspond to the record with the most recent Date,) How can I do this? I can have a dropdown box appear with Date and Weight displayed for the user to manually select the last one, but how to automatically populate the "Current Weight" field ? What is the
Enhancements to view actions.
I really don't like how view actions buttons are currently implemented. Here's the way I've been building them lately. and here's why! 1. They are located next to the other actions rather than Alllll they way to the right of a view.... The buttons become tedious to use when you have many columns in a view. Sometimes they remain completely off the page on the x axis so you have to scroll to the right. Let's get some Fitt's Law love and have you guys give us the option to move the actions to the
Help Please
I need a very simple function that I need to be added to my view and I can not find a way to do it. I have a column that has the 0 value in every field. I need a function that changes that value to 1 from 0. I am talking about the functions that you add at the right of the view table. The idea is that when you click the button that that function generates near the view's table to automaticly change 0 into 1 at the coresponding item.
Can I give edit/delete access to specific users only, not all users?
I would like to give edit/delete access in a view to specific users in my application. Lets say I have, two users A and B and the view 'Employee List'. I would like to give edit access to this view to user A only. Is this possible? If I go to 'Set Permissions' and select option to allow users to 'Edit Records', it does not let me specify which users should be granted this access and it is given to ALL users (A and B). Thanks for your help! Jose
Next Page