Why the fields in the pivot chart change?
Hello Everyone. My question is: Why in the pivot chart, the fields change it's name? in the translation, and in the form, and in the report the name of the fields are good, but when i created the pivot chart the fields appear like: "Number" , "Number3" or, the name that i have for the date is "Fecha" but in the pivot chart appear with the name of the last field that i created in the form... I saw the translation and everything possible to correct this and i can't find something, help me please, IT'S
Why i am getting this error?
Improper Statements/Expressions found com.adventnet.cache.exception.CacheException: java.lang.IllegalStateException: Cannot register synchronization when the Txn status is STATUS_MARKED_ROLLBACK Possible JavaScript / XSS Vulnerability in statement "null" at line 4599 Can anyone help me on this.
Help Using Schedule To Update Records
I'm using Zoho Creator to report on data from a different software application. I have 2 forms that were created by importing records from CSV files. The first is Player_Invoices and the second is Player_Payments. Each table has a field named Bill_ID (which is a string). I've created a subform on Player_Invoices that I want to display the Player_Payments. I would like the subform to display all the payments that match the unique Bill_ID field for the invoice. I assume that in order to do that
Default Reports to All Application Users NOT All Users
I think this would be a change that would be beneficial to everyone. If you have a customer portal, you don't want to default access all reports to all Users. I have to have people check our portal daily to make sure odd reports aren't displaying. Please consider not Defaulting to All Users.
Problems With Exporting
Not sure why, but 2 of my 35 fields (Columns) are not exporting? Can anyone help?
Complex report criteria
I have a report based on a form, with some criteria to create which are quite complicated. Basically the criteria for the report need to be: select * from FORM_A where value of FORM_A.FIELD1 in (array/collection of values of FORM_B.FIELD2 from FORM_B [FIELD4 >= '1974-01-01']) Which means, for each record in the FORM_A, if the value of FORM_A.FIELD1 is contained in the collection of values from the selected records from FORM_B.FIELD2, then display the FORM_A record in the report. Is this
how can a field auto-complete before someone enter in a form?
Hello everyone, this is simple, How can i do, For a field to be filled or autocomplete when someone enters into the form?
Permalink for Record Summary View
Hello, Is there any way to create a permalink or otherwise link directly to a record summary view for a particular customer? I can filter the base report down to a single record using '#View:Customer_Data_Report?Customer_Name=Customername' in the url, but there doesn't seem to be a way to access the summary view directly. Thanks for your advice, Elizabeth
how to Paged query using REST api view records?
how to Paged query REST api view records? here is best wishes from zhangqiang I was using REST api view records. for example ，there are tens of thousands records in a view。 I was using REST api view records to get records and It will return all records(tens of thousands records) by default . IT took 30 seconds and had 12.33Mb. IT is too big. My requirement is that only call back 50 records from 1 to 50 ,and when i pass the next page parameter, it call 50 records again from 51 to 100.
Record Summary to show filtered records?
Hi there Is it possible to have a record summary display filtered records? I have Parent form of Course Instance - this holds Date, Trainer, Classroom. I have a Subform of Details - this holds Student Name, Booking Status. I only want the record summary to show "Details" rows where the Booking Status is equal to Confirmed or Deposited Paid (therefore it would exclude Booking Status of Cancelled or Transferred). Is this possible? Cheers Aaron
Use form to search criteria in a single database
Hi there - I have a large database that I would like to be able to pull information out of easily. I don't need to add records, I just need to look up information. Seems simple enough. I have only 4 columns: 1. Main 2. Section 3. SubSection 4. Description I'd like to be able to perform a search using one of the criteria, or narrow it and use two or three. Everything I have looked up seems far too complicated. I just am looking to search a database already formatted. I want to be able to type in some
Sharing
Hi, I am having real trouble sharing. I have created an application. I have gone into set up and activated the user and given them permissions. I have then shared the application with the user. The user gets the email, but when I login as the user it says I am logged in, but says "You are not allowed to access this application. You are not allowed to access this application." What am I doing wrong? I am signed up for the free account, and as far as I can see if gives me the ability to share with
Conditional sumif in pivot chart
Hello, I would like to make a conditional formula in pivot chart but I have not been able to understand how the structure works. Try to achieve something like: Sum("Autoview_1483575409618_Ingresos_Egresos Table"."Gastos" if "Autoview_1483575409618_Ingresos_Egresos Table"."Tipo de ingreso" == "compras ebay") I want to add the monthly expenses only if the type of expense is "ebay purchases". I can not do it from filters because in addition to this graphic I want to add another one that is: Sum("Autoview_1483575409618_Ingresos_Egresos
input function vs lookup field
Hello, I have three forms (marked bold): Customer New task has a lookup field based on field from Customer. Then i have custom action which (among other things) creates record in Report: void VytvoritProtokol(date Do, date Od, string Uloha, string Technik, string Z_kazn_k, int recid) { rec = New_task [ID == input.recid]; rec.Protokol = true; insert into Report [ Added_User = zoho.loginuser Koniec_z_sahu = input.Do Kr_tky_popis_probl_mu = input.Uloha
Lookup field vs insert function
Hello, I have two forms.. in 1st i have an useful custom button which uses insert function and inserts data to another one. something like this: insert into Form2 [ Name_in_form2 = input.Name_in_form1 ... But when i put lookup field instead of regular text field it will not work anymore. Is there any simple solution for this ? Thanks very much
Record Summary Print Error on Chrome
Hi, I think there is a problem with custom record summary with google chrome print mode. I created a report summary for invoice. When I selected print record summary directly, chrome print page printed half of the page (image1) if I download pdf, there is no problem (image2) I opened page with safari on mac, also there is no problem In addition, 2 weeks ago I created different record summary and It has no problem like this. (WTF :) I deleted report, I create 10+ different record summary, different
I like to integrate mercadolibre to Zoho creator
I like to integrate mercadolibre to Zoho creator. I am not aware of API and I want to know if it would be very complex and if there is a precedent that this is possible. Mercadolibre is the equivalent of ebay here in Mexico. I would like to have Records that will synchronize me with the publications to modify prices and some other things, thanks! Thank you
How can i do to hide fields from a report?
I want to hide some fields from a report, but i dont know how to do it. Why i want to hide these fields? Cause, according who enters to the report, it will displayed the fields to him.
Accessing all company apps from one html page
Does any one know if it is possible or how I can make an HTML page with tabs and subtabs or menus that can be linked to all the company apps that I have created in Zoho Creator? To create a page, well I noticed that it should be done from within an application, so I created a Parent App , called "Company Systems", created only one single HTML page that has one tab, I am hoping that I can create more tabs and sub menu in this single page that can be linked to other applications, forms and reports.
Get a record with a specific date range.
Hi, I want to get records of a specific month and year by adding the date to a date field and I can not do to work. I have tried several ways and I do not get it to work, it does not filter me the data. .This is my code; str=input.Mes; /// Is a date field/// mes_1=str.getMonth(); mes_2=str.getYear(); mes_12=mes_2.toString(); mes_3=mes_1.toString(); Moneda_prueba = Gastos.sum(Monto);
Updating existing records by email
I am having several existing data entries to which I would like to allow users to email documents. Is this at all possible or can this only be achieved by logging in, locating the relevant record and upload the document? All records are defined by a unique code.
Search with Lookup Field
Can someone help me fix the error? Error: In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid Code: htmlpage Search(searchid) <%{ name = Personen[ID == input.searchid];%> <%=name.Name%> <%=name.Vorname%> <%}%> I'm still a beginner, Thanks for Help
Transfer entered data from main form to subform
I am trying to bring information from a main form and have it auto populate a field in the subform before clicking on the subform. I want to be able to take the customer name over to the subform automatically. Please help
Sending html form upon change in drop-down?
Hi Zoho and everyone :) I have an html form with a singel drop-down field. I'd it to be auto-submitted when the drop-down change. how can I do this? Adding onchange="this.form.submit()" to the field did not word off course... will appreciate any suggestions on this one Thanks! Ravid
What is the best map location addon for creator?
I have multiple addresses in my customized app and I would like to see them on maps... I was told I will need to use a third party APIs and integrate it into Zoho Creator... Which is the best and where do i find it?
Date Format
Is there a way of changing a date-time field so it only requests Date, hours and minutes i.e. excludes seconds?
Href Link to the same html page ("refresh") does not work!
Hi Zoho, On my html page I need to create a "refresh" button. when using <a href="#Page:Page_Name">Refresh</a> - it does not work (page does not reload). same link is working fine when directing to other pages. this is happening in all of the html pages. Please fix this ASAP, I need this function... thanks Thanks Ravid (P.S., I'm using the reload button since the OpenURL does not work when adding entries to a Zoho-form using a POST html form, s either fix will be appreciated :) )
File size upload is currently 10MB per file - any plans to increase that?
Smartphone cameras are taking photos larger than 10MB these days and we need to upload them to Creator - would you please consider increasing the maximum file upload size?
When i try to show text, it doesn't work
Hello everyone, i have problems when i try to show plain text, i show it on the script but, when i go to the form it doesnt displayed. if ((zoho.loginuserid == "mayra315@hotmail.com") || (zoho.loginuserid == "quirofanosur@gmail.com")) { hide plain; hide Ingresos_or_Primera_Vez; hide Reingresos; hide plain1; hide Hospitalizaci_n1; hide plain7; hide Tejidos_Blandos3; hide Reducci_n_Cerrada1; hide Estabilidad_Articular; hide Fracturas; hide plain3;
When will users be able to enjoy inline editing (Sheet/Grid views), and bulk editing? :-)
When an app becomes even slightly sophisticated and has some scripting, we loose these useful features! Bulk Edit is allowed but does not trigger the scripting. Sheet and Grid views are not available. The workarounds I'm seeing don't seem very satisfactory. Bulk edit: admin only (and live with the danger), or create custom actions with bulk edit scripting. Missing Sheet/Grid views: no workarounds Is Zoho working to add SUPPORT so that sheet/grid views, and bulk edit, DO TRIGGER the form scripting?
How can I open the QR scanner automatically?
How to opening the QR scanner automatically after doing a QR scan?(do it succedively)
Multiselect Lookup to single/multi line text. Problem with BIGINTLIST
Hi, I am trying to put data from my Multiselect Lookup field into Single or Multi line text field for further use in other Forms. The Multiselect Lookup field is called Positions_names (One person can hold several positions in the organization) and the text field is Positions. So far I have a solution which only does half of the job. Pos = List(); for each r in input.Positions_names { Pos.add(r); } input.Positions = Pos.toString(); The output is ID number 3232752000000042103 instead of text.
Emailing a quote to a customer
Hi guys, I have a small - medium arborist business and am trying to get everything online and mostly automated. The question I have is when i have finished a quote for a customer is there an automatic way I can send an email attaching the form and inserting there name to the email and send it? Thanks in advance for your help. David
Is it possible to call forms without having to use the custom portal, through a user table?
What you want to implement is a user table s to have more control of the forms you view, since the portal costumer no longer gives us the filters we need.
Also, how could we fill fields if we have a form on an external website?
xml-based POST html form keeps downloading files?
Hi Zoho, I have an html page (Dashboard_test) with an html form is it, forwarding the data using POST command to a Zoho form (FnA_Bulk_Edit). Two problems: 1. When submitting the form, the user gets an xml file auto-downloaded. How can I prevent this? 2. In the On Add -> On Success script of the Zoho form, the script is processed but fails to open the url (last command is OpenURL). How can I fix this? Please check the page and form and let me know how to fix this. I'd really like
Duplicate an entry that doesn't allow duplicate entries?
Is there any way to code, to change the data that doesn't allow for duplicate entries. I have a LOT tracking system and the LOT numbers can not be duplicated. YYMMDD## I want to duplicate the record and sub forms but change the ## before doing it so the record won't be a duplicate. I've tried from a report to check the box and click on the duplicate icon only to have it fail. Any way I can do this via a program or catch it before it it tries to store the record? Thanks Andy
Timesheets
Hi Now I have our database almost complete. I want to explore reports more. Is there a guide or template report similar to a Timesheet? I have a table aptly called Timesheet with the following fields: timesheet_account (Lookup Field) timesheet_resource (Lookup Field) timesheet_activity (Lookup Field) timesheet_start (Date-Time) timesheet_finish (Date-Time) Duration (h) timesheet_description (Multiline) Ideally, I would like a couple of reports. 1 - A Project summary report listing date, duration
ZOHO FORMS AUTO COMPLETE TEXTBOX
Good day I have question if it is possible that I create a zoho forms with textbox that can give auto complete My project is Chemical Inventory. I need a textbox field that when I enter the first to third letter of the chemical it will automatically filled. Because I have 75 Chemical in list and its hard to list it down on dropdown or manual input the names. Im only new in Zoho Creator.. Thanks
Deluge - if no record found set value to 0
Hi there I'm using the following code //Get the discount amount based on the discount code fetchdiscount = DTKC_Discount_Configuration [Discount_Code == input.Discount_Code]; input.Discount_Amount = fetchdiscount.Discount_Amount; input.TOTAL_TO_PAY = (input.Total_Cost_Before_Any_Discount - input.Discount_Amount); My question is - if there is no match for Discount Code, how do I force the input.Discount Amount to be 0 At the moment if there is no match I get an error saying something to the effect
Traversing the fields on a form not restricted to tabs and mouse
Using the tab or mouse to move from field to field will not be acceptable for my application. I would like to move from field to field via hitting ENTER. Upon hitting ENTER at the last field, the insertion point would move back to the first field. Submission of form would be by button.
Next Page