Create applications via API
Hi there, I am looking into the API of zoho (at https://www.zoho.eu/creator/help/api/rest-api/zoho-creator-rest-api.html ) but did not see a way to create / update applications using the API. Will this be available anytime soon? Also is it possible to higher the API limits from 50/hour to for example 5000/hour on request?
Regarding the update of my dash board
i had the total salary data in my forms a dash board to display the monthly wages of each department every month and total wages of the every department in a month
Application Design Help - Delivery Driver
I'm trying to work on a delivery driver application. We have 13 AM drivers and 8 PM drivers, they deliver to pretty much the same buildings ever single day (i.e. repeating / automated daily records is a must). There are some variances (quantity, additions, subtractions, etc). As a driver leaves our production facility they check out their truck and their product. Once they deliver the product the need to update the building as delivered. I need to keep records of all of these deliveries. What
Year view for Calendar report
Please implement this feature! A year view for the calendar report!
Photo Metadata
Hello! Is possible to keep the metadata of a photo when is uploaded to Zoho Creator? What i need is to obtain the GPS coordinates of where the picture was taken. Thank you in advanced, Regards!
linked lists like in CRM
Hi all! Please, help me with one issue. I want to create linked list in Creator with algorithm like in CRM. I mean that when I create record in related list using it's own form (analog in CRM - creating Deal for Account using module Deal), I want to see this related record in main record's form after saving. When I adding subform to form, relations added only if I create record using this subform. If use the main form for the same operation there are no relations between main and subordinate records.
Zoho Creator + Zapier
Hey guys, I'm trying to write a Zapier hook so that I can import data into Zoho from other sources. The limitation of Zapier is that they only support sending JSON for the post body (ie {"authtoken" : "MY AUTH"} ). I don't see any sort of Zoho API that accepts data in this format. Am I missing something or does Zoho not support POSTing JSON? Thanks
Mail Merger with Writer
is it possible to do a mail merge with documents sitting in zoho writer?
I could not add record for lookup field via another form.
I could not add a record for lookup field. It's shows error message Error in executing On Add - On Success script. Due to invalid expressions insert statement is terminated Line:(2) Error on inserting the value for field 'Service_ID'. Given value '4' doesn't exist in 'Add_Service' form Line
Passing parameters to edit a specific record in embedded form
I am creating a dashboard for a customer portal in which I want to use the current logged in user (zoho.loggedinuserid) to find their corresponding customer account record and display it for editing after they log in. However I can't get the syntax correct. Here's my code: ******************** htmlpage Home_Page() displayname = "Home Page" content <%{ if(Boat_Owners[record_loginuserid == zoho.loginuserid].count() > 0) { //Display the Boat_Owners form so that the logged in user can fill it out
What is ui means ?
States:ui.add(statelist.ID.getall()); Here what is ui mean?
Can the 'Show/Hide Columns' option be shown or hidden in the url
Is there a switch in a url that will enable or disable the Show/Hide Columns option? In some reports I want to start with only a few fields and let the user choose the additional columns they need to see. In reports available to my customer portal users the 'Show/Hide Columns' option does not show. For some reports I need this option.
Error in Fetching Data From Another Application - In Zoho Creator
I have written function in Application 1 to fetch Data from Application 2. The data passed and returned are in map format. i) I always get null values from Application 2 though the script and data passed from Application 1 are accurate. ii) But when the function in Application 2 Executed directly it gives correct values. App 1 Function: void retrive_from_Apptwo.retrive_information(int uniqueID) { product_information = Map(); product_information.put("UniqueID", uniqueID);
Content-Type is header not set correctly
I am attempting to update a contact in Google Contacts with postURL. It fails with error code 415 which seems to be connected with the content type. The Google contacts API requires atom+xml content type. I set the header for "Content-Type" to "application/atom+xml". API = gAPI [Name = "Contacts"]; header = map(); header.put("GData-Version", "3.0"); header.put("Authorization", "Bearer " + API.Auth_Token); header.put("If-Match", "*"); header.put("X-HTTP-Method-Override", "PUT"); header.put("Content-Type",
there Should be a Button Field in the Form Body
it will be good if there's and button field in the form body , it can help in the type of form where an algorithm has to ran or a calculation has to be done on user input more often. like in quote calculator form I am developing , I use decision field right now , which seems inappropriate , since whenever user click calculate, after performing the calculation I have to uncheck the field via script to make it clickable once again due to which it runs the user input script once again. it would be
Unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form.
As title says, I'm unable to use GRID VIEW in a report although no client side Deluge Script is configured in the form. At least none that I can see. Anyone would know how to solve this or how to troubleshoot?
update form from another form
Inventory system. I have a form/table containing (among other fields) part number and quantity on hand Three scenarios which I guess would be handled with a series of if statements. 1: New part is received from the distributor. 2. part is removed by a technician for use on a service call. 3. part is returned from tech to warehouse a. defective part which was replaced is returned to the distributor . b. part is returned unused and will be added back into our inventory on hand a separate form
Print as PDF on Submit click
I would to like to print the record as a PDF when the user hits the submit button? I want the record to print as a summary, so that when the user opens the PDF record they can use a PDF signer to put a signature on the PDF. Is this possible?
entry changes logging
hi! is there any tools to log each change for every record in zoho creator app's database? or may be there is some webhook functionality to send every record's change to other database? need to know info like "at field A - new settings are X, Y, Z" so - task is to send current new settings to other resource when this field is changed
Dynamically updating field title text
I need to create a simple Form which has two single line text files, let's call them "Name" and "Response". Initially the "Response" field must be hidden. The "Name" field must give the prompt "What is your name?". As soon as the user enters a name, the "Response" field must be shown, and the prompt for that field must be "Hello <Name>, how are you today?" where <Name> is the value entered in the <Name> field. How can I implement this? So far, I've got both fields created and in the init script
Automatic
Hi guys, So i have a small problem. Sometimes i have 100 of products of the same brand, but with different serial numbers. So i have to input it separately. Is it possible for a field to remember the brand i choose previously ? For example : Serial num 001 Brand XLo (Input) Serial num 002 Brand XLo So if i have to do it manually for 100 products,it takes a while. is it possible for a field to choose the brand automatic, based on the previous choice? Thank you
Add PDF to email from URL
Hi, When a user books a course, I generate an invoice with an API call to our online invoicing platform. As a result from that call I receive the URL for downloading the invoice as PDF which I save in Zoho Creator. The next operation is to send an email to the user with the generated invoice attached. Adding a link in the mail to download the invoice is not an option, since the link contains our API token for the invoicing plattform. Is there a way, that I can download the pdf file to a File Upload
populating one subform data to same subform on next count
hi all, I have a form (Inwards) in which there is subform (remaining items on P.O). forget count 0 plz on count 1, subform add row i have populated count 0 data to subform which is working nicely on 2nd count, subform add row i want to populate (remaining items on P.O) to same form. i am using this script for 1st and 2nd count if(Inwards[Purchase_Order_Number == input.Purchase_Order_Number && Field_field == "Open"].count() = 1 ) { rec = inward_items_lookup[Inwards == input.Inward_Number]; i = 0;
can't duplicate an app
Hello I have an app “Inhabit Master” that I am trying to duplicate. It shows “duplicating” but nothing shows once it completes. It has 850 records. If I try with another app with 180 records, it works. Can you please help. Feel free to run the duplicate yourself if you wish and load it to my account. Many thanks Scott
Number of decimals not displayed correctly
Hi, I have a field that is of the type "Currency". When I use that field in scripting it only displays 1 decimal (eg. 220.0 instead of 220.00) in the form it is displayed correctly (220.00). Can this be fixed? Thanks, Michel
On Load script causing application error
I have the follow code that simply looks up a CRM Contact record and does some basic conditional logic. It works okay if a record is returned from CRM, however if nothing is returned for the criteria it shows an application error when it gets to this line: crmContactMap = crmContact.get(0); I thought it is because it's trying to work with a null record, so I've put this line within conditional logic that only runs if the record returned is not null. Full code is below. I can't figure out what I'm
Fetch data from In a subform and auto complete
Hi guys, Im a little stuck on building a form... The issue being I have two forms, one being the item form and another the order form. In the order form there is a sub form where there's a lookup to the item form using one of its fields but what Im having issues doing is using the lookup function in the subform and auto filling a field with data from the item form... Ive tried so many ways and I'm trying to keep it as simple as possible for the users... The best way we have thought of is using
Aborting an entry
I have a field action on the ticket number in my service form. After the user enters a ticket number the script will determine if that ticket is already entered, and if so, will populate all of the fields allowing the user to edit the data. Here's the problem. If there is a change that the user doesn't want to save, clicking cancel does not clear all of the data nor does it exit the form and return to the report from which it was called. If the user edits a ticket from the report list, there is
"if then else" inside "add record"
when updating data at form 1, a new record is created at form 2 some fields are directly transfered from form 1 to form 2 this is acomplished with "add record". but form 2 has a field (a) wich value depends on a value of a field (b) at form 1. That value has only two possibilities and should be obtained by a "if then else" with a value of a field (b) of form 1. how can this "if then else" work inside "add record"?
Find any gaps in dates across 3 years
I'm building an application form for new employees, and I'd like them to input their previous employers and dates over the last 3 years. What would be the easiest way to validate that every day over the last 3 years is accounted for, and that there are no gaps of over 30 days? I imagine this can get cumbersome so if anyone's got any tips, I'm all ears. Thanks! Brian
add record with if then else
when updating data at form 1, a new record is created at form 2 some fields are directly transfered from form 1 to form 2 this is acomplished with "add record". but form 2 has a field "A" wich value depends on the value of field "B" at form 1. That value has only two possibilities and should be obtained by a "if then else" with the value of field "B" of form 1. how can this "if then else" work inside "add record"?
Open Report with cirteria for subform data
Hi, I have a report based on a form with 2 subforms. I trying to open the report with an url passing as criteria an ID of a subform record. The main form is called Kursanmeldung, the subform Kursplanung. I have tried following variants without success: openUrl("#View:Kursanmeldung_Report?Kursplanung.="+KursID, "open window"); openUrl("#View:Kursanmeldung_Report?Kursplanung.ID="+KursID, "open window"); openUrl("#View:Kursanmeldung_Report?Kursanmeldung.Kursplanung.ID="+KursID, "open window"); when
Create a report with form and sub form fields.
I need to generate a report with fields from form and its sub form. Use Case: I have a form 'Invoice' with invoice #, invoice date and customer. I have a sub form 'Products' with product, quantity and rate. I would like to show a report in this format. Invoice # Date Customer Product Quantity Rate 2 6/16/2017 Customer A Item A 1 12 2 6/16/2017 Customer A Item B 2 10 3
How to create a filter with stored dates
Hello, I have a Date field in my form with the name TransferDate. I would like to create a filter so I have enabled it from the 'Auto Filters' menu. The filter is working like the below image. It shows me 'month - year'. Is it possible to customize this filter to show me all the dates which are stored in the database? I mean the filter to be like: TransferDate: 10-05-2017 28-06-2017 20-07-2017 . . . and when I click the '28-06-2017' then to return me all the records with this TransferDate? Maybe
Group records
Hi guys, Is it possible to group records into one record? So lets say: Department : security / name: Me Department : security / name: you Is it possible to group them on department? so the report looks like this: Department : security , and if i click on it i will see, Name: me Name; you Maybe like a dropdown?
Auto fill field in subform from parent form field
I have a form called "Bed-Tillage" with a lookup field called Section_Setup This form has a subform called "Bed_Selection" with a lookup field called Section What I want to happen: as records are added to the subform "Bed_Selection" I wold like the field Section to be auto filled by the parent form field Section_Setup I tried this in the on load of the subform input.Section = input.Bed_Tillage.Section_Setup; but it creates this error - Error at line number : 1 'Bed_Tillage' is a lookup field
Edit CRM pick list menus
Is it possible to add to an existing pick list menu via Deluge?
Form Layout - Sections/ Horizontal space
Hi, I am trying to improve the layout/alignment of fields on my form and can not see how. Fields just automatically fill down from the top which I guess is OK when using single column but with double column related fields don't always line up. For example if I add a comment field Is it possible to add horizontal padding between fields? (I thought about adding some extra fields and then hiding them but they are still visible to me as an admin)
quickbooks connector
I have written a function to push new customer data to qb using the sample script that zoho gives. the issue is I get a success message upon execution... but it also gives me the following response: Executed Successfully Log messages: java.lang.Object@39c90431 the code: void qbooks.newCustomer(string customer_r_ID) { for each rec in Customers[ID == customer_r_ID.toLong()] { //Declare Map Variable to hold the customer details Customer_Details = Map(); //Add the customer details to the map variable
Help with custom Function
Hi zoho community, I am trying to create a custom function, but with no success so far. I would like the function to add elements to the inventory (stock) and update the status of the element too, having a button for each element row in the report (currently I am trying to use it in the Purchase order form report, but I also would like to have something similar in the purchase detail report). the related forms and reports are the following. Add product form: this form report = inventory product code
Next Page