PDF generation broken again!!!
ZC team, a few days ago there was a problem in html views pdf generation, the pdfs were blank. The problem was solved, the feature worked OK, then another surprise today: the pictures are not displayed when pdfs are generated... Look at this example: see here the html view and the generated pdf here I am working at an application where the generation of pdfs is crucial, and yesterday the pdfs were generated OK, today there are again problems (images are not displayed)... so I really need to think
Calculating a value from related field
I'm trying to do the following in a view. In the form associated with the view I have a quantity field. In a related database (based on an item that has been selected in the form) I have the price of the item. I would like to have a formula field in the view that calculates a total cost from the quantity and the price in the related database for each record. is this possible? thanks!
Import data field type : how to import from other applications
Hi all, I'm new to creator and I wish to link a form field to another form in a different application (shared or public), this form acts as a commun reference table for several applications. Is that possible with creator and how can I do that ? When I use the import field, I see a reference to app name, form name and field name, but I do not know how to change the app name (set to my application by default). Thanks
Having some trouble with creating a useful form to update another form
I am trying to create something of a project management app. So I have accounts, which relate to projects, which in turn relate to tasks. I want someone to be able to add as task through the "Add Task" form. Which is working correctly and obviously is not hard. It gets a little more tricky though when I create the form "Update Task". In this form I have it where I would select my task, and then add updates including time spent (a field not in the Add Task form, so unrelated and then other fields
Preceding space in 0 index of multi-select values.
I think I found a bug that can break quite a bit of code for users. 1. Try saving a multi-select box with multiple values selected. 2. On validate run the following code.. fields = myMultiSelectBox; for each f in fields { info "_"+f; } result...... _ home_phone _ Location _ Tour_Date _ ID_str or run this info in a list. fields = web_contact_fields; test = {}; for each f in fields { test.add("_"+f); } info test; result..... _how_did_you_hear_about_us, _ other_referral, _ doc_Name, _ pres_Location,
Get Contact Field with searchRecordsByPDC
Hi, I'm trying to create a formula field in a Aplication. In this formula field I want to get de CONTACTID field of a record. To get this I use zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0). Doing this I obtain the complete record but I only want the CONTACTID field. What can i do to get this? I tried to do: zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0).get("CONTACTID") but It does not work. Thanks, Roberto
Error modifying the page Lexical error at line 263, column 19. Encountered: "\u201c" (8220), after : ""
I use MSWORD to write deluge scripts and paste them to the ZOHO form. I save the text as HTML prior to copying and pasting. Works fine except for the above error message when I write a script like: input.field = "x"; the syntax check doesn't like the quote notation and requires me to reenter the quotes via deluge. What can I do to prevent this lexical error? Thanks Robin
Records Quota Reached Maximum, But Not Really???
I have an application that we use for employment application I noticed that over the past couple weeks I wasnt seeing any new applicants come through. Today I tried the application myself and was given an error message that the 1000 records (free acct) limit had been reached. When I logged in to my account there were actually just over 800. ???? Why would this happen? I exported and deleted 600+ records and everything is fine now. How can I ensure that this doesnt happen again? Maybe this is worth
Subtraction of Hours and Minutes
I am making timesheet application and I would to subtract hours in format 08:23 (hh:mm) What would be the simplest workround to do it in Creator?
Re openUrl("#View:view45")
Dear Sirs I used to use this function in the last line (openUrl("#View:view45") of the need to open the specified view can normally open, but recently opened always www.zoho.com, absolutely not I just open the view, to help resolve, or adjust the deluge of functional? Waiting your help and thanks Stanley Guo
Passing information from a form to a view
A user enters their email address and selects several vendor types from a list of 10 different types. When they click Submit I want to open a view of the vendors that only shows the vendor type the user selected. On each row in the view I want a function that will email the users informatiopn to that vendor. 1) How to I pass multiple vendor types in the openurl command with an OR combination. That is show all records where type is 'baker' OR 'candle stick maker'. 2) When I'm on the view how do I
How can I access field in one application from another application
With in a single application using the lookup field communication can be done between two forms. How can I do the same thing between two forms in different application. Application A has A.field1 and application B wants to send A.field1 as part of an email.
Help with forms and functions please!
I am trying very hard to figure out Zoho but I have a quick question. My website is similar to ebay in that it connects buyers and sellers. I would like potential buyers to be able to fill out the Zoho form on the website and have that form generate an email to my seller. I created two applications - The first application houses my customer contact information including Email, Name, Phone, etc. The other application is a form that will be embedded on my website. Here's what I want to happen:
Easy way to pass ZC data to iframed html/javascript apps or widgets
DISCLAIMER: I just post what I find interesting. This was an exciting find for me that I used on my last large project..... I often daydream about what I could build in a ZC html view if I could run jquery and javascript! Wow, how fun would that be! I could lazy .load() html snippets from other views, save info dynamically. Wow! It would be great. Anyways, IT'S A DREAM for now. But, I have been able to find a way to float a javascript/html app on top of a Zoho Creator view with some fun results!
Trouble with Creator Report
I've created a report based off a table but its not collecting all the data. The report basically shows the total of metrics for each recruiter for the current week but its not showing all the recruiters or collecting all of the dat. when i export the data from creator to zoho reports it collects all the data correctly. But I want to have the report in creator. Help
How to access reports other than Pivot and how to create a GANTT chart
Hi 1 - When I go to reports from Zoho Creator, I see only Pivot Chart and Pivot table reports. Are there any other report types that I can create from within Zoho Creator? Note-I am using the free plan. 2 - How can I create a GANTT chart from Zoho Creator? Thanks. EK
How to make the "Send email" actually show up with a clickable email"
Having no code experience I am not sure how or if I can do what I am about to ask but will appreciate any help. When a user fills out a form I have it sent to me in an email. How do I make it so the user's email address ends up in the "From" field in my email so I do not have to cut and paste to respond? I hope this makes sense. The form is a public form
How many crm records can be fetched to creator
How many crm records can be fetched to creator (for example: from Leads module), from this link: https://help.creator.zoho.com/Fetching-records-from-CRM.html, seems like we can't use WHERE clause, and we can only get Max 200 records from crm. Is that still the case? if it is, why should I still use the functions? am I missing something there? (oh, may be I can use ZOHO CRM API to get the records by Conditions or WHERE clause, is that correct?) Thanks.
Formula field question
In a formula field, can I use the value from a column in a related table?
Calendar: Best calendar solution Creator
Hi Everyone, I need a calendar solution for my Creator app. ...really bad! I have tried over and over to get the native calendar view in Creator to be useful but I just cannot get my users to adopt the Creator Calendar for many valid reasons they complain about. What are my alternative options. Honestly I've seen the google cal feed option but it just seems like such hack. I'd love to hear my impression is wrong. Let me know. Tony.
Stateless Form Intermittenly Nonfunctional
I have a stateless form that worked initially and then went to what looks like a nonfunctional mobile format. The problem seems to have started after I had accessed the form via my iPad but not sure if it is related. The issue first occurred on my iPad and immediately after I accessed the form via PC which reproduced the same results. After refreshing a few times the functional form returned. Now, however, the nonfunctional form always comes up.
Show uploaded image in a new window?
Hello, I'm working on an image voting database, for a charity where hundreds of individually submitted photos are being judged by several internal users. They will upload directly into the Zoho Creator app. For the judging I want a link or way to have the user click to show an uploaded image full-size in a new window. I tried creating a Function and setting that as a Custom Action to create a button for each record, where imageid parameter was set as the file upload field but it doesn't work, it
Dynamically Update HTML Page
Hi, I'm trying to create an HTML page that fetches a certain number of records sequentially. For example, when it first loads, "Page 1" would show records 1-10. This is easy. How can I create a link or button that will cause the page to reload and fetch the next ten records, and so on. Thank You.
Percentage Validation
I have a % field on a form and I need to ensure that the user enters a % between 0% and 100%. I tried using the following On User Input scripting, but it does not seem to be working. if (input.Fee_Percent > 100) { alert("Fee Percent cannot be greater than 100%."); } if (input.Fee_Percent < 0) { alert("Fee Percent cannot be less than 0%."); Should I just change this field to a drop down filed with only the options for values of 0 to 100 and then change my calculations using this field?
Decimals in a Grand Summary on a Report
Is there a way to control the output of the Grand Summary in a Report so it doesn't display 14 decimals? The data is from a Formula field that has the round() function to 2 decimals, so the data looks good, but the summary looks silly.
Remove choices from look up field when selected
I am a real novice when it comes to code so I just thought I would say that up front. Is there a way to remove an item from a lookup field once it is selected by the user. I want to limit the number of people that can register for an event so I thought I would create a form that has seats numbered from 1-10. When they pick a seat the "1" would be removed then the "2" and so on until there are no seats left.
Creator API: last records first?
Hi guys! I'm working with a Creator database in Flash. I'm trying to get my records 20 at a time, last ones first. Any way to do that? By default I get the first ones first. I could use range, but I can't find a way to see how many records there are. If I knew that, I could go range last-20 to last range last-40 to last-20 (I tried making a view that sorts them, but I can't load the view using REST for some reason, keep getting a 404 on the URL. Maybe because the application is private?) Thanks for
I can't use a dropdown list in reports?
I'm asking my customers where they heard about us through a creator form with a dropdown list of prepopulated answers. Now I'd like to create a report on this, to see how many people chose which option. The problem is that I can't see the dropdown field in the report builder?
error com.adventnet.workengine.task
Hi, My system return this error in sending the form (myform): java.lang.IllegalArgumentException cannot be cast to com.adventnet.workengine.task.TaskExecutionException At which part of the script may be referred? Anyone have experienced the same error? Thanks Mic
Ability to include ZohoCRM Modules in creator Application
I saw here http://help.creator.zoho.com/Working-on.html that a new feature will be released for paid editions Ability to include ZohoCRM Modules in creator Application If it is possible, can you describe it? A deeper integration with CRM sounds really good, a feature like this would be very helpful for my current project, and I'd like to know what to expect from this feature. How will be possible to include Zoho CRM modules in a Creator application? As separate pages, as embedded parts (like in the
cannot add record
when I tried to add a record via a form, the following error appeared: 1 . [t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary .[t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary
Cannot add record via a form
when I tried to add a record via a form, the following error appeared: 1 . [t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary .[t_441902000000010037] Exception occured while setting value in PreparedStatement for the Column [LastProjCl_441902000002951563] Check whether the datatype for this column is given as specified in the data-dictionary
Cannot convert String null to Numeric
Hi, I've an application in which I have a field that I fill with numeric values. In on user input I set this fiel variable wiht: if (input.Costo == null) { input.Costo = 0; } The application run, But system still return this error to me. If I cancel the Alert, application run correctly: Error details: Error occured while executing on user input script. Unable to update variable Costo Invalid Numeric Format found Cannot convert the String null to Numeric My application: here
Count - autonumber - some conditions
Hi, I have a view in which I list all class of some universities. So I have fields as, University (U), Matter (M), Teacher (T), Year (Y)... It´s possible to generate a complex autonumber machine for each value as 1, 2, 3, 4 for each UMTY condition in the view (I have 5 Universities, 100 matters, 150 teacher and 3 academic years (so I need 150 autonumber machine for each year)?... Sometimes my tutors forget the sequencies! So I need to get free them from this function! Normally I use this function
URL shortner
Hi guys, none have idea about how use a URL shortner in a creator application? I need to reduce a large url using a webservice (as goo.gl) and send short url in sendmail with .qr suffix to produce a QR image. I find here a function to shortify url and here Api documentation. Here a site that have a source code that may be use. Any suggestion? THanks Mic
Email Address Blocked
My email address is raywhche@zoho.com and I had received Sender Address Blocked message, while I had not sent more than 250 emails today! Please help to get this resolved. Thanks.
Fill a dropdown based in conditions and others dropdown in others forms
I have to generate a complex choice based in an initial selection. I have Universities (A), Years (B), Matters (C), Teachers (D), Lesson titles (E). In the first step people select A, so I have a script to populate B. Then people select B and another scritp populate C, and so... as soon as E. Now I have to add another variable condition, that is type of course (complete or partial (X), so when people select B may also select X, and I need to populate C based on two variables, B&X. I try to rich
embed problem with summary of view and updating form information
HI Thanks for any help you can offer. My users are unable to find the popup box to update information from the summary view because it is centering itself on the default size of the iframe instead of the users screen. I believe the problem stems from me having to set a default height (7000px) instead of 100% so that the form displays correctly in all browsers(firefox inparticular). I assume this is the issue because the pop-up box displays correctly when not embedded. Let me describe a few of
Make Table Query in Creator?
MS Access has make table query. is there something equivalent in CREATOR? I have loaded a form with data. I want to just select out the unique entries in one of the fields and use it to populate a new table (form).
Buttons won't open dialog boxes when form is embedded on website
I used the notes field to add buttons and call up html views inside a dialog box when the button is clicked. The problem is that these buttons don't work when the form is embedded in my website. My colleague says it is a cross domain issue. Is there a way to get these buttons to work when the form is embedded?
Next Page