How to get singles purchases from a list of tickets.
Hi.......struggling this afternoon. I have a list for 24500 tickets sales. Each sale has a customer number which relates to the customer who bought it. A customer may have bought more than one ticket and there will be a record for each ticket sale. What I need to find out is how to filter or create a new view where I can see the customers who have only purchased once. The best way I have thought of is to find a way to filter the view so that I only see customer numbers that have just one record but
Empty deluge field name (problem with cyrillic)
I'm create field in the form (date type), and fill the name of field using cyrillic character. ZC automatically assign cyrillic name to field deluge name and save changes ... After that I have no access to this field, I can't backup app, I can't download app to my computer. In form definition it looks like empty name: "" ( displayname = "Дата выполнения" type = date width = 130px alloweddays = 0,1,2,3,4,5,6 ) but i can't
More Details button not displaying in the view?
In the help documentation or on these forums, someone showed me how to create a "More Details" button with the class "zc-formbutton" that displays in a view. It allows you to hide columns in a view, but then easily display that data again when clicking on the More Details button and loading a summary view tied to an ID. Anyway, I've used this successfully many times before. However, I just copied my old code, pasted it into a new project, but now it's not working. I'm not sure what's different this
Access to main form fields in subform script
Hello. I have a SubForm called Tasks into my main form. Every time i insert a record in this SubForm, i want to insert one record in another form. The problem is that i need 3 field to do the insert and 2 of these fields are in the main form. How can i access to this fields?
script builder for each on a subform "input." is missing causes save error
Hi maybe me not sure, use "for each" from script builder select a form which has a subform (in case it has to do with the name of the subform mine is called v3_Booking_Form) the dialouge box opens and you see input.v3_Booking_Form then u select it but input. is not present in the written script and it fails to save, you u then go free flow add the word input. and it saves
Create A JSON Request
Hi all! I need to use postUrl function with JSON request parameter like this: { "kind": "fusiontables#styleSetting", "tableId": "TableID", "styleId": 1, "markerOptions": { "iconName": "small_yellow" }, "polylineOptions": { "strokeColor": "#ff0000", "strokeOpacity": 0.5, "strokeWeight": 2 }, "polygonOptions": { "strokeColor": "#666666", "strokeOpacity":
Merge data into Word or PDF
What are the methods available to merge data from one or more tables into a form template that results in a Word or PDF document that can be saved and/or printed? It appears that the only way is to create an HTML template to do this. But how do I get from the resulting view to at least a PDF document?
Form verification code works when accessed on Creator URL but not on Custom App URL
Works here: https://creator.zoho.com/yagain.v/enroll# But not here: http://enroll.360hvpl.com/# Anyone has an idea? -Varun.
subform box dimensions
Hello, I have a problem when I put multiselect boxes in a subform, where I edit the dimensions in form it´s ok and the layout is good, but when I see the fields in the subform the dimensions are wrong. How can I force dimensions settings?
Command to Hide/Show (ALL Fields on Form)
Hi, I've noticed it gets extremely cumbersome to hide or show fields in forms which have 30 fields or more. Could we have 4 commands, Hide(all) Show(all) Enable(all) Disable(all), much like Deselect.all for checkboxes. This makes coding much neater and simpler. Instead of hiding 25 fields, we'd rather hide all then show the 5 we need. Anyone else need this? I hope you can come up with a solution please. Thanks in advance.
Conversion from Personal to Domain Account?
This is probably just a simply oversight on my part but I'll post it anyway. I have a Google Apps integrated Zoho Creator account and I'm trying to convert it from a Personal Account to a Domain Account. I'm using the instructions provided here http://www.zoho.com/creator/help/general/zoho-creator-for-your-domain.html#Account_Types, however when I click on Settings|My Account I don't see the page reflected in the documentation for verifying domain ownership. What am I missing?
reporting on values calculated using formulas
I have a form that includes two user-entered number fields, RSVPs and Attendees. I also have a formula-based field that calculates No Shows as (RSVPs - Attendees). The problem is that I want to create a report that shows, for each site, the total number of RSVPs, Attendees, and No Shows, but Zoho is treating the No Shows field as a text field and thus will not allow me to sum the values. This makes no sense to me, since it's clearly calculated from two numeric fields and can only be a number. Is
Creator AutoNumber Edit
I need my records to be auto numbered sequentially. However, my staff deleted some records so now the ID number reads 117, 119, 123, 125 instead of following continuously. Is there any way that I can edit the auto number to include the number that were deleted. Every time a new number is created it starts from the last generated auto number. Any assistance?
how to get accounts contacts and products details
accountlist = zoho.crm.getRecords(("Accounts"), 1, 200); ac = List(); for each accounts in accountlist { ac.add((accounts).get(("Account Name"))); } we want to get account related products and put those product names in accounts related contacts/lead. so how to get accounts related products and put in accounts related contacts multi select field
How to set criteria to reports in zoho creator
Hi, Is there a way to set criteria to reports throught URL ? I need to dinamically filter data that are shown in the report based on particular field. Regards, Christophe G.
Row Color Formatting in View (Question Re-asked)
I would like to format the color of a row (Red, Yellow, Green Stoplight Report) based on a due date. I saw an old post from 2009 and there wasn't an answer. Just wanted to see if someone had found a solution for this?
Missing field on left toolbar in a pivot table ??
Hi, I added a column in one of my view. Then I created a new report (pivot tbale). But i can't see the new field on my left toobar... Thx for your help ugo
Can not make appliation public
I can not make an application public. No matter what I do it reverts to private. This happens on the application, on forms, and on reports. There just seems to be no way to make these public. It used to work with no problems but since the new editor was added I have had nothing but problems.
Back in progress
Hi, Under the back up in progress screen, I can see an application that failed. Is the back up still running? Otherwise, should it be in previous run screen? My administrator is worried that it may still be running in the background. Can you clarify? Thank you
Where are the list of functions?
https://www.zoho.com/creator/help/script/built-in-functions/built-in-functions.html this link doesn't work anymore. what gives?
Field value in e-mail notification not what is present in Creator/Form View.
I'm creating an e-mail on success of a form and all looks good besides a few fields where I'm having difficulty. I'm sure all the fields im having issues with are all related fix. Example E-Mail Code: <%=input.Contact_Person%>, This e-mail confirms our most recent order. ________________________ The issue is the e-mail sample i'm receiving comes out like this: Example E-Mail Sample 1267173000001045015, This e-mail confirms our most recent order. __________________________ The field reads in ZoHo
Distinct Value
Hi All, I am trying to create dynamic drop down list in my form. Form : A - Location =============== State City Area Zipcode. The nature of the form is, all 4 fields altogether will give you unique value. But for a given column, it will be duplicate value. (ex: one state may have many cities, one city may have many areas etc..) Form B: Blood Bank Register ====================== For this form, I need to create State, City, Area drop down list dynamically. I have created simple drop down fields. State
Lookup
Hi everyone I'm hoping that someone may be able to help us with this question. We currently have a list of customers and a list of service codes. In a form we choose a customer name and then choose a service code for that customer. This may look like: Name: John Smith Service Code: 55P662 We have another form that uses the name, but different pieces of information. We want to be able to select the name of customer (John Smith) then it automatically show the service code entered in the other form.
URL Filtering by lookup field in view
Hi all, I have a simple lookup field in a form. The field name is Entity_ID and the main form it references is called Entity. I need to filter this view by Entity but seem unable to do so. Previous suggestions include something like #View:test_view?Entity.Entity_ID=8888888888888 This has no effect and does not filter the view. I have also tried #View:test_view?Entity=8888888888888 This yields a blank view. Any ideas as to what I am doing wrong? Previous post would seem to indicate this is the
Can't edit after saving a new view??
My shared users can't edit after saving a new view. They can edit fine from one of the views I created with the app. But if they then re-sort, hide-columns etc to customize the view, then save it under a new name, if they then click to edit a record, there is an error message that says "there is no such form in zoho creator" and the app locks up. Please advise? Thank you very much.
Serious issue with old app builder: Freeflow script editor wipes code
Hi, I'm experiencing a curious issue. I'll 'save' a code segment using the freeflow script editor (in the old app builder), Zoho will say 'Saved' but then when I click back on the 'On Input' script, all the code is gone. It seems like the script validator is faulty and does not show errors when I click save. It's very frustrating as the first time I did it, I didn't realise and lost about 50 lines of code. Now I'm aware because there's a telltale sign: the dot next to the input field shows as grey
permalinks for reports
When I generate a permalink for a report, it seems to create a static snapshot -- that is, only the data in Zoho at the time the permalink was generated appears; the report doesn't update as new data is entered. Is this correct/expected?
Formula field with Child dependency
I have two forms, Clients and Attendance. Clients has First_Name and Last_Name fields. Attendance has Client, Date, and Status fields. The Client field is a lookup of Client.First_Name + Client.Last_Name I want to add a formula field to my Attendance form to combine Client.First_Name + " - " + Status If my formula is; Client.First_Name + " - " + input.Status 'Client' is a lookup field and child fields cannot be accessed Clients.First_Name + " - " + input.Status Variable 'Clients' is not defined
Current E-Mail Notification Suggested Best Practice
Currently, we're using the new application builder. The help documents reference going into On Success in the builder to use deluge. But I also see the email notification on the new app builder form settings page. From the way I see it, if we want simple form submission on success, we can use the form builder settings area. But if we need more advanced, we should use deluge. Is this correct?
Inventory Database
I added trucks to my inventory DB. Now I want to be able to subtract the Part used from that truck, and update the total in my inventory. Presently it just subtracts when personal uses a part. I have a script below. I am trying to picture this script, but keep getting confused. Example: If truck 1 uses a part from his truck, how can i subtract it from that truck, and update the balance in my inventory? //Below is the Parts Used validation script input.WO_Date = zoho.currentdate ; Product_Number = Inventory[Product_Number
Zoho Creator Down?
I am experiencing a o connection problem....Java.net.ConnectionException: Connection refused
Auto filled fields - From Data base (Fill as and when type)
Hi All, Is there a possibility to implement auto-populate fields in Zoho creator. We have a form, where we are populating some information. Field1: State Field2: City Field3: Area Field4: Number of boxes To use this form, I have created Drop down menus for State, City and Area. Based on State, City drop down box will get populated. Based on City, Area drop down box will get populated. User is not happy, as one city has approximately more than 1000 diff areas. They have to search it from drop down
Integration with zoho support and projects bug tracker
Hello, Is there any integration with the creator to zoho support or projects and bug tracker? Thanks, Darren
Sorting CRM query results
Is there an easy to sort the results from a CRM query? Thanks David
Deleting application with cross referenced functions
I want to delete the following applications that I created whilst testing the duplicate application functionality. assets_new DEV SERVICES AND ASSET TRACKING TEST (obsolete) When I attempt to delete the applications, I see the following message This application components is used in the following places, Please remove this and try deleting the application. ... In the past, I removed the all the code manually and this allowed me to delete the applications. This is a very time consuming process. Can
How to temporarily suspend access?
Hello, I need to make some changes to my application and would like to suspend all my users' access while I do this. Is there an easy way to do this? Thanks, Lindsay
Multiday Event Form, calendar view
I was wondering if anyone has ever achieved a multiday event form to view in a calendar view. EG: have a start date/time and End date/time in form. Then the all days of event are shown in a calendar view. Thanks
URGENT PROBLEM - Intermittent Email Sending
Hi, We have had the facility to email out quotes from our application for the last year with no issues whatsoever. Suddenly around 10 days ago, email sending has become completely sporadic. Some emails send, others don't. I've monitored behaviour over the last hour and only 5 of 16 emails sent, which is representative of what we have experienced. As there is no pattern with regards to which quotes will and won't send at what times, I can only conclude that it must be a platform issue. I submitted
RIP
Cheers, John Whitney
Some users on VPN can login but cannot access application
Hello, I am wondering if there would be a problem accessing a Zoho Creator application via a VPN? I have built an application for a company and users can access the application when they are on networked computers in the office but cannot access the application when they are working remotely through a VPN. Could this be because of the version of the browser they are using? Or because of VPN security settings? Or because cookies need to be enabled? Users on the VPN can login to their account but
Next Page