Changing column width in PDF report?
Hi Zoho, I have an email with a PDF rent every week to certain users. How can I set the width of the columns in the report? Adjusting the column width using the report "column properties" views ok on the browser it but on the PDF all column are distributed evenly (not the preferred option) Thanks! Ravid
Check if all the fields are full
Hi, I have a form that has 80 number fields. I want to check if all of them are full and then send a mail. I know I can do something like: If ((field1 != null) && (field2 != null) and so on until && (field80 != null)) { sendmail } Is there an easiest way? without having to write 80 times the condition.
Custom Modules
Hi.. I am trying to retrieve a record from a custom module in CRM. However, when I try to read the individual field values I am just getting null values. In the example below r1.get("customer") returns null value, is there a naming convention i'm not aware of ? crmResp = zoho.crm.searchRecordsByPDC("CustomModule2", "customer", "xyz123"); if (crmResp.size() > 0) { for each r1 in crmResp { input.Customer= r1.get("customer"); } } else { alert "No machines
custom button on stateful form
Is there a way to include a button or hyperlink on a stateful form that would enable one to call a function in the manner of a Custom Action on a report? I understand that you can do it on a stateless form, but stateless forms are a lot of extra work for such a simple request.
Javascript forms to Creator ?
Hello I see CMS like lightcms provide html,css & javascript ability to design the site, Can I create forms in JS to send / receive data from Creator & CRM ? Thanks Fahad
Need Help :How to pass/retrieve the values from query string
Hi, How to pass the values by using querstring and retrieve it in another form.
Integration to Mercadolibre with Post url Task
Hello, I would like to make an integration to Mercadolibre (ebay mexico). At the moment I want to do something like update some basic data but I do not get it to work and I want to know if the code I have at the moment could work ... http://developers.mercadolibre.com/products-sync-listings/#Update-your-item I try to integrate with third party apis using get / posturl tasks. I recommend it, I'm not sure if it is possible. Header_map = map (); Header_map.put ("Content-Type", "application / json");
Pivot table filters old data?
Hi! So to explain this easy: I have a form with columns and rows. The row has numbers (ID) and a column value which can be set to true or false. Entry with ID 1 has the column set to FALSE. When I filter the pivot table that I only want to see the entries which are marked as TRUE - it shows up. As TRUE! Even though it is not. In the Zoho Report popup Windows the value is TRUE But when I check the list - Its FALSE. Seems it has cached some old data? Is there a way of fixing this without having
Is it possible to integrate creator with zoho projects?
I would like to integrate creator with zoho projects. Is this possible?
numbers into words
Hi, I have decimal field in a form.I need convert that field number into words(for example: 123654=one lakh twenty three thousand six hundred and fifty four).I try to write a function to convert that number into words but it didn't work.I also referred in zoho forums for that,But It has a code for international numbering system(BILLION,MILLION) ,not for INDIAN NUMBERING SYSTEM(CRORE,LAKHS). kindly help to write solve it. Thank you.
Public Zoho creator page
hi everyone - was wondering if I could get some direction on a zoho creator page...I have the report ready to go, but in order to have it look like I want to with the custom css, I need to have it embedded in the zoho creator page itself. However, when I go the Publish option under the Page/Settings/Publish, it gives this if I am not logged in: This report is not accessible. Sorry Public, you are not allowed to access Featured_Resorts. Please contact your administrator to get access. I assume this
concatenate text fields with hyperlink fields
Is it possible to concatenate text fields with hyperlink fields? I have 4 fields: text1, text2, text3 and hyperlink. I need to have them together as: text1 + text2 (with the hyperlink hided) + text3.
Calculate distance betwwen two area
I hv plan to create app for car booking like OLA,UBER. Is it possible to get source and destination place from map and calculate the distance b/w two area. Pls Suggest any idea to make this app.
I seem to have locked myself out of my own app
I created an app under my personal account then authorised my work email address to be the administrator and demoted my personal account to Manager. What has now happened is that regardless of which account I sign in on, it reverts to my personal account and tells me I am not allowed to access the app. I had expected that my work email address would become the CEO/Administrator and I'd go from there... I realise now that I should have kept my personal account status as CEO and left the work account
How to display image from previously submitted form
Hi, I am trying to display last submitted image in current form. Coll = Form [ID != 1] sort by Added_Time desc; input.ImageBox = Coll.ImageBox; Nothing happens unfortunately. On my mobile it shows loading .....
Is there "record" data type I can use to transfer records between applications?
My goal is similar to "Fetch data from related form" in this tutorial: https://www.zoho.com/creator/help/script/fetch-records.html#Fetch_Records ... except the related for is in a different application, not the same application. There are a bunch of questions already asked, such as this one, which is almost identical to my situation: https://help.zoho.com/portal/en/community/topic/problems-learning-how-to-fetch-data-between-applications Except I'd like to get a bit fancy, and instead of retrieving
Has anyone else had deluge scripts disappear?
I am having a major problem where some of my deluge scripts are randomly disappearing. It's not all the scripts in an app, just very specific ones. I have asked Zoho Support about this multiple times but they are unable to replicate so say they cannot help. But it's definitely continuing to happen and becoming an increasingly major problem for me. I saw this forum post: https://help.zoho.com/portal/en/community/topic/disappearing-deluge but the solution there was to not use comments. I am using no
Urgent: customer portal displays blank page
Hi, The 'customer portal' link for my Creator app displays a blank page. I really need this to work. It worked fine yesterday. Does anyone have any ideas about what might be going on? Thanks, Robert
Trouble displaying script value after entering data
I have a subform that I enter string data into 5 fields per record. So for example, size, color, shape, texture, durability. I would convert the data in each of the 5 fields into an integer that equals 1 only if it matches a particular entry using a series of if statements. So if the size is large then it gets a score of 1. If the color is red it gets a score of 1. If the shape is circular it gets a score of 1. If the texture is smooth it gets a score of 1. If the durability is high it gets a score
Hide Null Field in Report Summary
I've got a form with many fields, but not all of them will be populated, in fact most won't. I'd like the client to receive a nicely formatted report summary PDF via email showing only the values of the populated fields. Is this possible in Creator?
Display records on the same page, using URL parameter passing.
I have 3 forms: 1. User_Form 2. Booking_Summary 3. Display On my User_Form, I have the following fieds: 1. Name - Deluge name: Name 2. City - Deluge name: City 3. Check In (24 hours) Deluge name: Check_In1 of type Date-Time 4. Number of Rooms - Deluge name: Number_Of_Rooms On my Display Form, I have Name as my lookup field from the User_Form. 1.Display - Deluge Name: Display_Booking lookup from Name field in User_Form 2.Show Booking - Deluge Name: Show_Booking input type Submit button. Here's
Zoho creator license
Dear All, I am new to Zoho and just going through the tutorials to consider developing an app for my own business. I want an app to collect daily reports data from my employees at different remote site locations. So my employees only input data into the forms that I create. I need the employees to have access control to login using their credentials and have restricted access to the forms based on the login credentials. Now to do this kind of setup do I need all my employees to be paid users (with
ZOHO Creator - Customer Portal
Is there a way to send a sign up email from ZOHO CRM for the zoho creator customer portal ? Will I be able to use the send email function and send the sign up url ? If yes could you help me with the sign up url ? Regards Jayasree
Is it possible to use a custom function or deluge scripting to export and email?
Example: I have a stateless form that the user enters their email address, a start date and and end date. I want them to be able to select the custom button and it send the email address entered a selection of records from a form based on the date range selected? Is this possible?
Zoho creator - create invoice in quickbooks
I have successfully created a customer record in Quickbooks from zoho creator. I am now trying to create a invoice for the customer but I am getting the following error {"Error":[{"Detail":"Property Name:Can not deserialize instance of java.util.ArrayList out of START_OBJECT token\n specified is unsupported or invalid","Message":"Request has invalid or unsupported property","code":"2010"}]} I am not sure what is the unsupported property.I would appreciate is someone code post a sample of the Quickbook
Function that prompts for date input
I am trying to create custom function that I can use in a report to: 1. Prompt for a date 2. Will mark selected items as "Ordered and Received" on the specified "Order Date" This works, if I want to set the order for today. But is there a way that I can modify this so that the function will prompt for date entry? void SeedOrder.MarkOrdered(int id) { rec = Seed_Order [ID == input.id]; rec.Status_of_Order = "Complete"; rec.Date_of_Order = today; }
Default entry of today's date without an script?
Is there a way to make date fields in a form default to the current date without an script? I need to do that in order to use the offline functionality to upload the fields in the zoho creator app. Thanks
Button label error: ui.label.done, ui.label.export. How can I Change that?
A wrong label appears in the zoho creator app. Can I change it? Please see the attached screens.
Report data hidden from view if auto-filter is disabled when an auto-filter is currently selected
Just a head's up for a clearer user experience. If user is viewing a report and selects an auto-filter. Then user goes to the application report settings and disables that auto-filter. Then user reloads the application report. User is no longer able to see report data (presumably due to the report 'saving' the auto-filter as part of the current way of displaying the data). Report should remove auto-filter that have been selected from the user's report view when admin disables the given auto-filter
Can I somehow remove 'old fields' in pivot table view?
If I change "field type" from numerical to decimal in a zoho form, it creates the following "redundant" fields in pivot table report settings (see screenshot). I'm just wondering if it is safe to remove the 'old' numerical fields and if so, how does one remove them? Thanks. Brady
Is there a limit to the number of months that will show in the date auto-filter?
I have data in an application with a date field from Jan-2012 through Feb 2017. Auto-filter by date is enabled. When looking at this filter in my application report, I only see options to filter by month from Jan 2012 - March 2016. Is there a reason for this?
Insert data into a table
Hi, 1) I want when a Sales Order in in Zoho Book is successfully created, this should trigger the insertion of an invoice (invoice data) into invoice table. All the data requuired for invoice will be extracted from Sales Order. 2) Is it possible that a scheduled routine insert a single(Batch) invoice for multiple (uninvoiced)Sales Orders, in order to reduce entries. Regards
Insert data into first column of subform?
Hi I have a form which contains 10 test points, I would like these test points to be loaded into the first column of a subform. Is it possible to enter the information onto 10 separate rows?
Report showing a decimal form field as Single Line.
I have a few fields that are decimals in my application's form but are (I believe) being presented as "single line" or some other field type when I try to create a report. See "Bakery" field - It is a decimal in the form in screenshot 2, but has a "Capital Letter T" next to it in the create a pivot table/chart report field list (screenshot 1). I can't "sum" this field on a pivot table so it seems quite clear that zoho doesn't think it is a decimal field...even though it has decimal content in the
Setting a Field Value based on defined Ranges
I need to set a field value in a table based on a set of aging buckets. For instance. Set Aging Bucket to 1 if Days_Outstanding <=14 Set Aging Bucket to 2 if Days_Outstanding >14 and <=30, Set Aging Bucket to 3 if Days_Outstanding >30 and <=60 Set Aging Bucket to 4 if Days_Outstanding >60 and <=90 Set Aging Bucket to 5 if Days_Outstanding > 90 Can someone help me with how to code this? I need to set it up as a workflow based on the value in the Days_Outstanding formula field. I appreciate it.
Edit/review Email after submiting a record
Hello! Everytime I submit a record, i would like a popup to appear with an email template, that let's me edit/review the template before sending. Im aware that there is a "send mail" script that can send an email immediately after submiting a record. But I would like to be able to edit/review/cancel the email before sending it.
Bugs: Zoho import changing field type from decimal to numerical, pivot table error when processing numerical/decimal field
I thought I resolved all the quirks around zoho creator's import function somehow 'creating' its own decimal data (see this post: https://help.zoho.com/portal/en/community/topic/bug-zoho-import-create-app-from-xls-makes-too-long-a-decimal-from-number#2266000009001481 ), but it appears the issue is still around somehow. In trying to resolve this oddity with pivot table/chart reports: https://help.zoho.com/portal/en/community/topic/report-showing-a-decimal-form-field-as-single-line I decided just to
TOTAL NOOB - How do I create a drop down menu that opens a check mark form?
Hi there! Ok, so here's my wish: I have four brands of wine. Within those four brands there are a whole bunch of different types of wine (Cab Sauv, Merlot, etc). I'd like to be able to select a parent brand via drop down and then have it open the various wines under that label so that I can select them with a check mark box. Hope that makes sense. Really appreciate any help. Cheers!
Record Owner field is not being honored by the Charts
Hi, I have a "New Order" form, in which I designated the "Record Owner" field to be "Owner" instead of "Added User". See the attachment for some sample records and the Record owner setting screenshot. The record was added by andrew.raymond and is now owned by lexshan8. lexshan8's Role is CEO andrew.raymond's Role is COO, which reports to CEO. Therefore, the record should NOT be visible to andrew.raymond. In reality, andrew.raymond is able to see the records. On the other hand, records with Owner=andrew.raymond
Link a record to a record?
Hello! I would like to edit/update a record on edit/success of a form. The record that I want edited/updated, is in the lookup field of the form itself. Below is a picture of the form "ADD". The first field is a lookup field to another form called "Clients1". This is the picture of the form "Clients1" When I click "submit" on the "ADD" form, I want to link the "ADD" form to the client when I see the client in "Clients1" report. Below is a picture of the "Clients1" report. In human language, when
Next Page