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?
Custom Action Edit Function - Not Getting Saved
Hi, I have created a leave application app. In the report , I have added a custom action for leave status ( pending , approved) . I need to send mail based on the approval . I try to edit the function page , but it is not saving. I have attached the screen shot of the function Edit option
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
Offline mobile app
Hi guys, Can i use my custom app offline on the Zoho creator mobile app? If yes, can i get a link please? Thanks!
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.
Fetch Data between different Applications?
Hello, When I fetch data among different forms in the same application, everything is ok. I am using: if(input.Project != null) { dat = Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But when I am trying to fetch the same value in another application, it's not working. I am trying the below code: if(input.Project != null) { dat = Project_Management.Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But it is not working. Can you please help me. Thanks Mustafa
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",
Library Form - Book Issue Return - Synchronisation -Stock upadtion -issue -Return
I have 3 forms for library management - 1) book stock entry 2) Book Issue 3) Book Return book stock has fields like bookId , bookname ,author etc , In bookissue form I am fetching, bookid , memberid as lookup values . when a book is issued to a member the respective book is subtracted from stock and the report shows the details of the member and the books taken by him or her . in book return - when a member returns the books it has to be updated in the stock . (each member is allowed only 3
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
Exporting files
When I export a view with attached files, the output contains a link to the files on Zoho but not the file itself. Can thsi be achieved any other way. I would like to be able to fully back up my data locally. Thanks Roy Watt
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?
How do I run the same functions for On Add and On Edit?
Hello, I have a bunch of functions/scripts that run when a new entry is attempted to be added to a form (i.e. On Add > Validate and On Add > On Success). I'd like those same functions to run when a form entry is edited (i.e. On Edit > Validate and On Edit > On Success). Is there a more elegant way to do this beyond simply copying and pasting all the functions? Thanks!
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
update creator's entires by csv file
hi! There are number of entries in creator's app. Each entry has email field (and info plus text fields): entry1 -> email1 entry2 -> email2 entry3 -> email3 and so on.. And there is an excel file with emails and other info for each email. row1 - email1 - info1 - text1 row2 - email2 - info2 - text2 row3 - email3 - info3 - text3 and so on... how can I update entries in creator's app using CSV file from excel? so that entry1 will be updated with info1 and text1 (email1 <-> email1 are equal in app's
Workdays Calculation
Hi everyone, I've created a function to calculate the number of workdays between two dates. I use it to measure how many weekdays have passed since a record in our action log was opened. Previously, I was using the function suggested here. But this function is recursive and after a record was open more than around 50 days, the stack limit would be reached. Have a look at my new function below. The only limitation I can see is that any holidays are not taken into account. What do you think? int
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
Sorting Lists. Airplanes and Trucks.
I'm attempting to display a single list of airplanes and trucks sorted by due date. Airplanes and Trucks are each different forms. What is the best way to merge records from many forms into an array and sort the array? Here is my attempt and the point where things go sideways. Maybe Keys can help but i'm not sure. What do you recommend? tx,tt //fetch records airplanes = Airplanes [Status == "Active"]; trucks = Trucks [Status == "Active"]; //create and fill lists vehicleIDs = airplanes.ID.getAll();
What's the best way to display aggregate data contained within a form?
Hello, I have a form that contains various data relating to my clients ("Clients"), and another form with information pertaining to my team members ("Team Members"). I would like to manipulate this data in order to provide KPIs that I can easily reference. There are three specific KPIs I have in mind at this time: Gross Income. This one's easy; it just needs to calculate the sum of the Gross Income field in Clients. Total Cost Per Word. This needs to add up the sums of Writer Cost and Editor Cost
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;
Best way to plan a project?
Can anyone refer me to a best practices guide for planning a Zoho Creator (or similar) project out (i.e. how much you should plan a project out before jumping in, etc.)? I'm wary that I'm going about my project in a rather haphazard manner, but then I don't know any better.
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
Search interface returning no records found
Hi, I have built a search interface from two resources: https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#Create-sform https://www.zoho.com/creator/help/application/search-interface.html However it is returning no records found all the time, for any search text. below are my codes for the Search Page: htmlpage Search_Results(searchParam, sIndex, eIndex) displayname = "Kết quả tìm kiếm từ vựng" content <%{ recLimit = 10; if(input.sIndex == null && input.eIndex == null) { stIndex
Where are images stored?
Hi guys, Can anyone tell me where my images are stored? src='/platform/images/logo.png' id='zohocreator_logo' I want to replace this with my logo.
To change text color of disable fields
Can I change the light gray color of disable fields for a black (default) one?
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
Subform name keeps defaulting to previous name
Hello, I've created a subform that I would like to name "Further Details". However, it reverts back to "F" whenever I try to change it. Any ideas why? Thanks!
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
Fetch Data from completed form and insert into new form
hi guys Im new to Zoho, would it be possible to get a little help with my basic problem basically i have a form, lets call it form 1 with these fields - Name - Email I have a second form (form2) - Name (on a drop down menu which is linked to form 1) - Email ..... how do I make the email field from form 1, display in form 2, once the record has been selected from the drop down menu. please be as informational as possible... i've watched all sorts of videos and i cant seem to get it to work Kind regards
Next Page