Hide Grand Total but keep totals in Report
Hi there, I have a report which contains prices comparisons, which are grouped by suppliers/contract terms/... and I set up price totals for each group, which is what I want. However, in the report, I keep on getting a Grand Total on the bottom line, which I don't want as the purpose of my report is to give my client the opportunity to compare prices between different suppliers, so the Grand Total does not mean anything and need to be removed. Any advice on how to do that? Thanks Maud
Zoho Creator Emergency Maintenance - Dec 10, 2016 (07:00 PM - 08:00 PM PST)
We have scheduled an emergency server maintenance in one of our database clusters on Dec 10, 2016, between 07:00 PM and 08:00 PM PST. During this period of time, some of our users will experience service disruption. You could follow this post for updates on the maintenance. Meanwhile, we'll do everything we can to ensure the maximum up-time. We are extremely sorry for the inconvenience this may cause. Regards, Karuppuchamy
Can a custom action in a view/report be replaced with a button?
I'm embedding a Creator view/report in a website. The user selects records, and then user should select the custom action in the report header to update CRM with preferences they made. However, the custom action is not "easy to find" for a user and my client prefers a button. Has anyone come across such scenario and has solution? Any help would be much appreciated.
Disable entire subform
Under certain conditions I want to disable an entire subform. To hide the subform I can use hide name_of subform; But disable does not work disable name_of subform; Do I need to disable each field in the subform?
Name server zoho
Ho attivato il dominio, con il file sul mio server. Devo aggiungere il record MX, ma nel mio ospite mi chiede anche il nome host di Zoho, come faccio a trovarli?
Zoho Form - Retrieve Checkbox values
So I created a form online with 3 check box fields (A, B, C). Now I want to retrieve & display that data in the emailer using the field labels. If I just chose the checkbox label '${zf:Checkbox}', it returns all values and displays 'A, B' if the user chooses A & B. How can I retrieve & display the value A separately, B separately, and C separately? I want to be able to say, the user chose A on one line and B on another line.
Multiple "for each line" statements
Hi, I'm still learning syntax so i'm hoping this is as simple as rephrasing / combing, but i basically have a couple instances where i want to use an expression to apply in two different ways, but it seems i can't use "for each line" twice like this. (On load) for each line in Prod_subform { line.Previous = true; } for each line in Misc_Subform { line.Previous2 = true; } (On Success) subformContent = ""; subformContent2 = ""; for each line in Prod_subform { if (!line.Previous) {
crm mystery
Strange problem. We have a creator form with a basic lookup to zohocrm. It looks up a product and then displays the name in the creator form. Lately when we do this it shows the product look up but then shows the product code in the field. I am at a loss to figure thsi out. It has worked lovely for a couple of years. Do not think we made any changes.
Overview in the building zone
Good morning... When developing applications it would nice to have a table or database type overview of all the forms in the applications. Maybe even with links that indicate the lookup fields between forms. This has been asked for before but i can't seem to find an answer. It would really be helpful. Regards, stefan
change the display name of a field via script
Hello Zoho creator developpers, I want to know if there is a possibility to change the display name of a field depending on a condition. Something like: If (expression) { // set the display name of input.fieldDelugeName to "company adress" } else { // set the display name of input.fieldDelugeName to "contact adress" } That will save me having a lot of field that do the same and use theme everywhere other script with conditions. Thank you
Openscreen in Creator
hii, I am just new to appcreator. Can anyone explain how openscreen in appcreator is different from openUrl in creator? And please tell me about how to use the openscreen in custom screen and how the parameters should be sent to open a form or report?
How can I find out the number of related records in the child table
Hello How can I find out the number of related records in the child table? Thank you. only_relational_count = SubForm [ID == ID].count(); //not working
How to use GetURL to get a form's data?
Hi Zoho, I'm trying to use the GetURL task to pass a form's parameters. Unfortunately I don't have much knowledge in programming, and would appreciate if someone can explain this a little more: I Currently have a <form> in an html page, and I would like to send the data to a Zoho form, as a parameter. Where should I put the getURL task? and how should I write it? Thank you very much Ravid
Zoho Creator > Workflow > Set rules and tasks
I am creating app as seen in Zoho Creator Video, and having issues: https://www.zoho.com/creator/tour.html# Click on Video link (in the right) under “Automate Workflow” …. “Set rules and tasks” Go into Video at 21 seconds where it sets Quantity Greater Than 21 For some reason I do not have option under this dropdown in my portal. Will appreciate help. Thank you; Ramesh Kamath
Set the value of a lookup field
I have a form with a dropdown question and below that a lookup field. I wrote a code as below to set the value of the lookup field according to what is selected in the dropdown question above: if (input.Use == "R&D") \\ if R&D is selected in the dropdown question { input.Type_of_Sale = Types_of_Sale[Type_of_Sale == "R&D"].ID; \\set the value of the lookup field (Type of Sale) to the ID # of the R&D type of sale } Because it is a lookup field for the form: Types of Sale, I had to set it to the
Unable to use If condition in For each Rec loop
Hi, I am facing following problem while inserting records in a table. If I give any if condition in " for each rec in R " loop, I get an error. If I do not give any if condition then the loop works fine. Is it now allowed to give an If condition with For each Record loop. Pls clarify for each rec in R { if (rec.Dep_Method== "Straight Line") { D_Amt = (rec.Pur_Value - rec.ESal_Value)/rec.Exp_Life; } insert into Depreciation_Details [
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
change Admin for entire site with all applications
I need some assistance in changing the admin for my zoho creator site to another user. I will no longer be involved with any of the applications as I am leaving the company. For a specific application, it is quite straightforward. Can you provide step by step instructions on how to change the admin for the site and not just the specific application? Thank you Edith
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
Adding pictures in a form
Hi, I am preparing a quiz, and the question has 4 pictures from which the candidate has to select one picture. So, I need to include pictures in my question as well as in the choices. How can this be done? Thank you.
Importing only unique values from another form
I need to import rows from one form to another. The two forms share the common unique key; I want the duplicate rows during import to be discarded, and only the unique/new rows to be imported... how can this be achieved? Thanks!!!!
Database type view of forms
Good morning... When developing applications it would nice to have a table or database type overview of all the forms in the applications. Maybe even with links that indicate the lookup fields between forms. I think it would make it easier to navigate between forms and views compared to using the drop-down menu available today. Thanks,
Zoho Creator Tutorial #3 error message
I am working through Creator tutorial 3 and am attempting to write the deluge code to decrease inventory on success. Code is below: for each itemID in input.Product {productRow=Product[ID == itemID]; productRow.Available_Stock = (productRow.Available_Stock -1); } I am getting an error message stating "Only List Expressions are allowed to iterate, but (input Product) is of type STRING I am sure the code is identical to the tutorial and can't find why this would be wrong. Any help would be appreciated.
Update a Quote with Product details by specifying the Quote ID
Hi, I'm trying to create the application in this Example 2, but using the code given returns error Error at line number : 8 Field 'Product_Details' is of type subform and is not supported in update expression The given code as shown below; quoteDetails = map();
quoteDetails.put("Subject", input.Subject);
quoteDetails.put("ACCOUNTID", input.Account_ID);
productsList = List:Map();
for each product in input.Product_Details
{
Product_Details = map();
Product_Details.put("Product Id", product.Product_ID);
Product_Details.put("Quantity",
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
Is it possible to create this?
Is it possible to make a calculator like this? To help determine the freight class of your LTL shipment, enter your pallet dimensions and weight below for an accurate density calculation. Length (in) Width (in) Height (in) Cubic Feet Weight (lbs) Pallet #1 Pallet #2 Pallet #3 Pallet #4 Pallet #5 Pallet #6 Pallet #7 Pallet #8 Totals TOTAL DENSITY 0 lbs/cu ft FREIGHT CLASS N/A
Change date field to date-time
I would like to change the data type of a field from a date to a date-time data type. When I look at "field type" (located in appearance section), that option is greyed out. I have several hundred records saved so don't want to delete the field altogether. How can I go about making this change without wiping out the field?
marie.ange.occelas@gmail.com
Hello, I am a new user of zoho creator and I have basic knowledge of the app. I have a question regarding the reports. I just created a form from an admin account but I want to make it visible for all users of the database. I tried but failed every time I tried. I can only see the report on the admin account. What should I do now (step by step process) to make my form accessible for all the users?
Way to format currency in reports?
Currency in reports in creator defaults to USD even though in the form it is set to another currency
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?
Loading a form with fields populated with report values
Hi all, My application has a report in which I created a custom action (for each record) to open a form called "Add_Job". This form has, among others, a field called "Project_Number" which needs to be loaded with a value coming from the report. The custom action in the report is something like this: void project.add_new_job(int project_number) { openUrl("#Form:Add_Job?Project_Number=" + input.project_number + "", "same window"); } When the field "Project_Number" is of type single line, it works
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é.
Creating a Pivot Chart just defaults to a Pivot Table
Whenever I create a new report and select Pivot Chart, I just get the screen for pivot tables. I have tried on two different browsers, with no change. I can no longer create a pivot chart unless I duplicate a report that is already a pivot chart, but then I cannot change the form that it is referencing. I can only make pivot tables.
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"
Reports generate 1 row and 1 column title "-No Value-"
Hello Zoho Creator forum..... I have created a report based upon data from a Form. The report should have 3 columns (one for each business-unit) and rows based upon months of the year. Under each of the 3 business-unit columns there are 2 sub-columns showing 2 types of sales data. The report works properly except for the following problem...... PROBLEM: The report generates an additional row and column titled "-No Value-'". So instead of having 3 columns (one for each business-unit) there are 4.
zoho creator string field - search for multiple criteria
I saw this a a limitation in the api, but can I do it within a report? For example if I have a form that asks for the first name and I have multiple submissions, can I then run a search on first name for more than one name? Like to show me all records that have he first name "John" and/or "Bob"? If so, how do I do that?
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.
Trial User
I'm new to Zoho Creator, and before I dive in and start learning how it all works, can anyone fill me in on whether Zoho Creator is capable of doing the following: My app is accessed by my users who create new records. Online customers search those records via our website, and are able to submit a payment to that record. Do customers need to be "users" for this purpose? As I was hoping anyone can view and make payments on the records without being a "user".
Next Page