Email an HTML View
My client has a report generated using html and populated with values from a database. While we can export to a PDF and then email this report, a more elegant feature would be to click to email, and have Creator take on this task. Any ideas? By the way: A potential bug. When we click to make a PDF, the report's embedded logo goes missing! The logo is linked to a file upload url in the same app. Cheers, John Whitney ZOHO Creator Developer
HTML View - how do I add a report?
I am creating a simple dashboard in an HTML View and would like to display a Report. What is the best method?
Print single record
Hi, Some time ago you kindly added the print option to my 2 main views, a feature which was apparently at the time in beta. Since then I upgraded to the new look and the print option has gone (in an iframe). Is it possible to keep the new look but have the print option back? Adam Smith
Conditions in a HTML view
Hello, I'm trying to make Html view with conditions but it doesn't work. <%if (curProposition.Product_ipad1 != null){ <tr class="zc-viewrow zc-row-1"> <td align="left" czc-viewrow="" zc-row-1=""><%=curProposition.Product_ipad1%></td> </td><td align="left"><%=curProposition.Date_ipad1%></td> <td align="right">10</td> <td align="right">30</td>
Where do Bounced emails go?
I used Zoho Creator to send an email to an invalid email address. I have not received any notification that the email was undeliverable. I have looked at the inbox of the email on the Zoho account and the message inbox on my Zoho Creator home page. How do I get notified when an email is undeliverable? Herb Wexler
How to optimize deluge script to run faster
Hi, I have a form that is very complex and it require several fields interactions in order to accomplish all customer requirements. Currently the script is running well, but it is running very slow. Any suggestion on how to optimize it? Thanks in advance.
Suggestions in User Management
Hi, we are developing a solution that required user authetication in order to manage specific data and workflows according to user permission. I am using the user management available in Zoho Creator, nevertheless I want to provide more formal emails of registrarion for the application, where the message of the invitation to the application is more relevant in the welcome email sent by Zoho. Is there a way to customize that kind of emails?. Thanks in advance,
Send mail with "if" command in body copy
Hi, Is there a way to send mail with an "if" command in the body copy? I have two kinds of contact fields and I'd like the email to say: Hi <contact> But if the <contact> field is empty I'd like it to say: Hi <contact_NEW> How can I do that without ending up with Hi null <contact_NEW>? Thank you for any help! -silver
Iterate Values in Subform
In regard to post https://help.zoho.com/portal/en/community/topic/displaying-subform-records-in-html-view marked as Answered, I attempted to understand how to reiterate thru vales in a subform to display on an HTML view. The sample application has a number of strange issues that are easily diagnosed by attempting to edit the HTML view. Please explain how to do this rec = Main_form [ID == input.id.toLong()]; for each i in rec.SubForm_1 { //some code } Cheers, John Whitney ZOHO Creator Developer
How To Pass ID From One Form To Another Form With Out Using The Querystring Functionality?
Hi, I am using a single "Stateful Form" and "Three Stateless Forms". I am passing the ID Created in the Stateful form to other stateless forms. So that i use the ID passed using query string to stateless forms for updating data to the record in the stateful form. Suppose say this application is used by many suers,The problem is as the ID is passed as query string, it is stored in browser history. So when anyone logs in they can view the records using those url's since i have written some logic to
How to show the application menus and messages in other language different than English
I am developing an application for a Spanish-speaker country. I want to customize the actions such as edit, export, etc to appears in Spanish instead of English. How can I configure that?. Thanks in advance.
Why is form text so big now?
Hello, One of the things I don't like about the new UI is that fields on forms use such large text (unless it's a notes field where I've adjusted the size). However, recently I noticed that even in the old UI the text is all really big. Under settings, there are only two choices "Medium" and "Big" and they're both too huge. Can we please revert to the previous, normal font sizing? Or at least give us better control over this? Space is already a premium on a two-column layout, and this new size and
Number Calculation
Hello - I have a calculation that I am trying to do and I am trying to figure the best way to write the formula. I have the following fields/information: Funding: I/O, Level 1 Staff to Consumer Ratio: 1:1, 2:1, 3:1 Est. Awake Hrs.: (number) Est. OSOC Hrs.: (number) Est. Weekly Revenue: (formula) The goal is to calculate the “Est. Weekly Revenue” based on the selections that the user makes. There are different rates for each “Funding Type”, each “Staff Ratio”, “Awake Hrs.”, and “OSOC
setting user permissions for data access
Hello I'm currently building my application and populating it with data which currently stands at a few thousand rows and will eventually grow by a few thousand more. My question is that eventually I'm going to move this into a sustaining phase and will be trying to engage with external users to update data based on the company they work for. My goal is to limit view access based on organisation(s) or maybe an organisation and country. These are all currently captured in the database.
please add individual days of week to schedule frequency options
Please consider adding the days of the week as options for scheduling so that scripts can be set to only run on specified days - for example only on business days or only on weekends. Checkbox inputs would make this more flexible: [] Monday [] Tuesday [] Wednesday [] Thursday [] Friday [] Saturday [] Sunday
Default Values not working on Excel Import
HI There - It's Day 1 of Zoho for me and so far it's making sense. One issue that I need help on... My form has about 30 fields in it. Four of them have default values set up. When I start adding records I will always be importing an Excel file. The excel file only has 10 fields in it -- none of which are the ones that are supposed to have default values. After the import, the ten fields are populated, but the default value fields are not. What am I missing? The default fields do work if I enter
Public form for data entry by staff
I have a public form that uses captcha and sends two emails. One email is established under Set Email Notification, is sent to staff, and includes user submitted data. The second email triggers on Success and goes to the email account entered in the form. Because the form has hidden fields, I do not want to sent user submitted data back to the public website visitor. My challenge is this: Sometimes staff need to add data from hard copy, i.e. printed forms that clients have filled out. When staff
Displaying Subform records in HTML View
I am trying to display all the subform records that are submitted on the within a single entry of the parent form in a HTML view. My code is below, I cannot seem to get the loop right. It is only showing a single entry on the HTML page. htmlpage Call_in_Report_HTML(ID, Id1) displayname = "Call_In_Report_HTML" print = true pdf = true content <%{%> <div style="width:95%; margin:0 auto;"> <%a = Call_in_report_new [ID == input.Id1.toLong()]; for each a in Call_in_report_new [ID == input.Id1.toLong()]
Embedded Google Calendar Permission Error - ICAL feed
I made a change to one of the ICAL feeds on my Google calendar that is embedded in an Zoho Creator HTML view and now I am getting a permissions error ("Events from one or more calendars could not be shown here because you do not have the permission to view them.") when I try to view the calendar in Zoho Creator (without being logged into the Google account that owns the calendar) I have re-added the calendar feed MULTIPLE times with the Public setting (altough I think that the first time I added
Help with scripting function
Please can someone assist me with this. I've created a simple app which consists only of 2 forms to simplify the problem. The forms are Quote and Items. Items is a subform of the quote form. I'm trying to script a custom function which will add a new record in the Quote View which has the same data as the original record INCLUDING the data from the subform. Here is what I've done: void revise(int ID) { dat = Quote [ID == input.ID.toLong()]; subform = dat.Items; name = dat.Customer;
How do I get rid of these items on my application?
Hi there - just wondering how I change my application HomeScreen - see attached picture I have decided just for ease of use to use a stateless form instead of an HTML generated view Thank you Jonathan
iFrame Video within a Form Notes Field
In a form notes field you can format text and insert images - I would like to embed a video - the reason is that I am creating a "Frontpage" for the application in a stateless form as its much easier that fiddling with HTML for me anyway! When I open the notes field to edit and switch to source, I can paste Vimeo iframe code into the field. Then, when I switch from source to a real view then the video still appears. I then save the notes field and it seems as though the iFrame tags are then stripped
basics offline options
would be possible to imagine a very basic offline version of zoho creator? in my opinion very basic means possibility to store locally added or modified data and upload them asap. conflicts can be solved manually one by one. working on windows at the very beginning also on bb iphone android in a short period. inm ready for a small mounthly investmnt for development nt in this direction assuming the option can be ready in aprox 6 mouths. thank you
comparing fields with nulls and spaces
I have a multiline field on a stateless form and on a corresponding master form. In the on load section of the stateless form I set the value of the stateless form field to the value from the master form field. On submit I send an email if the information was changed. The problem is the email is triggered because the master field has a value of null and the stateless field has a value of blank. Is there a better way to compare the two fields so that nulls and spaces\blanks are treated the same?
Formula Fields Not Updating
I use a lot of formula fields for simple things like displaying full names of a contact or creating a URL link to a details HTML page. Quite often the formula result does not update or gets somehow corrupted... This has been happening for a long time but I'm only now getting around to reporting the issue... Simple example. 'Admin' Application, 'Contact' Form, 'NameEmail' field has formula = First_Name + " " + Last_Name + " - " + Email Right now, the majority of my contacts are displaying first and
Populating fields with data from related different forms
OK Here is an issue that I have tried to simplify: My application has 2 forms MAIN DATA MAIN which has 2 fields MainSalesPerson - LOOKUP (linked to DataSalesPerson). MainEmail - Fetch data from the DATA FORM DATA which has 2 fields DataSalesPerson - TEXT INPUT DataEmail - TEXT INPUT In MAIN, on user selection of MainSalesPerson, I want to fetch the corresponding email from the DATA form field DataEmail and display it in the MAIN Form field - "MainEmail". I cannot seem to understand how to get this
Posting data from Zoho to REST Api
I am trying to post data from a Zoho form to an API through XML so that I can push a list of updated records upon each add or edit to the Canvas API. This should be really easy, but I am not grasping the concepts of the built in function for HTTP requests. Could someone help with some sample code? Look at the reference data API starting on page 12 of this document: http://www.gocanvas.com/content/images/file-uploads/Canvas_Webservices_-_version_1-3-0.pdf Trying to do something like this in deluge
problem with condition evaluation
After the last update, some of my html views generated errors. The problem is that it is a very used piece of code which was correct until last update. An example: if(recid != null && Contacts[ID == recid.tolong()].count() > 0) { // some piece of code } Iff recid is null, the code Contacts[ID == recid.tolong()].count() was no more executed . This was the behavior before the last update and it was convenient. The condition checks if the record is null and ONLY if it is not null it checks if there
Please tell me if this is possible in ZOHO.
I am going to build an audit form that will submit a bunch of building data into a database. Example data: Building Name Building Address Owner Name Existing Measure A - Potential Measure A Existing Measure B - Potential Measure B I'm then going to submit this data into a database. Here's where it gets tricky: A) I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).
Form Schedule Did Not Run
I have a form schedule setup to send an email on a specific date (later than today). Send Queued Posts { Execute on POST_QUEUE_FORM.DELIVERY at 01:00:00 } POST_QUEUE_FORM contains a date-field DELIVERY. However, the schedule did not run recently as anticipated. I do have the frequency set to ONCE, since I only want one email sent. Am I doing something wrong? Cheers, John Whitney
String to int
I can't find out how to parse a String to an integer in the deluge scripting language. Hopefully someone out there can explain to be how this is done. Thanks
how do I get an e-mail when a field is updated?
I have a form with multiple fields. I'd like to get an e-mail anytime one or more of the fields are changed and SAVED. However, I would ALSO like the e-mail to say: 1. Which fields were updated (what they previously were and what they currently are) 2. Give me a link to that particular data-set I know how to send the e-mail on update, but I don't know how to pull out the variables that tell me the above 2 listed items. Any help? thanks! - Quan
Reset Total value on update
Hi All, My form has several fields for numeric values to be entered. At the bottom is a total field. I set an "on user input" script for each field as follows to update my overall total at the bottom: input.Total = (input.Total + input.FIELD1Value); field 2 value etc.. This works fine and when I tab out of field the total updates. BUT.. If I go back to FIELD1 and change the value it adds this new value to the total also, so my total is way off as it has not reduced the initial value. Can someone
Application Database Alternatives
I would like to create an application using Creator.......my issue.....my application database will be very large.....using Creator's database could get expensive....is it possible to create a appliaction within Creator and leverage Z Reports as my database....or any suggestions.....also are there limitations using databases other than the Creator database? thank you
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
How do you reference the value represented by a bidirectional field?
I'm trying to wright a custom schedule script that references the email addresses to send to, from a form where the email address is populated from a bidirectional relation. My script errors I assume because it is receiving the ID number from the bidirectional field instead of the actual email address value I have the child form display. Here is the code I'm trying to run: temp=""; for each x in CRS[Received == false] { temp = x.Report_Type; for each e in Test_Staff_Roles[Notice] {
Zoho Reports within Zoho Creator Tab
Is it possible to embed or <iframe> Zoho Reports within a Zoho Creator Application Tab? (not a report,chart or dashboard) But the ability to use the functionality of Zoho Reports within a Creator app... To give my users a more seamless experience? Both products are great....
Modify existing record and save as new record.
Is there a way of opening a record in edit mode and saving it as a new record? What I want to do is use the data from an existing record, modify it, and save it as a new record in the table. Any help would be appreciated.
Zoho Creator Payment - pass other data to PayPal?
When I use a payment form option, is there any way to pass additional fields through to PayPal besides the Item Name, Quantity, and Amount? We are trying to track all of our PayPal purchases through the use of SKU's (stock keeping units) corresponding to our internal account numbers, so I'd like to be able to pass an Item ID field through to the PayPal portal. Any way I can do that?
Update 2 rows on another form on submit
Hi, I have a form "movements" and another form "Stock" with different locations. When user enters 200 for "Item A" in form "movements" I would like to reduce the qty of "Item A" in form Stock for that item and location, and increase the qty of Item A in another location. Stock type will be chosen on the movements form. Stock will always originate in the same location and end in same destination. I tried the following for on submit, on success: if (input.Stock_Type
Next Page