Pivot Table Criteria?
Hello, How can I display a Pivot Table data based on the zoho.loginuserid? I know I can do that applying a criteria in a List report but I don't know how to do it in a pivot Table report. Thanks a lot!
Calculate field using data from parent form
Hi I have a parent form with a field called CostPrice. I have a subform with a field called RetailAdjust. I want to create a calculated field called RetailPrice. RetailPrice = (CostPrice + (-1 * RetailAdjust) I can't work out how to fetch the CostPrice. I probably have the rest of the equation right, bit some pointers would be great. Thanks Brendon
Currency defaults back to $ in pivot report
Hi, A Creator form has currency input fields that are set as EUR. When I create a pivot table with these fields, the data is displayed as $ instead of EUR. Is there a way to make sure that the pivot follows the formatting that is set in the form instead of jumping back to (what I assume is) the default value? The same applies to the formatting for aggregate formulas: these ignore the formatting for the fields in the formula and default to $ if you pick the currency datatype. How can I change this?
Application with sub-applications as sections
Is it possible to create a main application with sub-applications as sections? Like Zohomail. Which has a menu called Apps and it has mail, crm, creator, contacts etc as sections which are separately applications. I would like to create something like that for my company.
Zoho creator app management
I have certain apps shared to me in zoho creator. Currently there isn't any support to directly backup the coding from another persons app in zoho creator that has been shared with me. Why this would be helpful is because it would make it more seamless. For example, an owner of a business wants to delegate control of a project to a manager which includes creating, updating, and backing up any apps in current use under that managers scope. Another example of it making things more seamless is the fact
Special characters (#) causing problems
I am unable to pass a field variable with a # in it. I have tried turning it into "%23", but it does not help. Fields without special characters are working. Specifically, what I am referring to is Location=<%=post_location%>& Location_op=18 I can't get this to work if the "post_location" string has a # in it
display external web data in a form?
I'm new to Zoho Creator and it looks pretty awesome so far. I'm wondering if it's possible to make a call to an external web service and display the results within a form ("on edit" or "on view"). Similar to the twitter integration example I'd like to display something like that in the form "on edit" or "on view". If it's not possible to do that, is there a similar way to basically show a record in my database and include dynamic data from external services around it?
A unique problem involving unique records & date/time.
Hi, and thank you in advance for any help you may be able to lend. After many years of being overly-proud of my Excel expertise, I started taking the necessary plunge into relationship databases, So as a novice, I'd really appreciate any guidance. Here is my problem, that I'm seeking a solution to... I currently have a project where fifty people are going door-to-door daily to collect information from a targeted list of homeowners. I have a master target list (~11,000 homes) and a survey form for
Problems with Zoho Pages
Trying to embed a published page in my website and functionality does not work at all. Within the Zoho page we have embedded forms and report views. We made sure they were all published, but are getting a message saying "you are logged in as public@zohocreator.com" etc etc "you do not have permission to view this application."
Create a List
Hi, I would like to create a list List01 based on other fields values like when Sub01 is not null then List01 contains 1, then when Sub02 is not null then List01 will add another value 2 so Final list will be {1,2} . This is something looks like below if ( Sub01 != null) { List01 = {1}; } if ( Sub01 != null && Sub02 != null) { List01 = {1,2}; } then, If (Sub01 = null && Sub02 != null) { List01 = {2}; } Could anyone please help me how do I can create the above list ? Thanks Arfater
extra statement showing on html page "function doaction(recType) "
I have many reports that I want to open in a html page so the report name does not show in the browser address bar. I created a table of a report code such as ABC and the actual link name. When I call the html page I send it the report code and then lookup the linkname. This works as expected but at the bottom of the report I have function doaction(recType) { } $(document).ready(function() { doaction(); }); Here is the html page htmlpage Report_View(Report_Code) <%{ Report_Link_Record = Report_Names
Odd and Even Numbers
Is there a deluge fuction to detect Odd and Even numbers? Or maybe a function to know if a number have decimals, Best Regards,
intersection of Two lists
Hi, I have two lists such as List1 = {0.1,1,2,3,4,5,6,7,8,9,10,11,12} List2 = {0.1,2,4,6,7,10} What I would like to do is create a intersection of above two lists Final_list =( List1 - List2) = { 1 ,2 ,3 ,4 ,5 ,6 } - { 2, 4, 6} = { 1 ,3 ,5 } then input the first index of Final_list in the Channel_No field , that means input.Channel_No = 1; Please help me how to write the script to achieve it Thanks Arfater
how integrate google analitycs to creator's form?
hi how to integrate Google Analitycs to creator's form need to view how manager clicks fields in form
Change font
Hello, Is it possible to change the font of al whole Zoho Creator application? If yes, how can I do this? Hope to hear from someone soon. Greatings, Erwin Fennema
Use value of lookup field dropdown menu in a formula field
Hi there, I have a look up field on a form. I've tried to get the value of that lookup field into a formula field but it returns the entry ID such as: 1365899000000729278 I have previously used a code in deluge script to get the value by using this technique: Checkpoint[ID == input.Checkpoint].Checkpoint However, if I try to use this in a formula field i get an error stating: "Expression not supported in formula" Is there anyway I can get the value of a lookup field into a formula field? I need to
File field, empty or not
Hello, I need to writ a script that distinguishes between a file field being empty or not. This is needed to generate a page displaying or not the image contained in that file... The issue I am having is that non of these options seem to work: if (file_field=null) {script} if (file_field="") {script} in both cases, the result of the if statement is true even though there is no file contained in the field. would you please let me know how to make the if statement work fine and return false when there
Notification into one form
Hello, I'm building an application and have a question about it. I would like to script the following: Step 1: 1. An user can make a mention in Zoho Creator for his vehicle like: Mirror is broken. 2. An other user can make another mention in Zoho creator for the same vehicle like: headlight doesn't work. Step 2: The manager can check out these mentions and fill in another form for a supplier to fix it. Step 3: The manager fills in a form and selects the licenseplate of the vehicle and the supplier.
is it possible to make this app
so i need and app where i can import xlsx tables filled with new data every month and be able to create new data based on lookup fields except the Price (Euro) it is auto filled. What i have at the moment is all the lookup fields, the auto calculater, the hidden reports (not hidden atm), the single field to create new column lookups names to a hidden report which is fetched by the lookup field. Is this possible to make a Main report and combine all these hidden reports so that the main report updates
Can I open a Stateless form from a Report custom action
Hi I have a referral system that I am developing and the main referral form has been created ok. However part of the process for the referral is for there to be a follow up call via a call centre to arrange a telephone consult. So I have created a report which filters new referrals which only the call centre will be able to see. But I would like them to be able to click a 'view Referral' button next to each entry in the report and see a version of the main referral form with some of the confidential
Notification form when value
Hello everyone, I have a question. In a form I have a choice box. You can chose: 1. Yes 2. No When "Yes" is selected I would like to send a notification by e-mail with user submitted data included in PDF. If I make a on update function "send mail" I can't attach user submitted date included in PDF. When I go to the form settings notifications I can. Can I us the notification in form settings for this function? If yes, how can I? Hope to hear from you soon, this would really solve some problems for
Creation of HTML page Problems
Hello, 1) I have a problem. when I try to create an HTML page, screen becomes gray and nothing is clickable. I have to reload the page. 2) at link https://www.zoho.com/creator/help/views/create-html-page.html i read: "6. You can create your view based on a template by selecting the Choose Template button". where is this button? thanks a lot
Users can't download file uploads.
I am having troubles making it so a user who is in a group can download a file that has been uploaded. They can see the link inside of a view, they can click the link but they do not seem to have access to download the file. The user has the view and the form shared to them already. The file upload is inside of a subform on the main record. What is wrong? is there something else i need to do? I don't want files to be public, I want a logged in user to be able to download any file they can see in
Possible to set filter on multi-select lookup?
Hi, I have two lookup fields in one form: Lookup 1: Services Lookup 2: Activities When these are single-select lookups I can set the filter so that the menu of activities is dependent on the service selected. However, when these are multi-select lookups the same filter does not work. i.e. on activities lookup ((Service.ID == input.Services)) Is it possible to set filter to multi-select lookups so that all services selected display all activities related to those services? Thanks! Lindsay
Html Table Fix
Good day, could you please help me how do I align this columns to put one beside each other (no intermediate space), output = output + "<table class='tableSize' align='center'><tr><td style='width:60%;vertical-align: top;'>"; output = output + "<table border='1' cellspacing='0' align='center' style='border-color:#EEE;width:60%;margin:0px 0px 0px 0px;' id='billingAdd'>"; output = output + "<tr class='rowHead'><td>Nombre</td></tr>"; for each y in EquipoUtilizado { output = output + "<tr class='rowVal'><td>"
Zoho authentication API
Dear team, Do you have by any chance an API to authenticate through Zoho? I need to do a portal (and I cannot use for this purpose Zoho Creator) and I would like to have my users be able to authenticate through a Zoho account. We may use Zoho Creator to create the users but then front end will be in another technology. How could we proceed? Is this something already existing? Many thanks in advance for your input. Best regards, Christophe Mendez | MZ Consultants - Zoho Alliance Partner
Is it possible to upload files to Zohodocs from zoho creator using api
Hi Is it possible to upload files to Zohodocs from zohocreator using api I refer the zoho docs api below link, but its not clear https://www.zoho.com/docs/zoho-docs-api.html Please help me how upload files to zoho docs form zoho creator ,if any sample code please post it Thanks Satya NHM
How can access zoho pepole employee form from Creator
Hi We are bulding an application wich needs info from our employes, this info we have into ZOHO PEPOLE ¿how can acces the info in zohp pepole form zoho creator?
logs - to admin email?
hi! how to send all error logs to admin email?
how in form make verification of data in other report?
hi! there are 2 forms - form1 and form2 and there is report1 which made on entries of form1 how can i link in form2 verification report1's entries? example if in report1 there are entries with "input.datadostavki >= zoho.currentdate.addDay(3)" then in form2 there is alert =========== if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert"); }
I would put a filter for a single month without putting a specific day.
ML_01_Last = Stock1[Fecha == '01-Jan-2014'].count(); I would put a filter for a single month without putting a specific day. ML_01_Last = Stock1[Fecha == 'Jan-2014'].count(); The filter should be something, but I'm not sure how.
eMail template with a lookup field
I am trying to develop an email template for a form per "on submission success" action. The "submit success" action triggers this email. In designing the template, I found that the "lookup field" defined as <%=LOOKUPFIELD%> shows a value of the ID of the related form. How can I make it shown the other values of the same row on the related form? Thanks.
Viewing Reports in a form
Is it possible to view a report in a form, much the way sub form can be seen? If so how can this be done? Thanks!
Will Zoho Creator ever provide customizable layouts for forms?
One of the most wanted features for me and my clients is the ability to have better layout options for forms. The rigid 2-column vertical layout is not enough for many situations, and looks rather primitive and not elegant like many commercial applications.
Html Table Container
Hello I have 2 tables in HTML, I want to know how do I put one beside the other, I have the following code //CONDICIONES AMBIENTALES if (CondicionesAmbientalesNoVacio != null) { output = output + "<div class='invHead2'>Condiciones Ambientales</div>"; output = output + "<table class='tableSize2' border='1' cellspacing='0' style='border-color:#EEE;margin-bottom:5px;'>"; output = output + "<tr class='rowHead'><td>Zona</td><td>Hora</td><td>HR</td><td>TA(°C)</td><td>TS(°C)</td><td>TD(°C)</td><td>TS(°C)-TD(°C)</td></tr>";
Automation of User invites in Customer Portal
Hi, I want to know if it exists a way to automate the user invite in the Customer Portal via a custom Form, via api call or other via without user interaction. I would like, for example, create "Students" in my database using a Form and add them automaticaly in my Customer Portal. As I can Allow Self-Registration in the Customer Portal and set the default profile (in this case one that filter the info related to the Students), I thought I could create to every Student an account to my Portal just
Help! Anyone know how can I get user to choose a unique ID name?
Thanks for any help you can offer folks. I have a very simple form. The only field is ID_Name. I want the user to choose a unique ID name, and I want to be able to control the responses. if(input.ID_name == "Jenny") { alert ("Sorry, this ID name is taken. Try again."); cancel submit; } This On Validate script would work perfectly if they chose the name Jenny. Basically, what I want is to say (instead of Jenny) - any name that is listed in the field called All_ID_names, which is in the View called
Export XML file with child element
Hi, I would like to export the data in Zoho Creator to XML. However, there is a child element in the XML, the XML look like this: <?xml version="1.0"?> -<Batch xsi:noNamespaceSchemaLocation="http://www.google.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="1.2" TradeId="3333"> -<Order TradersExternalReference="4456"> -<ShippingInformation> <FirstName>John</FirstName> <Address>road 25</Address> <Country_ISO2>US</Country_ISO2> </ShippingInformation> -<Products> <Product
Adding the value of items in a picklist
I am creating a simple equipment builder, where I have a catalogue of components, with costs, which are pulled into a form in a multiselect picklist. As each item is selected, I would like to fetch the cost of each item, and add them to a running total.
Restricting numbers in a decimal field
Hi there, I, like many others, am really surprised that Zoho Creator doesn't cater for a time field (hh:mm) to capture time spent on certain tasks. So I've opted to use a decimal field and ask people to round up to the nearest half an hour. I would like to restrict the allowable numbers after the decimal point so that they can only enter .5 or .0 and nothing else. If they try to enter anything other than a 5 or a 0 after the decimal point then a message will display - "please enter time to the
Next Page