Marketplace Client Publishing
In Marketplace, if you Publish an app to a client with data and source code, can they then create a copy that will "live" on independently of the original app. Will the copy have full editing privileges as if it were created by the client? Will the copy lose any functionality if the developer closes their Zoho account? The reason I ask these questions is that I need to move an app from its original account to a second account and the ds file I created from the original account will not import into
ds file import problem
I can't get a ds file to import. The ds file has many lines...could there be a limit? I get this error: There was a problem importing application null. The ds file was created as a back-up of an application in an account that I own, but that is different from the account I want to import it into. Is it possible for Zoho reps to make this move for me? Would it be worth a try to put the app on marketplace temporarily just to get it moved over to the other account?
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
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?
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
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?
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
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
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
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?
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
Lookup Field
So I am an MS Access person and need a little direction. Here are my details: Table 1: Department- Fields: Department, Floor, Code Table 2: Staff - Fields: Name, Address, Phone, Lookup Field for Department Form: Employee Certifications Fields: Class, Date, Lookup Field for Department from Table 2, I need a field that holds the Name In Access I can have a Lookup Field that shows Departments when I select the Department my next Lookup Field only shows me records for the field Name that are in the Department
check if date entered correctly
I get an error on the following expression that checks if a date has been entered correctly if ( input.Data_do_Auto.matches("[0-9]{2}/[0-9]{2}/[0-9]{4}")) It seems that using string expression in a ".matches" function isn´t allowed. I appreciate any help on this issue. It would be nice if ZC could put more effort on documenting the deluge functions. This would save us a lot of time and make using ZC more viable. Thanks.
Hide buttons in Stateless forms works erroneously.
When a hide button-name; (or even show) is invoked upon on-load of a stateless form, it hides all the buttons on the form and not just the one being referred to. Note: The form definition with actions is attached. -Varun.
Syntax checking/parsing needs fix.
If there is a data type mismatch while querying for data, the ZC compiler isn't reporting any errors but the fetch itself fails. This makes it very hard to debug. Example: Consider column NumberType to be of type Number in MyForm. //This compiles fine but returns no rows floatValue = 2.0; MyForm[NumberType == floatValue]; on the other hand: //This compiles AND returns rows as expected. intValue = 2; MyForm[NumberType == intValue]; The ideal scenario would be: 1. Report an error, OR 2. In case of
HTML5
Is html view supports HTML5? I would like to make a form <form id=payment> <fieldset> <legend>Your details</legend> <ol> <li> <label for=name>Name</label> <input id=name name=name type=text placeholder="First and last name" required autofocus> </li> </fieldset> </form> However, the placeholder is not working in HTML view. Any suggestion? Will it support HTML5 in near future(within 3 months)?
Sub Form auto add button feature
Hi, OK so here is what I want to do. I have been told that Zoho does not currently have the ability to trigger the add button of a sub form automatically from a script. This feature is vital to my project so I have been looking into this in an attempt to help you with the feature. If I could find a way of implementing the following Java code within a script, it should trigger the add button in the sub form. <script type="text/javascript"> $window.onload = function() { $eval(document.getElementsByClassName
Logout link on my website
I need to add a link to logout in my website and not found. Can anyone help me? Regards
How to use XML response from Creator form submit
I have created an HTML view in Zoho Creator that posts data to a creator form. I did this because I don't want all the form field to be displayed to the form user. My form submits perfectly. However the xml response that comes from the form submit gets returned as a downloaded file and I want to use the <status> element to provide feedback to the user of the form. How do I consume the response data since I cannot use javascript or php in a Zoho Creator HTML form?
Text field in forms turns numeric in mail
Hi I have made two forms one with at text field (name) and the other one with a lookup (name). When i put it in a mail - on success send mail to - it turns numeric - see below. It's the first line after "Kære" What to do? Kære 1527373000000054102 Du er tilmeldt kurset Afklaring hos os, vi glæder os til at byde dig velkommen. Vi starter d. 14-Oct-2013 kl 8.30 og satser hver dag på at være færdige kl. 13.30. Kurset afholdes på vores kontor på adressen: Gråbrødregade 14, 1. sal 6000 Kolding
Displaying a Page within an iframe without the Zoho Header
I have created a page (Page 1) which I wish to display within an iframe another page (Page 2). I can do this with the OpenURL function, but I can't figure out how to display just the content of the page, and not the full page including the Zoho URL. How do I construct the right URL to use in OpenURL? I can find the guidance that explains how to use parameters in the URLs for Forms and Views to configure how THEY get displayed, but I can't see the equivalent for Pages. Thanks for your help. Alex
Sendmail problem
Dear Zoho team, When using a Sendmail function, Instead of getting an email message with the expected input of a droplist field, i get a Zoho ID number (e.g., 1534967000000030720). why is this? how can it be fixed?
how to put column name in fields of table in query_table
Need help to create zoho report from tables by selecting column name and respective values sorted according to date for eg: see attached file snapshot can we design zoho table by query_report or report view, if possible please provide help regarding it. and we are getting result from table please provide help if any problem in query execution and how to get pivot view on clicking on one pivot view in child window
Problem with a lookup field
I have a form (A) in which I incorporate a lookup field to form(B) //for client names - string field The name retrieves ok and displays ("ABC Ltd") which is what I want. Later, I wish to test that the field is actually "ABC Ltd" to then show/hide other fields. Creator specifies a lookup as type "long" and I can't then test as it will return a numeric such as 720050000. IS there any way to handle this? Thanks Greg
Can Zoho CRM Pulse and Audit Log Records be Called in Zoho Creator?
If I set up a creator form record pulling info from a CRM module, is it possible to get pulse and audit log data?
Configuration of the Maxchars on a single-line field.
The increment/decrement on the max chars field configuration allows a max value of 999 while any value is accepted if the user types into the field. Also, the maximum characters that can be used in a form (according to the known limitations document) is 80 fields of 255 chars each or equivalent. There is no validation while the developer is configuring the fields but for the run-time error that is hard to debug. Can not a validation be added when the fields are configured rather than at run-time?
Login to my site opens new tab
Added views and forms in iframes on my site, but when the login is done by users instead of opening the form or view in the same window is open a new tab. How do I remove this behavior? Must remain after login on the same page. Regards Alexandre Bacil
[URGENT] String.removeFirstOccurence is not being recognized.
The compiler throws an error that this isn't a recognized method. Please help. -Varun.
Real time screen updates
Is it possible to show a time counter decreasing in real-time eg an auction period decreasing from a start date that was set to run for a specified time. Example Auction start date 15 Sept 2013 time 9:00am Auction end date 2 Sept 2013 5pm When view item you see days, hrs seconds decreasing in real time. This element is stored and is treated as a variable that can be called referenced in the application. Thanks for your guidance
CRM with RSS reader
Hey guys, I'd like to find a way using either Zoho CRM or Zoho Creator to view an RSS feed and add the authors of news articles to a CRM-style list of contacts. I'm happy to spend time building this with Zoho Creator. But before I get started is there an RSS reader in Zoho creator or will I be beating my head against a wall? Also, is it possible to do this with an add-on or extension for the existing Zoho CRM? Many thanks!
Using zoho.loginuser in view does not work with API
I have a view that shows 16 records in it, 1 added by another user and 15 added by me. I have a view that limits what is shown by zoho.loginuser criteria, this is done in the view definition. If I embed the view in an HTML file and look at it locally the widget shows the correct number of rows depending on who is logged in, however if I retrieve data using an API call (to export the data). It always returns my data (15 rows) no matter who is logged in. If I use the export function of the view rather
Next Page