Add the data of a subform with deluge script
Hello Zoho developers, Finding the answer of this question will help me in many projects. I have 3 forms: MainForm1, MainForm2 and Subform. MainForm1 and MainForm2 both contain a subform of Subform. When creating MainForm1 (in its On Validate or on success), I want to automatically create a record of MainForm2: Form2_ID = insert into MainForm2 [ Added_User = zoho.loginuser ... ];and then to have the same data of the subform Subform in MainForm1 attached to the newly created record of MainForm2. Thank
Showing all records in Table Report
Hello all When using Zoho reports to create Pivot Table, the default setting is to hide all those records that are have duplicates. Is there a workaround around this? I would like to have a Pivot Table and have all the records appear in the Pivot Table. Looking forward to your ideas and help.
Sort button in pivot chart not highlighted
For some reason the sort button doesn't work in pivot charts. I can't sort the x or y axys. Is this a bug or missing something Thanks
Export pivotchart report into .JPEG - trunckated image
Hi, I'm trying to export a chart into JPEG. The export work fine but the final result is a picture with the last few inches of the right side truncated. something like that : Any idea on how ti fix it? Riccardo
<Field Name>:ui.add() function does not work in On Add/On Load event?
Folks, I have another questions for this group. First off, I have found the link below on adding data to Dropdown Lookup List type field. https://www.zoho.com/creator/newhelp/fields/add-to-picklist-dynamically.html In my case, I have my first Lookup Field to be Tournament, then the second Lookup Field is Event. Each Tournament can have multiple Events. Currently, without any initial default value to my Tournament field, if the user chooses a Tournament, the Event Lookup Dropdown field will be
Problems with "lookup fields" and variable criteria
I have an application that uses a subform where I need to query a lookup from another database, the previous builder used a criteria with a variable, but I had to capture the "filter" in each row again, It worked very well. Now with the new builder I have the problem that I can not capture variables in the "criteria" field or at least not work well. Has anyone solved a problem like this? Thanks ....
Criteria to display a report with no value entered in a field
I have a form with categories, more than one can be checked at a time but I need a report showing those that have no category selected. I have tried a few things but none seem to give me the response I am looking for. I need to be able to go back and add categories to the ones I was not sure of when adding them initially.
Creating a report with fileds from Sub-From
Hi there I am wanting to create a report, based on the parent form, but bringing in various fields from 3 sub-forms of this parent form. I have created this type of report using the view link method, but the format of this is not satisfactory, and I want each field to show as a separate column in the report. (This is fine for one field alone, but not numerous) The Subform is logically a one-to many relationship, so I am not sure why the subform columns do not show as options in the report creator,
Subform handling that worked on the old platform is no longer producing the same results!
I have a form that was created on the previous Creator platform. This form contains a subform and is working fine. I created a new form using the old form as a template. I had to use a different subform in the new form. The new subform is an exact copy of the old subform. The code is identical in both forms. The new form does not produce the same results as the old form. In the old form the code listed below returns the string with the contents of the subform field Activity. This is exactly what
Lookup CRM and return address
Hi, I am trying to lookup my CRM account and then based on customer selected return the address? Thanks
Numbers not displaying properly in HTML
I have an HTML page where I am trying to display a currency field from a particular record. When the number is small I get the number to display 800.0 but if the number is in the millions I get 8.0E+8? I have found that when the currency is less then 8 digits I get something like 8000000.0 but when an additional digit is added it goes to 8.0E+8 How can I fix this to display like $8,000,000? Thanks, Sean The top part of my HTML page htmlpage Opportunity_Details(opportunity_idstr, opportunityID)
Can I call the delete web service using JSON in the request body?
Hiya The API samples show using x-www-form-urlencoded data when calling the webservice to delete records. Can I use json instead? If so, can you give me an example? thanks Paul
how to clear Zoho crm lookup field
How can I clear the value of a Creator Zoho CRM field with out using an API call? I want to be able to clear a value that has been entered. I have used the following but it seems to use an API call and i dont think it actually is clearing the value. input.ZohoCRM_Lookup_Field = null;
Calculation based on lookup
Hi, I have the following I am trying to achieve FormA.Product_ID FormA.Weight_Per_Item FormB.Product_ID is dropdown/lookup from FormA data FormB.Quantity FormB.Total_Weight trying to get this to populate based on FormA.Weight_Per_Item * FormB.Quantity Any help would be appreciated
Adding a field from another form database on success
A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form. Please advise how to do this
how are subform entries related to the parent record?
I want to be able to use a custom action to add a sub form record but don't understand how the sub form record is related to the parent record. My custom action adds a subform record but it doesnt seem to be related properlly. I have a custom action that opens the sub form but seem to be missing the part that will relate the new sub form entry to the parent record that the custom action was executed on. The custom action code im using is: void Payment(int ID) { openUrl("#Form:Payment?Request_ID="
adding unique rows
i want to know how to avoid duplication of records while inserting data?i want to know validation for same. when i will upload file only new rows can be added..
Single or double equals (or no equals) for boolean criteria
Hi, A fairly basic question but it would be great to have a definitive answer and I can't find one anywhere. What is the correct format for boolean criteria for a conditional expression (like an if, or to select form data)? And does it matter which format you use? (Because it doesn't seem to make any difference when I test out the different versions). A. One equals, e.g. FormData = Form[bool = true]or e.g. if (bool = true) {<expression>;} B. Two equals, e.g. FormData = Form[bool == false] or e.g.
Picklist within subform
Good afternoon, I have a picklist inside a subform wich I dynamically populete base on a lookup field. Is there any way to select one item on the picklist?? I try row.<fieldlist>.select(value); But the system answer: <fieldlist> does not exist in this form Thanks in advance for your answer. Ricardo
How to set up help button in a form dropdown
Hi, In a form a line which has drop down ( can I have a Help button around it - which displays pdf diagram which helps choose the choice for the drop down). Please help I am a newbie to zoho. Thanks, Geeta
Customer Portal Document Access
Our application has documents within the database, however the users we have set up through the customer portal are unable to open these documents with their userid and pwds. When they click on the link for the documents they are asked to sign in again via a link to the url via zoho and NOT our landing page, but their credentials do NOT work, making the documents within our application un-accessible to them. How do we fix this issue?
usage limit (how to manage)
OK, I have been using zoho creator for some time and has worked so far fine for my purpose. I do business process management and also store sales transactions. The sales transactions in particular I cannot afford to delete when I reach the usage limit. the other suff I can. Eventually (soon) I will reach the usage limit filled up with sales transactions. I need to figure out a way to manage this before that moment arrives. Obviously I can buy more records, great but eventually these will be used
Zoho CRM integration for dropdown field
I have the following code that works (in the load of a form): accountlist = zoho.crm.getRecords(("Accounts"),1,200); for each rowvar in accountlist { Client:ui.add(rowvar.get(("Account Name"))); } My question is how do I sort the Account Name for my dropdown field (Client)? Thanks
Duplicating an embedded view in a page
Hi I had an existing search form embeded in a page. I wanted to add another search form on the same page. I simply duplicated the first embedded form (so that I could then modify the search parameters) but when I inserted this duplicate into the html, the duplicate form would not appear. However if I changed the view link name of the duplicated form, then it would appear. This was the html: <tr><td><div elName='zc-component' viewLinkName='Search_Form'></div></td></tr> if I copied this row then
How can I create multiple rows of numbers and then connect US to it
The promo code is alpha numeric making it a pain in the ass to enter them 1 by 1 instead of doing a range of codes owned by a consultant. I would like to find a way to enter the fields: Country - (This could be a checkbox or text box or radio button) the options are either US or CH Code - (6 digit code) # of Codes - (How many sequential codes to assign to the consultant) Somehow I need to write a script that takes <code>+1 repeated <# of codes> then add or connect Country. So after inputting US 101010
Customer Portal Basic Questions
How can a user change his email? Are there plans to customize the sign-up from with more fields? Upon sign-up, there seems to be no way to control where the user lands in the application. True? Since I'm building the app in my own account with an intention to export the ds file to my customer, will my customer have issues with the customer portal aspect upon ds file import? Cheers, John Whitney
zoho.loginuserid not working for customer portal
A few hours ago if I logged in to my customer portal app, a form with Email=zoho.loginuserid; would correctly display the email of the user. Now it's simply blank. However, if I place <%=zoho.loginuserid%> on an html page, the email is displayed to the portal user. Something must be broken with the customer portal? I submitted a support ticket and shared the app with zoho. Cheers, John Whitney
iFrame vs JavaScript embed to show full report? Help Needed!
Hi, I am trying to embed reports in my website via "IFrame" so that the user has the "search" & "sort" options. But no matter what I try, it will only show the first 10 records of the report and is using "paging". I want the entire report (all records) to show, just as it does automatically if I use a "JavaScript" embed method instead. Unfortunately, when I use the JavaScript embed the user has no access to "search" or "sort" options. I would actually prefer the JavaScript embed, if I could get
Populate data field
Hi, How can you do that when you select a dropdown and a number is typed into a text field will auto fill other field and the final amount has to be half the user write. Dropdown field name: Tipo_de_Prestamo Data field with the amount : Prima Data field to populate: Comision
Customizing a Record Summary to show continuous records
I would love to know how to make a form almost exactly like the invoice shown on this example page: https://www.zoho.com/creator/help/views/record-summary.html. The problem I am having is the data from the subform that would go in the Item,Quantity, Rate part of the view displays all in one record with a comma between them (so instead of two records, "Widget A" and "Widget B," I get one record with "Widget A, Widget B." I'm a new user and it might be that there is a relationship problem in my
custom action to edit record
Is there a way to use a custom action to open the edit record dialogue? I want to avoid passing data back and forth between a stateless form and also do not want users using the standard edit record method. I want a custom action that opens the record for editing. Is this possible? Does the edit record popup have a url i can pass to the OpenUrl() function? Is there another way? thanks
Forms and reports
Is it possible to create a report based on 2 different forms that are not linked in any way?
NULL Search
How do I select records for which a field contains no data, sometimes called a NULL search? Thank you. Roger
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field.
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field. example,... project db, has the following fields, project number elec design hours mech design hours technician hours assembly hours time entry table has the following fields Project number job function (drop down with selection of elec design, mech design, technician design, assembly) Total hours I would like to update the proper field in
Managing Our Products (Price List)
Hi, We would be interested in someone developing a database for us with the following fields, if interested, can you please get in touch with me? Product Name Product Code Manufacturer (drop down) Manufacturer Name Manufacturer Code Length Width Height Diameter Weight Cubic Metres (calculation L X W X H) Cost (USD) Exchange Rate (perhaps can be auto filled online or happy to enter it manually) Cost (AUD) (formula COST USD X Exchange Rate) Landing Costs per cubic Metre (I will manually enter this)
Zoho Creator REST API
I'm trying to extract some data from a Zoho Creator App using perl as follows: #!/usr/bin/perl use HTTP::Request::Common; use LWP::UserAgent; $ua = LWP::UserAgent->new; my $req = GET 'https://creator.zoho.com/api/slowclay/xml/copy-of-slow-clay-registration/view/student_view', [ authtoken=> 'bd73c9ac318d2fab9f8d89fce9509c29', scope=>'creatorapi', submit=>'View Records', ]; $content = $ua->request($req)->as_string; print "Content-type: text/html\n\n"; print $content; But I just get the response
Need help creating a simple search interface PLEASE!
I've created a form that organizes job, job id and location in a form, but I need help creating a simple search interface that makes those three things searchable, and brings up all the information about a particular item searched. (For example, when i search LPN, I want it to show me "LPN", the job id AND the location. How can I do this? Please help!! I've tried for hours to figure out this coding ,but it just isn't working for me! Thank you in advance to anyone who's willing to help!!!!!
Search over multiple fields of subform data
I have a list showing the data from the subforms. I have several fields from the subforms showing. I am concatenating the fields from the subform so they can all be seen on the view. When I search I only get matches against the first field in the list of fields that are concatenated. eg. main form has name, sub-form has age-band and location. If a row shows "Martin" for name and "London 0-10 11-20" and I search for contains "0-10" I receive zero matches.
Translate to Portuguese
Hello, Is there any plan to translate Zoho Creator to portuguese, or a feature for the developer to translate commands of ZC like Delete, Edit, Add and staff like that. I have several clients that do not read english so I have to create html views with buttons in portuguese, so I have to re-invent the wheels all over again, and I'm not using one of the best things than ZC have, the views. Thanks Rodny :)
username microsoft windows
Hello, is there a way to know the user name logged in microsoft windows? Thanks in advance. David
Next Page