Subform help
Hi, How do I make the sub form I use span across both creator columns Thanks
HELP please URGENT
Hi, I have changed some code in my application and it now wont work, I can not figure out what I have done wrong. I need some urgent help as i can not print out invoices and my shop is open. The URL is https://creator.zoho.com/mrcomputer/mrcomputer-biz/#Form:Print_Control If you can help PLEASE. I would be grateful Nigel
Quotes updates in CRM
Hi, I want to update a quote in CRM from my Zoho Creator. I use that code : updated_itemsList = List:Map(); sl_no = 1; for each sales_prodsList in Synchronized_Sales_Products [(Quote_ID_of_CRM == cur_Quote_ID_of_crm && Use_for_Insert == false)] { updated_itemsList.add({ "no" : sl_no, "Product Id" : sales_prodsList.Product_Id_of_CRM, "Product Name" : sales_prodsList.Product_Name, "Quantity" : sales_prodsList.Quantity, "List Price" : sales_prodsList.List_Price, "Discount" : sales_prodsList.Discount
Help with carrying variables over to another form.
Hi, Can you help with a task please, let me explain. Form 'a' has a field called customer_name which is a text field Form 'b' has a field called customer_to_print which is an import data field which is taken from the records of form 'a' Customer_name. What I want to do is very simple. when I finish inputting a new name in form 'a', the form takes me straight to form 'b' and I want form b's field Customer_to_print to default to the record i had just input into the field in form 'a' without having
How to give an application to another Zoho Creator user to use it?
Hi I developed a small app. in Zoho Creator. I want to give this app. to another user (on a free plan) to use it under his full control. He may do changes to data and code. I don't want to control the application. What do I do? Thanks. EK
Form Field Criteria
Hi guys, Could you help with this on please. I want to set 2 criteria in an import data field 1. Collection_Date is Null 2. Collection_Date == zoho.currentdate They both work fine on their own but I cant get them to work together. What I am trying to achieve is the argument, if no date is in the field or if todays date is in the field then display name. Cheers Nigel
Custom Printing (Such as Checks) ?
I have an application which I wrote many years ago. I am new to ZOHO but so far what I have seen I think is possible to reporduce with my old program with Create. In my program I have an 8/12" X 11 (perferated into three equal parts) receipt. In my old program I print a three part receipt (All three sections print the same thing). I also print checks. Is it possible to create a report that would allow for custom placement of fields so it could print such a receipt or checks ? Thank you for your
Help with views please
Could you point me in the right direction please I have a form with a dropdown field that has 18 choices In the view for that form I want to set the criteria based on that dropdown form do I need to create 18 seperate views with the criteria set on each view or can I create one view and select the criteria each time before the view appears?
After lookup display url link
I have a customer form and a preferred vendor table. The customer chooses a preferred vendor and I display the vendors address and phone number in text fields on the customer form. Works perfectly! I want to also show the vendors website address which is stored in the preferred vendor table. I tried using a url field on the customers form but nothing was populated. I then tried a string field which worked but the address starts with <a href= " and ends with target = "_blank">Link Name</a> This is
Help with HTML view print
Hi Could you please tell me what is wrong with this code, I don't want to view the HTML view, just print it. openUrl((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Proof_Of_Ownership/same=") + input.thisone, "new window"); Thanks Nigel
Is possible a partial submit?
I'm working in Zoho survey for the first time. I want to allow user to submit data to some question and come back later to complete their survey? Is that possible? Thanks
How can any user send an e-mail with changes in a field, when the field is modified
I wrote the following script to send an e-mail with the changes made in a field (Product) when this field is modified. So far is working fine, however only when the admin makes the changes to the field the e-mail is successfully sent. When another user tries to make a change in the field "Product", the e-mail is not sent. Any solutions? ON EDIT > VALIDATE changed_values = map(); if (input.Product != old.Product) { changed_values.put("New Product", input.Product); changed_values.put("Old
In list view, need to display "New!" for records added in past 3 months
Hello, I have a database that displays worldwide group listings. I need to display text or a small image designating new records added in the past 3 months. How do I do this, or can I? Thanks
Form question
Can I create 1 form that does different things based on what radio button is chosen. for example If I create 4 HTML views that each do a slightly different task say 1 Proof of ownership 2 Invoice 3 Technical Sheet 3 Sales Sheet If I select radio button 1 it will print my proof of ownership HTML view If I select radio button 2 it will print my invoice HTML form and so on. Logic tells me it can be done but I am lost as to what code to use and how. currently to print the proof of ownership HTML view
email checkboxes not checked
I have a checkbox field with 10 choices. I want to send an email showing which items were NOT checked. Alternatively I would like show all 10 items in the email with a checkmark next to the items that the user checked. Any suggestions on how to do this? Herb Wexler
Mail Merge
Is there a way to mail merge to a MS Word or Zoho Writer document from Zoho Creator? I saw you have this capability in CRM but is it also in Creator?
Relationship
Hi, Can I create a relationship without using lookup Thanks
HELP with HTML View on web site
Hi, I wonder if anyone can help please, I have 3 files "Jobs" "Job Progress Enquiry" "Job progress HTML view" I have enabled the support access on my zoho site If you look at app mrcomputer-biz and look at the form Job Progress Enquiry you will see it works perfectly. However, I dont want my customers to have access to Zoho so I put the code on http://jobprogress.mrcomputer.biz but when you fill in the field on the web site it does not work. On zoho I use the code openUrl("#View:Job_Progress?same="
Allow Zoho IP
In order for the zoho app have access to our internal database what zoho IP should we allow? IT wants to know the ip address and if it is static
Best way for user to change information
I have a registration form embedded in my website. What is the best way for the user to change or add information after the form is submitted? I have written script that runs after they enter their email address which checks to see if there is an existing record with a matching email. If found it copies the data from the existing record to the input fields. This works fine except for file upload fields, URL fields and of course the new subforms data. Herb Wexler
Application publishing problem in marketplace
Hi, I want to publish my application created on Zoho Creator in Zoho Marketplace, but during the publishing the following error showed: Error in statement at line number 3047 api functions can be created only by application owners. Can any one help me why its happen.
Linking Database Entries
I am making an application that will help me manage information on contacts (ie people that I meet) for a project. In the form I will enter information on the contacts and it will then store it in a "database" for me. However, I would like to be able to show connections between the contacts, such as if one person knows another contact in the database. What I would love is a field where I could link to other contacts already in the database and then could add a description as to the nature of the
HELP with HTML view please
Hi, I wonder if anyone can help please, I have 3 files "Jobs" "Which job to look at" "Job progress HTML view" When I put the job number in the "Which job to look at" form the chosen fields I have in the "Job progress HTML view" appear. The process works fine an I am very happy with the system. So to my problem. I have taken the "which job to look at" code for website embedding and places it on a web page. The form shows up fine but when I click submit it doesn't jump to the "Job progress HTML view"
Newbie question about printing.
Hi, I have created a html view of something I want to print. My printer can print either A4 or A5. In this instance I wish to print in A5. When I print to A5 in other programmes, I set the condition in page setup. Could you please tell me how to tell my HTML view page to print onto A5. Thanks
HTML Duplex Print
Hi, I have set-up a html view page for an invoice. Can someone please advise me on how to set-up the HTML view to print my terms and conditions on the reverse using my duplex printer. Thanks
How do I modify a record in another form from a stateless form?
I am trying to modify a field based on results from information provided in a stateless form. The form I am trying to modify the record in is called TEST_TRACKING. It contains 1 record that will match a test number and zoho.loginuserid. When I try and use the formula below I get a null error when i add myStatus.Passed = "Y". if (input.Percent < 80) { openUrl("http://failedtest.blablabla.com", "Same window"); } else if (count(TEST_TRACKING[(zohouser == zoho.loginuserid && Testnumber == input.TESTNUMBER)])
I need help to populate a single line field on input of a drop down field in a stateless form.
I am trying to populate a single line filed Called A1 on the input of a drop down field called A with the following..... if (input.A == "A. 15-20 minutes") { input.A1 = "1"; } else { input.A1 = "0" } It is not recognizing the selection. How can I correct this. Thanks for your help!
Please help with HTML view.
Hi this is driving me mad. Once I get this I will be OK, I am sure there are others with the same frustration. OK If I have created an app called "Make HTML View Work" and I have enabled support access. I have created a example form called "details" and added 3 records. I have created a form called "record to show" I have created a html view called "info to print" This is what I want to do and I was hoping someone could help me please. I want the HTML view "info to print" to display and print the
Help with Zoho Creator HTML View please
Hi, I hope someone can help with this problem please. I have a computer shop and I have a zoho database with laptops I have for selling. Now when I want to put one in the window for sale, I use MS Publisher to produce the sales ticket to display with the laptop. What I want to do is create a HTML view linked to my laptop for sale database so if I want a sales sheet for say laptop no 12 the data for laptop 12 will appear into the HTML view. Hope that makes sense Thanks Nigel
Image fields
Can I auto populate the image fields Source, Title, Alt test and Link Thanks
Custom printout in Creator
Hi. I have a database called Laptop Sales. In the database I have listed all the laptops I have for sale in my shop. When I want the display sheet for the window showing details like Make, Model, Memory that I have in my database, I use MS publisher to create the nice looking display sheet manually inputting the data. How can I use Creator to produce a display selling sheet using the data I have stored. Thanks
Help with some Deluge script please
Hi, If there are any budding script writers out there, could you help with this one. I need a script to populate the 4 fields of the image field as follows. I have 2 forms 1st form is called Dealers the 2 fields from this form we need are Picasa_URL and Picasa_folder 2nd form is called Laptop Spares The 1 field we need from this form is Item_Number now on the Laptop Spares form when I input the Item_Number I need the image field to auto populate as thus... source = Dealers.Picasa_url + Dealers.Picasa_folder
Importing Data From Excel
Hi, Can someone please advise if I import data from excel how do i avoid duplicate entries being imported. I can't find that feature but I might not be looking in the right place Regards Jodie
Browser Testing
Adobe offers a service for free that allows you to test your ZOHO Creator pages in different browser/OS combinations. For example in my testing, Firefox on OS X required a page load time of 10 seconds, while Chrome allowed 0 seconds load-time. Also, every now and then I'd get the dreaded "Error: Contact Application Owner" page while other browser/OS combinations were fine. Here's the link: https://browserlab.adobe.com Enjoy! John M. Whitney
Tip on checking existance of records..
So I don't know about you, but I get really tired of having to use the count function to check for the existence of records first before making a collection. (From my knowledge this is how most do it) Example... cnt = count(myForm[field == value]); if(cnt != 0) { myRecords = myForm[field == value]; } One must use the count function because if you try to do this, ZC throws an error myRecords = myForm[field == value]; info myRecords.ID; However, I've found what I think is a very convenient way of
how can i send multiple email notifications with Form Data on success?
how can i send multiple email notifications with Form Data on success?
on my website I need to put some written info on top of the chatbox. Is that possible?
on my website I need to put some written info on top of the chatbox. Is that possible?
Help on Deluge please.
Hi. Below is my problem please help someone. Form 1 Acc No Name Address Telephone Form 2 I want to select acc no from a lookup, no probs I can do this But I want Name, address and telephone to auto fill on form 2 from form 1 based on acc no. No real help online for this script Please help Thanks
Custom Schedule on every 15 minutes
Hi, Is it possible to create a schedule after every 15 minutes? If yes, then please help me how to do this.
How do I format a date-time value in a view ?
I've been trying to figure out the script code to include in a view to show a Date-time field in a particular way ("EEE, d MMM yyyy, HH:mm aaa"). I assume I'd use toString to do this, but I know so little about scripting that I can't figure out the exact code to put in the view's script, or where to put it. Any help would be appreciated. BTW, my application is a schedule of events for a 5-day railroad festival: http://ccrrf.com/schedule.html TIA! Jamie Foster
Next Page