Custom Styles in Embedded Reports
What is the best way to create custom CSS or other styles to a Zoho Creator Report? Do I have to create a separate "Page" and build it from scratch? Certainly not.... All I have found so far is very limited color changes but I need to adjust the font size of various records and even better would like to highlight certain groups or records differently. I am new to this so maybe this is not too complicated of a question... Thanks
Primary_Contact=crmResp.get("First Name"+"Last Name"); Not Working
Apologies for the seemingly simple question but I am very new to the whole Zoho world. I have built an app in Creator that has a Zoho CRM field that pulls from Contacts to populate fields on my form. One of the fields is called Primary Contact which I would like to put the Full Name (First Name + Last Name) I CAN get Primary_Contact to equal First Name OR Last Name but not both, I don't know if I can concatenate First Name and Last Name but everything I have tried doesn't work :-( My code below works
Grid View not working due to "on edit" action that I did not add
According to this thread, https://help.zoho.com/portal/en/community/topic/changing-the-display-type-of-view-to-grid-does-not-work, you can't have a Grid view if there is an "on edit" action. Fair enough. I have a form that I did not add any "on edit" actions to, but when I go to the Form Definition (With Action) area, it shows the following: actions { on add { submit ( type = submit displayname = "Submit"
New auto-hide dashboard's horizontal scroll-bar doesn't load always.
Steps to reproduce: 1. Create as many forms as it would take to exceed the 3-column listing on the auto-hide dashboard, such that a horizontal scroll-bar would be required to reach all forms. 2. Logout and login (or just open a new tab). 3. Go to the "Forms" tab in the auto-hide Dashboard menu. The horizontal scroll doesn't appear. However, when you navigate to other tabs ("Pages" or "Reports") and return to the "Forms" tab, the scroll bar starts to appear. The problem occurs consistently. -Varun.
Sync my API with Zoho CRM
Hello, I have my own API that already contains info, and I want them info to be transfered to the crm I don't want to use your Zoho CRM API I want to use my own API I want to know if it s possible to do that ? I am awaiting your response. Sincerely,
Graphical view of a referral network
Hi, I would like to create an application to manage a referral network. I have a table with members info (name, referred by, reffering to, etc.) Is there any way to have a graphical view of members? I mean to see who is reffered by who in a view, not searching in DB. Thanks
Keywords used in HTML Page disallows saving it but with an irrelevant message.
If a variable is named after a keyword (like say "count") in the HTML page, the save fails with an error message that asks the developer to contact the support. A relevant error message would be beneficial. (more relevant the better. if the parser can report use of a keyword, even better) -Varun Yagain.
set variable to portion of lookup field
I have a lookup field in FormB that is pointed to FormA. That lookup field is pulling a string and a date. I am trying to look at the date associated with the string to figure out if the item is acceptable or not. When I create an if statement looking at the portion of the lookup field it says it cannot access child fields. Am I coding this wrong or what way should I go about it so that I can get the information I need. Thank you.
Segmenting fields on Zoho Creator
Hello everyone, I would really appreciate if it is possible, using zoho creator to segment fields on the (SORTING/GROUPING menus) so that I get the following presentation on my form, instead of having all the data in random order. Thank you very much for your quick reply GENERALITIES 1) 2) 3) APSECTS 1) 2) 3) PARTS 1) 2) 3
How do I fill a field's value based on the value of another field?
When I am in the Cases (or other modules) of CRM and Choose an existing Contact (lookup), the associated account is automatically filled in for the Case. I would like to do the same thing on Creator form's I have created. The first thing I would like is exactly what I described for CRM Cases. If I get that to work I would like to fill other fields (e.g. phone number based on contact). I am new to Creator programming. I've been searching the forums, KBs and help for this problem. I've found a few
Script to generate a new form
Hi All, Is it possible to generate a new form and view by scripting? I have an application where the user will enter a name for the new form and somehow I'd like this to be created On Success. Alternatively, I could have a template form and somehow script that it should be copied and renamed to the name the user entered. I'm stuck :) Any help, hugely appreciated!!
Inserting bidirectional subform without display type
I'm trying to create an app with a bidirectional subform that doesn't display the linked field below the subform. I have two forms. Main form is "Clients" and subform is "Appointments". I want to be able to enter appointments in on the clients form and have it be a bidirectional link, but when I do it adds another dropdown field below the Appointments subform. There is an Application called Employee Management that I'm trying to mimic, but I don't know how to accomplish it.
Formula field looking up Child of input
I have two forms. Clients - Has First_Name and Last_Name fields. Attendance - Has Client lookup field, Date, and Status. I want to add a formula field to Attendance that will concatenate Client.First_Name + " - " + Status When I try this, the Client.First_Name I get 'Client' is a lookup field and child fields cannot be accessed When I try Clients.First_Name I get Variable 'Clients' is not defined When I try input.Client.First_Name, it accepts it, but returns null for input.Client.First_Name If I
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
Next Page