Show/Hide field in report using parameters in URL?
Hi Zoho, Can I pass a parameter to a report so it will show / hide certain fields? -OR- can I use a variable for the field name when fetching data? (Entry.variable)? Thanks Ravid
Accessing master table between apps
Is it possible to have a common master table in Creator which can be accessed by different apps (all in same Creator account)? The situation I have is like this: 1. A master customer data set - loaded manually through csv import - with geographical segregation codes 2. After verification, data is seperated into different 'views' based on geographical codes. 3. A seperate app (within same Creator account) then access the data and follow additional work flows The reason I want to seperate the data
Unable to publish my apps to Market Place
Hi, I am unable to publish my apps to market place. In the Developer Zone , I do not get that button to publish to Market Place. It allows me to publish an app to a client but not to market place. I have written to ZOHO support but so far they have not responded. In case anyone has faced this problem earlier, please revert with the solution. Please see the screen shot attached. Thanks, Milind Manohar
Problem in inserting Records
Hi, Please see the screen shot attached. Here R is a set of records, which I am iterating thru using "rec" as collection variable and inserting into another table (form Depreciation Details). Even though there is no apparent syntax error, please see the error thrown up. Please help if you can spot the mistake. Thanks, Milind Manohar
External customers
Hi, Is it possible that with Creator create an application that people can use by creating their own identities by using for example Hotmail, Gmail accounts and so on?
Http request from an external site to Zoho Creator
Hello Experts! I'm trying to make a http request from an external site to Zoho Creator. I can only write on Javascript. Please, what is the most direct way to make this request? I was trying to use the XMLHttpRequest with a getURL (), but it returns "No 'Access-Control-Allow-Origin' header is present on the requested resource." I think CORS is not supported on Creator. A lot of thanks in advance. Best regards. José.
How to convert string to number
Hi, How do I convert String to Number. Which function should I use ? Pls. help Thanks, Milind
Get Invoices From Zoho Books To Zoho Creator
I need create a lookup field in Zoho Creator to locate all invoces with a balance due in Zoho Books. I currently have: invoiceslist = zoho.books.getRecords("invoices", "936496201", "invoice_number"); Invoice:ui.add(invoiceslist.get("invoices")); under the 'on add' 'on load' and I'm getting a drop down that includes all invoice details in the lookup field ({"date":"2016-12-4","Zcrm_potential..... etc, etc.). I just want INV-XXXX to show up in the field then populate "Client Name" and "Amount Due"
Apps getting added as "Shared"
When I press New Application and add the Support Desk app it is not showing up in the "Owned by Me" section... it is showing up in the "Shared with me" section. I want to remove the apps but i don't have access.
AddedTime not available in Pivot Chart?
I noticed none of the system fields are available in the Pivot Chart. Why is that? I just want the AddedTime to go on my x-axis of my chart. See screenshot: http://screencast.com/t/OM6irV9A
zoho creator calendar showing date ranges not discrete dates?
I created a form that allows a user to enter a date and then also shows additional dates some # of days after that. So the form may have multiple dates in that record. That all works fine. However when I view the Calendar report the entry shows up as a range across those dates. Is there any way to have them just show as discrete entries on each date in the form and not including all the dates in between?
Creator embed report size
Hi There, I have been searching hi and low and need the best way to do this. i have a report that i want to embed into a page in creator. when i Embed the report. It doesn't take the formatting that the report has. and only shows it in a half page window. Can someone help me get around this Cheers
cant edit load function
Hi, I am new in zoho creator. I am not able to edit onAdd -> onLoad. I have written some record fetches on onload.When I open this, the entire page got stuck. While I can open other sections after reloading. Problem is with onLoad. How can i get back old codes from onLoad. Any idea as to why this happens? How do I fix it?
why changes are permanent when grouping a column of emended report?
hi, i have created a embed report to a html view page . i am not writing any code for grouping and not done any settings at report group & sort section of the report . now the problem is: i group a column as "Group by Asc" and this changes permanently .it's not changing to it's normal page view when refresh the page .? why it is happened ? waiting for reply ... Thanks, Suresh Kareti
Problem fetching record when using lookup fields as criteria.
I will appreciate your help in directing me to a solution. I have spent hours with no success. I have four forms: frmClients - stores the ClientName and SocialSecurity of clients. frmProperty - stores the PropertyName, address, phone, etc. of properties. frmContract - consists of a Lookup field TenantName based on the frmClients, a Lookup field PropertyName based on the frmProperties, and other fields like amount, initialdate, taxrate, deposit, etc. frmInvoices - consist of a Lookup field UnitName
Get Record by ID: Variable 'Product_ID' is not defined
I am making an app that uses the following code to record products from the Products module in CRM But I get this error: Error at line number : 1 Variable 'Product_ID' is not defined crmResp = zoho.crm.getRecordById("Products", input.Product_ID); input.Unit_Price = (crmResp.get("Unit Price")).toDecimal(); input.Quantity_Available = (crmResp.get("Qty in Stock")).toLong();
Pivot chart based on views
Hi. Can a pivot chart be based on view or multiple forms, rather than a single form. I am sure it was previously available. Thanks.
Auto Fill URL with Field
Hello, I am developing an order management system that requires each individidual record to have a barcode/QR code so that they can be scanned to bring up information at certain points along our manufacturing cycle. I have created a 13 digit autofill number for each record, and I would like to retrieve a QR code using that autofill number from an external website, however I don't know how to input the field name into the URL so that it automatically fills this part of the URL with the records Autonumber?
Report hang when scrolling
Hi, I noticed the new enhanced feature on reports, there is no paging any more, but when user's scrolling down to the end of the screen, the report fetches more records. However, this ALWAYS causes screen hang. I have a report with around 40 columns and less than 3000 records, every time when users scrolling fast, the screen will be frozen, and IE will prompt that "the scripts takes long time, stop it?". Moving back to the paging style shall be helpful. Or, please help to fix this defective. Thank
Creating relationship between form and subform
Hi all, Please excuse my ignorance as I am very new to Zoho and while for the most part the user interface is very intuitive, the deeper possibilities with coding remain a bit obscure to me as my knowledge in that field is quite limited. Essentially what I am trying to do is create a database for storing information about lectures. This database is very simple and I have designed it using only two forms: talk and excerpt. Whereas a talk can exist without any excerpts, every excerpt is part of a talk
Zoho Creator EU edition
I started using Zoho Creator in zoho.com domain, but due to regulatory reasons opted to move to zoho.eu domain. A lot of functions we see in zoho.com are not yet available in .eu account, almost a beta version of .com. Is there a time line when the full functionalities of .com will be available in .eu domian? Thomas
Many to many relationship with note field for each relation
I'm trying to create a many to many relationship while storing some information about that particular relation. For example: A SurveyQuestion has many AuthoritativeSources. When an authoritative source is chosen for a question, the rationale (or justification) for the selection should be documented in a note. An AuthoritativeSource can be used in many SurveyQuestions. In a database this would be represented as: SurveyQuestion >-< AuthoritativeSource SurveyQuestion - ID - QuestionText AuthoritativeSource
Creating a page to display record counts by field criteria
Greetings all, I did my best to find the answer on my own.. here's what I've got: I have a Creator application with a bunch of records with different "Statuses" by field. I want to create a simple page in the application for my users which would provide a summary of record counts by "Status" Example: Status field values: Pending, Paid, Cancelled Page/Report desired: Pending: 37 (records) Paid: 31 (records) Cancelled: 12 (records) From what I'm gathering, this can be done
Can table names be programmatically referred to?
Hi, I would like to store zoho creator table names in another table and then uses those field entries to access specific tables. Is this possible? Thank you.
For Each Record - need help with criteria
Hi guys, Could you please help with this? BACKGROUND ---------------------------------- We have a form called "New Claim". The form has a field called "Today_Field". It also has a field called "Status". SCHEDULE ---------------------------------- We have a daily schedule set up which updates "Today_Filed" with current date. The code is below: for each r in New_Claims { r.Today_Field=zoho.currentdate; } THE PROBLEM ---------------------------------- Right now, the schedule iterates for all records
Access desktop ip cam or webcam
Does anyone know how can I access the desktop IP cam or web cam with Zoho? Thanks in advance, Mauro.
How to display auto number field?
How do I display an "Auto Number" field I created in a form? Can I generate this auto number at time the form is loading instead of on Success of completing the form? Is this why the Auto Number field can not be displayed to the user? Sorry I am new to this, any help greatly appreciated.
Auto Update of Form
I have a form in a Zoho application that is only used for information i.e. no updates are done in Zoho. The data is kept in another application. I have had the application export a .tsv file of the data needed in Zoho, and when I delete all records and import the .tsv file, it works perfectly. The client wants to automate this. Is there any way to have a Deluge script that runs say at midnight to delete data in the form, then import from a file? Maany thanks
CRM custom functions: Update fields cross module based on look-up field type
Hi there, We are linking our products records with our contacts records using a look-up field between products and contacts module. Is it possible to (via a custom function and workflow automation) update a field in the product record based on a value from the contact record associated to the product record via the lookup field? Kind regards, Bo Thygesen
Adding record with multiselect using Creator API
Hi, Is there an issue in adding records with multi select fields using Creator API? I can add the record if there is one option selected but doesn't allow me when there are multiple options selected. This is part of my PHP code $opts = explode("##", $form_data->contractorOptChk); $this->XMLString .= "<field name='fieldname'>"; $this->XMLString .= "<options >"; for ($j = 0; $j < count($opts); $j++) { $this->XMLString .= "<option>" . $opts[$j]
Give a scroll bar to a text field in a view?
Hi, I have a text field for notes in my form/view. When there's a lot of text entered into it, the row becomes quite high of course. Is there any possibility to provide the field with a vertical scroll bar or at least to limit the height in the view? Thank you. Jens
Charts and Graphs not forming after a certain date
I've created an application, regarding booking and collection in taxi services, I generated some reports too, but after a certain date i.e. 13th October the charts and graphs stopped taking data from the reports. And posing difficulty for us in analyzing the data. Pls. tell what might have gone wrong.
Zoho improvements
Zoho is fantastic. I think it could become perfect if anyone reach these features: treeview google maps or other maps integration I hope, thanks!
Trying to create a stateless search form
I'm trying to create a stateless search form with the instructions on this help page: https://www.zoho.com/creator/help/application/search-interface.html I'm not able to completely follow it though because it uses the code example from the old employee management app: https://creator.zoho.com/sampleapps/employee-manager/#Page:Dashboard I can't add that app anymore to my account and see the original code. The help article only has snippets. This is a frustrating thing in general that much of the help
Rest API Help
Hello I have just started working on a portal to add records to Zoho Creator. I have successfully added records, however the page automatically downloads a json file with the data I posted. How can I stop this from happening?
How to Use a Custom Action to Invoke a Function to Send SMS/Email to Users selected in a report?
Hi Everyone, I would love some help with the logic on how to accomplish sending SMS/Email to many users selected in a report, then using a custom action to invoke a function. Here is what I have: My Report: As you can see I have many "Users" (Email, phone etc.) for each row. When I create the custom action I cannot pass the ID of the user, instead I am limited to only pass the ID of the "Delivery Location". Question #1: How do I create a "for each" loop that gets the ID's of the users after passing
Problem with purchase to Zohocrm from Creator
Hello all, i have a code to create a purchase order in zoho, work in generally fine, create the PO in zoho, but dont add the product detail.. i dont know what is the problem, if i dont send all data requirement or is a wrong format.. respuestaPO = zoho.crm.create("Purchaseorders",{ "Subject" : (("" + infoso.get("Numero de orden de venta")) + " t4 ") + infoso.get("Subject"), "Status" : "Created", "Vendor Name" : "" + infoso.get("VENDORID"), "Orden de Venta_ID" : "" + infoso.get("SALESORDERID"), "line_items"
Copying value of image field to another image field creates a broken link
I have a form that has five visible image fields and three hidden image fields. There are five check boxes that are used to select up to three of the five photos to be displayed in the report. In the OnSuccess action I have the following code: input.Hidden_Report_Image_1 = null; input.Hidden_Report_Image_2 = null; input.Hidden_Report_Image_3 = null; if (input.Include_Image_1_In_Final_Report) { input.Hidden_Report_Image_1 = input.Image_1; } if (input.Include_Image_2_In_Final_Report) { if (input.Hidden_Report_Image_1
Sync Google Contacts with Contacts in Creator
Is there a way to sync my contacts from in my creator app with my google contacts? Is coding with APIs the only way? I know some deluge but don't understand how to use the APIs.
Create multiple events concurrently
Hi, Any idea how can I program to create multiple events at one shot at fixed intervals, instead of creating one after another. Such that, the form allows users to select the frequency of the event (E.g. Daily, Weekly) and the number occurrence (E.g. span of 8 weeks). Gerald Lim.
Next Page