Zoho Creator Reports
New to Zoho Creator. I'm testing things out right now to see if it meets my needs. I don't want to have to mess with a separate Zoho Reports App to import it all into, but I see you can do basic reports and filters within Creator. If I have tables of expenses or payments for services from clients...i basically need amount totals for all the rows in a report. I basically want totals of records and currency totals. Is this available in report settings? Please help with basic instructions. Again
Pívot report from different forms
Hello, I need to create a Pivot report that includes the items from various forms, I mean, let's say I have 4 forms: One Called "Store" with 2 fields: - Single Line -> called Ref - Single Line -> called pants Second called "Employee" - Single Line -> called worker Third called "Shifts" - Single Line -> called hours Fourth called "Company" - Lookup field from the form Store -> called RefLookup (display the field "Ref") - Lookup field from the form Employee -> called workerLookup
Next & Previous buttons/actions in a form
I'd like a Next and Previous button on the Edit screen. I'd like them to have the same action as "update" Sometimes we want to change several records with different information. I'd like to pull up a view, click edit on the first record, then make changes and hit "next" and have it save the changes and bring up the next record.
Lookup and if statement issue.
I have an On User Input script that is checking the contents of a lookup. Depending on the choice, I want to show a new field. The dropdown lookup has device categories, tablet, smartphone etc, upon the choice of smartphone I want a new field to pop up where they can put what the device is. if (input.Device_Categories.Device_Category == "Mobile Phone/Smartphone") { show Mobile_or_Tablet_Type; } I keep getting the following error: Improper Statements/Expressions found java.lang.NullPointerException
urgent - iphone mobile app url field
hi using zoho creator's apps for iphone and for android in app there is url field. when use android - all works well when use iphone - in url field link do not appear. see screenshots urls - in application how entry looks in zoho creator in android (all works well) how entry looks in zoho creator in iphone - url link do not appear & link is not clickable
Zoho creator iPad
When using the creator app? I receive this message "This form cannot be displayed" when I try to open a form on my iPad. The form loads on the iPhone fine.
Nested lookup for data entry
I need to implement a lookup value to include an item in a form. However, I need to use a sort of nested lookup. This involves two one-to-many relationships. I give an example below. I have a table called Car. I want to characterize that car by its attributes or fields in a table or form as we say in zoho. On the Car form, I need a means to choose a make, then a Model within that Make. I need to retain the information within the form that will allow me to later reference both the make and model
How can i add a page break on an html page
I have an application that pulls pictures into a html page in zoho creator. I am looking for a way to add a page break so the pictures are not sliced in half when the end of the page comes. Any suggestions?
Mass-update one form using data from another form
so, is there a way to mass update one form using data from another form? I need this so I don't need to code the data into the function to update data.
add data into a lookup field by email
Hi Is it possible to add data into a lookup field by email? Thanks Satya NHM
specify action on specific records in list
Hi all, I am trying to take a list and specify action(s) based on specificrecord within that list. Please see example below Let's assume that ListA has 3 records in it I want to be able say For the first record in ListA execute function A For the second record in ListA execute function B For the thrid record in ListA execute function C Notice that each line is not performaning the same function . Any info would be great. Thanks in Advanced
Any Limitations of Lookup field type compared to Dropdown?
Advice needed please... If for some fields we are deciding between using a Lookup field vs. a Dropdown field.... Are there *any technical downsides* or limitations to using the Lookup type vs. the self-contained Dropdown type? For example, would a form with say 10 Dropdown fields perform the same in all respects if they were instead Lookup fields? Such as in areas of: Server performance Mobile version Sheet and Grid views Scripting capabilities Flexibility of display, etc. We are aware that there
Function
Hello, In a form I can generate a purchase order. I've made a custom template which looks like a purchase order. When I submit the form there will be sent an e-mail with the template as an attachment in PDF. I also generated a report which shows all the records of the made purchase orders. Now I'm trying to make make a custom function.This function will be a button in each record in the report. When you press the button it will send the e-mail again with the purchase order template in PDF as an attachment.
Duplicate or restore backups
Hello, I have a real problem with duplicating or restoring applications. I allready asked support but haven't get an reaction yet. Tomorrow I have to demonstrate an application. Can anyone please answer ASAP? Greatings, Erwin
Limiting global search
I have a report that needs to be limited by a company name. To do this I use the userid to fetch the Company name from a table of userids and the related company name. The Company name is then used in an openurl statement to pass the criteria to the report. This works great and the user only sees the records that belong to their company. The problem is the new global search field. This will return records that are not filtered by the Company name. How can I filter records returned by the Global Search?
Accessing subforms in a Report List view
Hi all, I would like to access a form via an "Edit" button, which basically calls a function. I would like to create an Edit custom action which I can access from within Report_A row (i.e., per record), but I would only require a pop-up of a particular subform. The subform is accessing another form, Form_B. Would it be possible to do this, i.e. create a function to access Form_B a a pop-up window, by clicking on the Edit button within Report_A? Any idea what the function would look like? Thanks
What do I keep getting this message - unable to connect ...
Hello, I keep getting the message below very often when I am running my Zoho Creator Application Unable to connect to messaging server. Connecting in 22 seconds Try Now Thanks David
Import CSV with User Field
I want to import a spreadsheet (CSV file) into a form with a User field. How can I import users into this User field. I tried having a column with the users' email addresses and that did not work, then I tried their usernames but that also did not work.
Possible to create event when new record added in Zoho Books - copy to table in Zoho Creator
When a new "Item" in Zoho Books is created, I want it to be copied to a table in Zoho Creator. (Need similar for when a new "Recurring Invoices" is made) How is this done? Can it be done?
Why exactly are Spreadsheet and Grid views behaving as List view?
Various Reports defined as "Spreadsheet" or "Grid" are suddenly behaving as the "List" type. We did recently add Workflow scripting to the underlying Form, and am hearing that this may be the cause. Can someone verify exactly what is forbidding these views? Assuming it is workflow scripting: Any script of any type added anywhere in the Workflow sections? Or only when added to certain "Form" actions? Which ones? Or only when added to certain "Field" actions? Which ones? Also: when I commented out
Custom function
Hi, I am using below function to update the Website field of a Form from another Form's url field. What I am getting bored that I need to go through each record of the form (clicking on function button). So I am wondering if there is a way that I can update 200 records in a single button click that would be very interesting ans also time saving . Script: void SearchLink.MVPDUpdateLinks(int id) { set = MVPD [mvpd_ID == input.id]; dat = SourceDat[Test_id == input.id]; set.mvpd_website
Other currency field vs chart (2)
Hello, I still have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
"Failed to Add Data" when submitting form
No other information and no other clues are given. The project has open access to support. And I have asked support to help on this with no success, yet they pretend they solve it, or ignore my problem. Support staff lately is very unhelpful. I wonder if others experience this error and know what to do.
Alert Box size
Hi, I have set up a alert on user input but it seems the alert size is really too big. How do I can size it to smaller ? Below is the script that I am using ************************************************* if (input.UNM_MVPD_01 != null ) { input.UNM_alertNote = ((((((((((("The " + "<b>" + "<i>" + MVPD[ID == input.UNM_MVPD_01].mvpd_MVPDName + "</i>" + "</b>" + " in " + "<b>" + "<i>" + Market[ID == dat.Add_Market].Market_Name + "</i>" + "</b>" + " TV Market Sold to " + "<b>" + "<i>" + MVPD[ID
live chat to a creator page?
Is it possible to add live chat to a creator page?
Writing to Creator database from Zoho CRM
Is it possible to insert values into a Zoho Creator database from the CRM, using a custom function or something similar? If I write the code in a custom function, I get an error that the Form does not exist in the application. Any ideas?
Wufoo to ZOHO
I am willing to pay for the job I require somebody to please set up my Wufoo toZoho api ? Any body that has done this or can assist please contact me.
Script for lookup of data across different applications
I would like to do a lookup from a separate application. Here is an example: config-module: "Form1" has fields: Global Category, Prefix hr-module: "Form2" has fields: Category and Name --> Category is my lookup field. --> When I lookup a category, I would like to populate from config-module's field Global Category. The issue is, I want to create a function to get the details from the form programatically, it keeps suggesting that there is an error...the problem is that my lookup field (which
Update records from other form
Hello, I have a form (form A) with information about vehicles. These vehicles have to periodically inspected.The date when the vehicle is inspected is filled in. In an other form (form B) I can plan this periodically inspection wich will be shown in a calender. In this form B I would like to add an input field where the new inspection date can be filled in. So when a new inspection date is filled in form B it has to update the inspection date in the record generated by form A. There is a report based
Subform subtotal automatic
Hello, I have made a subform with the following fields: Field 1: Aantal Field 2: Prijs Field 3: Subtotaal I have made the following script for Subtotal: row.Subtotaal = 0.0; row.Subtotaal = (row.Aantal * row.prijs); // calculate grandtotale input.Totaal = 0.0; for each rec in Werkzaamheden_2 { input.Totaal = (input.Totaal + rec.Subtotaal); } input.Totaal = input.Totaal; The script works but subtotaal will not automaticly be filled in when I put a value in: Aantal en Prijs. See attachment
Hyperlink function not working
I just tried to access the hyperlinks in my database and it's not working. Is there an estimated timeframe for a fix. These links are critical to my business. Thanks.
data typing; script error
I have an app with a subform. The whole form looks something like: Client - a lookup Project - a lookup Employee Hrs Rate Bill_Amt (a line of the subform) After entering Employee, I want to lookup the associated Rate and insert in the Rate field above. I am trying some scripting : theRate = Employees[ID == row.Employee].Rate; alert(isNumber(theRate)); //used for debugging returns true. row.Rate =theRate; When I go to save the script, I receive : Error at line number : 3 Expecting
Problem in form
Hello, I'm stuck in a form. In the attachments I have uploaded a print screen of the issue. When I select "Selecteer opdrachtnummer" the value in "Kenteken" has to be filled in. When "Kenteken" is filled in the field under it has to set a variable. The field "Kenteken" in the sub-form "Kosten" is based on the field "Kenteken." The problem is: Why does "Kenteken" right in the top doesn't fill in his value. Probarly there is a value because the field "Kenteken" in the sub-form is based on it.
Passing parameters to embedded form (2)
Hi, I would like to create HTML pages to customize the look and feel of the forms. However, I use navigational URLs to pass information between forms. How can I pass data to the embedded form?
formula field issues
Is there a way to make a formula field calculate properly if one of more of the items it's supposed to sum are blank? For example, say I have three number fields: Group A invitations, Group B invitations, and Group C invitations. If the formula field expression is (Group_A_invitations + Group_B_invitations + Group_C_invitations). but there's no value for Group C because no one from that group was invited, then the formula won't work. I still want the sum of groups A and B though. How can I make this
Picklist not accepting a list
Hi, I have a picklist not accepting a list of string items. The script can be saved fine but at the time of execution it generates an error. To, me nothing seems wrong with the logic here. The list is generated in another application from a database of categories filtered by another field. There seems to be an issue with this way of generating the list because if the list is generated manually with random items like "a", "b", everything works fine. I appreciate your support. here the code: Tecnicas_Lista
HTML script sections in a page
Hi, when creating a page, I added several HTML sections one after another. each section containing a table with pictures and text. At some point I wanted to add one section at the top but the insert HTLM function did not seem to find a spot to add this new HTML section right at the top. My reaction to this was to switch to free flow scripting, add a few lines at the top (to create a space), save and go back to script builder mode. The result is that the builder lost track of the different html
zoho.userid actual BIGINT ID?
I don't need the email address, or the user name, I need the BIGINT number. Can this be accessed?
Other currency field vs chart
Hello, I have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
Change current index of autonumber field
Hi, We developed and are using an application for orders management since last year. We're using an autonumber field for setting the unique ID for each order. The start index was 20140001, so we could easily identify the year an order was generated. We intended to change this index, this year, for 20150001, but I figure out that this is not possible in Zoho Creator. Can you made this change for us, please? The form is at https://creator.zoho.com/appbuilder/gbpenha/pedidos, and the field name is Codigo.
Next Page