Excel Query
I know that a form can be exported to Excel but can Excel directly query a ZC form?
zoho creator
hello I need to know how I can display "product name" when I select their "product code" in a formalaire know that I exrtaire code "Zoho CRM" to "zoho creator"
number format
Is it possible to change the numer format I am inputing times of min.sec.decimal such as 1.01.34 is this possible and how do I acheive it thanks Andrew
Drop downs autofill on subforms question
I have a script on a form called billing form that autofills information from a Form called Add Kids Form and Add Parents Form I understand this does not work on subforms because of some issues and I've read up on it, but I still don't understand how to implement it on a subform. Can you please help me rewrite the code below so it would work on a subform? And please tell me where to place the code. Thank you. the script is: if((input.Select_Child != null)) { rec = Add_Kids_Form[ID == input.Select_Child];
How to parse json string in Creator application?
In many case, zoho.crm functions just return json string, such as: 1, zoho.crm.searchRecordsByPDC 2, saleItems in following code, saleOrders = zoho.crm.getRecords("SalesOrders"); for each saleOrder in saleOrders { saleItems = saleOrder.get("product"); } How to parse json string in Creator?
Viewing multiple records associated with a single record in another form
How do I create a filtered view of records which are associated to a single record of another form? I want to be able to click on a record from a list and be taken to a view of multiple records that are 'linked' to the record I click on.
zoho.crm.getRecords("SalesOrders") bug?？
There are TWO sales orders in my crm, one has TRHREE items in product details and another has just ONE item in product details. I've following code : salesOrders = zoho.crm.getRecords("SalesOrders") ; for each salesOrder in salesOrders { info salesOrder; } I'm confused that why there are 3 records in salesOrders? It seems that there're 2 records for the sales order which only contains one item in product details: one is for the sales order itself, another is for product item in the sales order.
View photo while entering data
I'm trying to create a simple app that allows me to view a photo on one side of the screen and enter data from that photo into fields on the left side of the screen. However, the only thing I've been able to do so far is to see the photo next to uneditable fields. In order to enter data I have to click on the "edit" link which then covers the photo with an editing screen and prevents me from easily seeing the data in the photo. Anyone have some ideas on how I can do this? Any help would be greatly
Deletion of Fields
Hi, seems that the deletion of singel records does not work for me as well, as for some other users before me. I check the records, click delete and the loading logo spins forever. any hint? thanks, stefan
Creator Form Design
Hi I looking at creating some data entry forms which have quite a few fields which will take them over the page. To keep the formatting clear it would be ideal to mix some sub forms in too as well as using the column formatting. It appears from investigations that there is a limit of two columns to per form which I can work with but I'd like to know if there is any other formatting that can be used with columns. I can't find any further documentation. This formatting also doesn't play nicely with
Creator: Tables in forms
similar to https://help.zoho.com/portal/en/community/topic/question-in-table-form I want to be able to add values into a table for various categories over a period of time so we have something like this: 2008 2009 2010 2011 cat a <field> <field><field><field> cat b <field> <field><field><field> cat c <field> <field><field><field> Is this still not possible at all ? or can I have something like cat a 2008 <field> 2009 <field> 2010 <field> 2011<field>
Why cant I delete a record?
Why cant I delete a record from this form/view? https://creator.zoho.com/yaxche/control-de-operacion/#View:F1_Lista
html edit & record delete error
Dear team, 1>Free Flow script can not show now. Before it can show. 2>Script Builder for html dashboard can not show with IE/Mozilla/Firefox. 3>can not delete record.
Delete Records stuck at loading screen
Ok, Support team please get back to me asap. I cant not delete any record in my app. stuck at loading screen. I am on a Enterprise Plan, so please do not ignore this post. This is urgent as my users need to get back with their work. Thank you.
Ignore HTML when sorting
I have a database of numbers that link to specific pages. Three cells in such a column might read thusly: <a href="http://juiced.gs/index/v1/">1</a> <a href="http://juiced.gs/index/v10/">10</a> <a href="http://juiced.gs/index/v2/">2</a> Is there a way to tell Zoho to ignore the HTML and sort this information numerically?
Enabling editable fields
I have a table with a lot of columns, and I choose to fill out the data by constructing views with many of these columns filtered out. I would like to be able to be able to click "edit" and only have those fields that are visible on the view be editable in the form. Instead, to accomplish this, I have to change the "disabled" and "hidden" fields in the script. This becomes unmanageable quickly. Is there a way to have editable views with ONLY the fields that are visible on the view without having
E mail editing records
Is there a way of enabling my users to edit the information they've sent in earlier by email?` Say they send in a form containing among other things a company name which in my database will be unique, can I in some way let them use that to alter the rest of the record on the company through email on a later point using that company name? If not is there an easy way to merge the information of two records into one record?
Is it possible to create HTML Page View to print out certain CELLS within a ROW or Export it with XML?
Hi, I wonder if it is posible to create HTML Page View or Print/PDF button which allows to print only certain cells within a row OR Export certain XML data like XML Zoho RSS but only for a row NOT for the whole data list I have a special PDF form to print out a Visa to Kyrgyzstan http://www.kyrgyz-embassy.org.uk/print.pdf which imports special XML data sample XML is here <?xml version="1.0" encoding="UTF-8"?> <VisaForm> <!-- ****************************** name: JOHN surname: SMITH born: 1950-12-25
building a form that need to have lots of rule but has heavy restrictions given where it will be uploaded
hi, i want to use your form builder to create a form which i have been able to do on some free form building websites but i have some futher restrictions id like to place on my users before that submit... a bit of background.... im having trouble making a form with lots of rules in it. i have a html script that was written for me some years ago for my old website that consists of 3 vertical colums. this script can be emailed to you would like to see it or viewed (not working) at www.thepclub.weebly.com/moonee-ponds.html
Importing dates in forms
Hi, I am having some trouble importing date fields in Zoho forms. I set the application preference to MM/dd/yyyy. I have come to realized that Zoho cannot handle a date like 12/2/2011 or 1/31/2012, since it want exactly two digits for the month and date fields, such as 12/02/2011 or 01/31/2012. Unfortunately the application generating my source CSV data does not add zeros in front of single-digit months or date fields. Is there a workaround? Thanks
Code that once worked now does not
I have 3 nearly identical forms that contain look-up fields and sub forms. All were functioning properly and in use. and have stopped working as of today 2/2/2012. The forms contain a report type look-up field and a country look-up field which has On Update code to limit picklist values for Region, City etc. Both fields report type and Country pass their values to 3 subforms. As an example one of the sub forms is "Training Subjects" that were taught at the event. Upon adding a new record in the subform,
Is this a non starter?
I've just signed up the free package to evaluate the software. It won't let me set up any applications say that I've reached my limit, which is impossible as I haven't added anything yet! Any ideas where I'm going wrong?
Permission problem
I am trying to limit certain users to be able to edit data in certain applications but not in others and am running into problems. Suppose I have one main application (Personnel) and a related application (Projects). I want users to be able to edit the information in Personnel but not in Projects. Projects is private and not shared with anyone, and yet it seems that by creating a link in the Personnel form to Projects (Personnel can be connected to one or more Projects), it opens up the user to add
How to upload static image files and use them to decorate my html view pages
Hi there, I need many images files to decorate my html view pages. Can Creator provide spaces and management functions(such as upload, remove etc) for static files used by my application? Thanks, Roger
Can add a record, but get error msg when try to update it later.
Hi I can enter new student records, but as the title says I can't get into the record to modify it. Could you please advise. Thanks
Cannot add new records via API, if the form contains a subform
When I try to add a new record via XML RPC API to a form that contains a subform, then the API call returns success, but the new record doesn't show up. It doesn't matter whether I don't set the subform field (i.e. create a new main record without subform records), or whether create a subform record before and set the subform field of the added main record to the id of that subform record (i.e. create a main record with one subform record). Adding records manually works well. I can also add records
Error message with an embedded form
Additionally, I would like the information from the website form submitted to go directly into a particular view, but not sure how to make this happen. Can you help ? ------------------------------------------------------ Hi I've made and embedded a form in one of my webpages. I tested it and it came back with... " Error details: Error occured while executing on click script. " Can anyone tell me what it means exactly and how to put it right ? Struggling to see, having followed the set up instructions
Alert not working
This is not working since your update if (count(Customers[Address == input.Address]) > 0) { if (input.Input_Type = "From Job") { alert("This address is already in the database, click ok to go back to the job form"); rec = Customers [Address == input.Address]; input.Address = rec.Address; openUrl("#Form:Job?Lookup_Customer=" + input.Address, "same window"); } else { alert("This address is already in the database, click ok input another
postUrl not working
I always get internal exception from postUrl,can anybody help me?the script work well several days earlier. helloworld = map({ "Airway_Bill_Number" : input.Airway_Bill_Number }); result = postUrl("http://vytalhost.com/zoho/shipmentValidation.do?Declared_Value=" + input.Declared_Value, helloworld); I'm sorry,but I,m dying to solve this problem,please help me.
Report's Problem
Hi! My reports don't function. I see the message: An page's script cold be stop answer or in exec... Script: https://js.zohostatic.com/db/Jan_27_2012_1/compressed/ZDBGridView.js:1578 All my reports don't function since 26/01/12. I Can't create a new report too. Can you help?
Custom Actions - Select E-Mail Notification
Hello Zoho Community, How To Have A Custom Action in View That Sends E-Mail Notification Where You Can Pick The Column Range Like 1 - 50? Looking Forward To Your Help. Thank You.
ALERT MESSAGES "http://www.zoho.creator.com" and your message goes here "bla bla bla"
Enclosed are pictures of my desktop. You can see in Picture 1 regular ALERT MESSAGES where "http://www.zoho.creator.com" said something DOESNT appear. Also, you can see in Picture 2 in ZOHO ALERT MESSAGES, that claim: that "http://www.zoho.creator.com" said your message : " bla bla bla". This wasn't like that a few months ago. Zoho suppport and zoho sales will always reply: Yes great idea, we will consider this in further updates.
Urgent! I can't direct my survey results to our e-mail gruop
I've created a survey with creator, when candidates submit the survey i want to see the results on my hr mail group. How can i forward to my e-mail account. Previous admins of this account did that, but i can't do it. Can you help me please? Berna A. Kartaca
Lost all my Content
Help. Logged in a few days ago and all my database content is gone. Forms are still there but data is missing. Has it been compromised or is it a technical issue? In Canada. Lost important data. ------------------------------------------------------------------------------------------------------------------------
Displaying PDF files in a view
Hello, In my application the user can create a drawing and upload a .pdf file that has the technical data on it. Is there a way I can view or create a view that shows all the different drawings in a grid form, so the user can browse all the drawings easily and then select the drawing they need? I have seen a sample application using JPEG images but unfortunately I need something that works with PDF files. Many thanks Ben
No response from ZOHO Creator's Support Team to repeated email enquiries
Latha: 1) On Jan/16, I emailed you with a follow up question to (Yoge's long delayed) response to my original enquiry of Nov/23. 2) On Jan/24, I emailed you again ... asking for a response. 3) On Jan/30, I emailed you yet another reminder. There has been no response from you to any of the above emails ... why is that ? ... and when can I get a response to my enquiry that my client is waiting on ? As mentioned to you before, the client whose needs originated my original enquiry in November, already
When do these options become available? or never?
Hi, for one thing i dont understand why Zoho CMS not yet include 2 basic things: 1. Lock Record To lock a record, i now use the Lock ID form. but if a user clicks on Edit, and click cancel, the record is still there in Lock ID form, meaning the record is still locked. b/c there is no Action on Cancel. this work around only works with Action on Success. so a work around is to have custom schedule running to delete records every interval needed. now i have to come up with a bunch of lead time for bunch
Latha ：Urgent need of help..
ZC team: I have a business application needs: 4s in China's auto shop to read specific data in their databases, ZC have a way with their database docking? Have any suggestions or solutions? The means is ZC is there a way to get data from external databases? Thanks and waiting your reply Stanley Guo 2012-01-31
Similar script produces error
The application in question sends an email "on success" to the end user. Subsequent follow up emails are sent over the next few weeks using an "on load" script. I have been trying to add a script which continues to produce an "on load" error. This is the script just before the new lines I am attempting to add. It works fine, as do the scripts above it. (NOTE: I have removed the email content so that this post doesn't exceed character limit). else if ((lead.Added_Time.addDay(30) < zoho.currentdate)
Fetch data independent from capital and accent letter
Hi, anyone may suggest how I can use a capital and accent letter criteria when I fetch data to prevent duplicate in my database? Here the topic whit criteria suggested. Thanks Mic
Next Page