Report Builder: Section Border lines broken
I really like the Report Builder for generating organized reports. However, I am frustrated that I am having problems with using a border around sections. When displayed in the browser it looks fine with neat lines around each section. But when I go to print or save as PDF the lines are sometimes broken or have an inconsistent thickness in certain places. It seems wherever I have a label on the left with a white background it somehow interferes with the borderline which is supposed to go around it.
Migration Tool record update problem
Hi, I'm using the Migration Tool to update records in my Creator application. The upload worked, with a success notification. However, when I log into the application and look at a Creator report listing those columns, the data has not been updated. What am I missing?
Sendmail doesn't work for certain domains?
I have a Sendmail statement at the end of an onClick action of a button on a stateless form. I have found when testing the system that when the email address is a gmail account, the email arrives as expected. But when I send emails to addresses in our own domain (eg. bob@mydomain.com) they disappear - no errors, no spam, not caught in the email filter. They just vanish. Any ideas about potential causes? Settings on our exchange filter that would block these? Thanks, Peter
Restore Backup failed
I am trying to restore a backup of my app, but all i get is: "Restore Failed - Error Occured"
Not able to share app???
When I try and share an app I have created, I keep getting this error message: "To share more users Upgrade your user plan". But I am only trying to share it with one person, which is supposed to be allowed on the free version. What is going on?
Share App
Hello, I have an app that is shared with my client, he can see the app in his Shared Apps area but when he try to open the app he gets the message: You are not authorised to access this view in Zoho Creator. Go to Home How do I fix it. ThanksRodny :)
Field Permissions
The following link has the feature I want to work with, but the directions don't match my application.... https://www.zoho.com/creator/help/security/fields-and-links-permission.html I can't find any setting about Field Permissions....
Cannot Use Global Search
I am new to Zoho Creator. I have the Enterpise level subscription. I created an application and loaded some data. I taught my time how to use the global search to enter a first name, last name, etc and have it pull up a record. Everybody LOVED it, so I uploaded some data. NOW..the global search does not work. My team is having to use the search by field from within the report, which works but it's clunky. I reviewed the help topic for global search. I've used settings to Show Search Box and clicked
Dynamic VLOOKUP and Summation Calculation
I am trying to do the equivalent of a series of excel VLOOKUPs. I have uploaded a dataset where column A is "Car_Model", column B is "Car_Cost", column C is "Insurance_Cost". I'd like to only use "Car_Model" as an input (via a drop down) and then show Car_Cost, Insurance_Cost and Total_Cost (a sum of the two) as dynamic outputs. By visiting a few similar posts on the topic, I understand that I need to use a "fetch" here but I'm unclear on how to implement it. Thanks a lot! Sam
Making every checklist line a hyperlink
Hi, I'm trying to create a checklist where every line is also a hyperlink to a file in the Google Drive account connected to the Zoho Creative account (each line refer to a different file). Until now, with no success :\ Help? Thanks! Ravid
iCal Feed with single date event
Hi - I'm using this GUIDE to create an iCal feed for a task report. The URL is being accepted into google calendar, but no records are displayed. Because the deadline for the task occurs on the same date, I am using the same field name (Deadline_Date) for DTSTART and DTEND. Below is what one of the entries looks like when I paste the url into the browser, and it seems to be be pulling the data from the report...any idea why not showing up as calendar entry in google? BEGIN:VEVENT DTSTAMP:20160210T214625Z
Update same field for other records based on edit to the field on one record.
I have a form called Orders with 3 fields: Project Number (Single Line), Customer Name (Single Line), Sequence (Number) I need to set and change the order in which we will do each job regularly, hence the number field called Sequence that I sort records by. Example starting data: 100101 Good Customer 1 100105 Other Customer 2 100106 That Customer 3 100110 Excellent Customer 4 100112 Best Customer 5 I'm looking for a deluge code to attach to
reorder subform
hi, do you have a solution to reorder lines in a subform on a specific field ? thanks you
Fetching a Main From record from a Sub Form
I have a form in which users submit information on a Main Form, and include entries regarding completed service projects in a Sub Form. What I'm looking for is a way for each of the Service Project records to "fetch" their Main Form. In the Main Form, the list of Service Project subform entries would be a List of the record IDs of those entries. So, in the Main Form the subform is called "Service", the record ID I want to match back to the Main Form is record_ID. When I try to run a fetch like s
Can I delete the automatics reports?
Can I delete the automatics reports on zoho creator?
Are alert messages translated automatically
I'm planning my project and would like some additional information about the translations functionality listed here: https://www.zoho.com/creator/help/application/translation.html If an application has multi-language support enabled, do alert messages that the developer creates get translated automatically? Can custom translations be created for alert messages or just field names? Are the contents of fields translated? Thanks, Marcos
Zoho Reports data into Zoho Creator
What is the best, or really any way, of pulling live data from Zoho Reports into Zoho Creator. I'd like to query tables in Reports and pull specific info out into Creator. Thanks
Not Able To Add Subform Record in Mobile App if Hidden Via Automation
Not sure if this is the exact problem...but removing my subform from being hidden through automation and just writing with hide on load deluge script allowed me to add records in the app.
Trigger date field update when another field is completed
I am hoping this is a fairly simple request, but, I can not seem to find the solution in documentation. Here is the scenario: Object has two fields: Date Joined and Date Hours Due When a member joins, they have one year to complete volunteer hours. So, when a value is entered in Date Joined, I would like Date Hours Due to be populated with a date value that is one year later than Date Joined. Now, here is the catch. Sometimes, members get extensions. If this is the case, the Date Hours Due would
Line break in Multiline text when sending mail
Hi, I have an issue with the line break in the multi line text box when sending mail. 1. The line break does not work, because line breaks is "deleted" and it shows only a long line of text. This is very inconvenient, as the lack of line break renders the text introduced unreadable. I have tried both HTML and PLAIN text messages. Are there work arounds for this? 2. I manage to maintain the line breaks using templates. The problem I have with this is a bug in Mail for iOS, where the message is truncated
How to detect maximum number of executable statements per deluge action
How do I detect if one of my users has reached the maximum number of deluge statements limit so I can have them contact me so I can manually update ranges of records for them? What's the best way to notify the user and log the event? Is there a way to test a function prior to execution to determine the number of deluge statements it will consume? If I call a function that has 2 statements, would that count as 3 statements? This is the case I am trying to solve for: I have an application that groups
Exclude fields from update on edit
Really could with some help if anyone knows the answer to this :) On Form A I have the following bit of code in the "On edit > On Success" which updates Form B when Form A is edited: for each item in input.Products { inv = Product_Inventory [ID == item.Product_Name]; inv.Available_stock = (inv.Available_stock + item.Quantity); } However I have 2 fields that I need to be editable on Form A that do not update Form B when being edited. Does anyone know how I can keep the above code in On
How to recover deleted application?
Hi all, Is there any ways to recover an deleted Application? Any "Undo" button? Tks!
Es posible generar un documento PDF con Zoho Creator?
Me gustaria generar un documento PDF con ayuda de Zoho. Yo envío correos automáticos a mis clientes mediante el uso de Zoho.Quisiera saber si es posible convertir ese formato a PDF ya sea para descargarlo o enviarlo por correo electrónico. Gracias de antemano,
More multiline problems
This public application I just published, "Multiline Test", exhibits the behavior previously noted by ghennessy, but on a more basic level: The application consists only of one form with one multiline field. The form on load event attempts to set the multiline field to this: "foo bar" but the presence of the linefeed in the text is preventing the form from rendering at all. This is a new bug, the above application construct used to work fine until very recently. Thanks for any assistance. Regards,
Disappearing Deluge
Hello - I will find my application not working correctly, go into edit, only to find my deluge script on a particular field completely missing. It seems only to be happening on subforms - and it may have only been happening after I added //comments to my script. I am going to remove the comments to see if that alleviates the problem. Has anyone experienced this or know the reason this is happening?
how to install DKIM & SPF for sending emails from zoho mail servers with my zoho admin login?
Hi send emails from app recipient's mail servers say that email was send from untrusted domain and mail servers can't check trust of sender's domain zoho admin login is from "@yandex.ru" mail domain and email sent from zoho mail servers recipient's mail servers say that i need install DKIM and SPF how to solve this task, so that recipient's mail servers will trust my emails?
Give access to form but only allow them to edit one field
i have a database of clients that i want the sales reps to be able to edit the comment box but not allow them to edit the other fields such as the address etc. Is there a way to give them access to the form but only allow them to edit one field?
ZOHO Creator to Quickbooks
is there an API that I can use to integrate ZOHO Creator with Quickbooks?
Insufficient Privileges to Perform Operation
I have written a Creator Database for demonstration to a potential client. It is simply a database of Sales with links to the Customer and Product (in CRM) database. However whenever I click on either entity it does not go to that record (as I would expect) but opens a new tab with this error message. I have produced a screen shot of this (attached). Thanks for your help. Peter
Question about the new Zoho Creator Version 2015
Dear All, I saw from a presentation which you have done in Zoholics (California 24-25 Febr) that you work into the new version of Zoho Creator (with new feuatures). https://docs.zoho.com/show/present/9fmva00453c8012f041f3aaefb9a17a94d08a My question is (maybe and other companies will have the same question with us): When these new features will be online? I do not want to tell me the exact day but a range for example June- November. The reason why I am asking you is that my company creates a
Column Headings on reports
It would be very nice if the column headings on reports appeared on every page and not just the first page. Thanks, John Everling
How to show actual customer data in the report/portal before it's submitted?
Hi, i have got a question about the presentation of customer data. what i do: - report settings, summary - customer viewers - add criteria : Added user equals to Zoho.loginuser This shows the customer their own data after that is beind submitted, but... How can i show the customer data before it's submitted (based on their e-mail adres) something like this : Email_adres equals to Zoho.loginEmail how can i fix this?
Rookie Question on Calculating
Just trying to figure out how to calculate in this: I have a form that gets: Name Date Value Name is a drop down list of people Date is the Session Date Value is a whole number Want to spit out a report that Summarizes: Name Total of all Values <next name> <Total of all Values for this name> etc. I tried things like Total_Values = Total_Values + Values but can't do that. I've done programming in the past, by no means an expert and was some time ago. Pointers of what
Advice Required - Restaurant Booking Application
I have been scratching my head for the last hour or so, and am not making much progress on my latest App, and wondered if anyone in the community had any ideas..... Scenario : Application for assigning guests a table in the Hotel Restaurant. Guests arrive on different days of the week Guests might have a holiday duration of 2,3,4,5,6 or 7 nights There are 200 tables in the restaurant On arrival guests are assigned a table which they use for breakfast & dinner for the duration of their stay I already
How to save a date like a Visa Expiration Date?
I would like to save a date like the format in the Visa Cards. Something Like 04/19 Is there any way to do it?
Mass update Account for selected Contacts
Hi, I have a requirement that on a Contacts view you can select some Contacts and then press a custom button that will open a small window where you can select an Account and that account will be set for all selected Contacts. I was searching how can this be done but yet found no way of doing that. With a custom button for example I can open Zoho creator form but how to pass selected Contacts to that form? Or if I create a custom Zoho creator form to use it instead of Contacts view is there a way
Rookie Question - How to customize Auto ID number and make it shown while entering new entry.
Hi All, Would you please tell me how can I 1 Create an Auto generate ID number - Using the Country, the Year, month, and order VN 1603002 VN > Country relate to list choice field 16 > Year 2016 choose in the date filed 03 > March - from the date field 002 > the 2nd booking in that month 2. Would it be possible to make it shown while entering data or at list shown in the auto text appear after I hit "Submit" button. Thank you sooooo so much in advance :D
Prevent further data entry without "cancelsubmit"
I have a client form with a status field 'approved" or "not approved". In a second form "Repor"t: there is a Lookup field" that returns the value of of the client status. If the status is "not approved "I basically need to terminate data entry and gently boot off the user and get them to fix the client status. I do not really want to use the validate script on submission as it will annoy the user no end to lose the date entered after completing the form. I guess that i could hide all the fields in
licence for executing Schedules
Hi, Is it correct that schedules can only be executed on the paying version of zoho ? It is a little bit confusing as for other functions (eg sub forms) it clearly indicates this functionality is not available for the free version. However you can save schedules with no warning, they just don't run. Thanks
Next Page