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
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"?
ZOHO FOR FLORISTS
Hi I want to know If any one using Zoho for a florist business. I also want to ask the Zoho experts if they think Zoho suits florist business?? thanks for your time
- or + until the maximum of
hello does anyone knows how to script x = input.1 - input.2 ( input.2 can't be more than 10) many thanks
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
Count records based on certain criteria
Hi Everyone, Background: I'm brand new to Zoho and have very limited programming experience. I need to count some records based on if they meet certain criteria. What I would like to know is: is this possible to accomplish without learning DELUGE (which would be time-consuming)? I can't see anything obvious myself and a look through the user guide does not show anything obvious either. We have some trainees but I only want to count them if they have completed trainings A, B, C and D from one category
I want to print the pyramid star, but i cant able to print. The value of i is increase when comparing to j
void star() { fruits={"mango","apple","banana","pineapple","watermelon","pomograned"}; i=0; j=0; for each rec in fruits { if(i<4) { for each rec in fruits { if(j<=i) { info "*"; j=j+1; } } i=i+1; info "\n"; } } }
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
Time Line
Hello, i am trying to create a timeline in 15 minute segments using a form, this will allow the user to input a total amount of staff for that task from their preferred start time up to the finish time. my form has the following fields Day Of the Week - Dropdown Task / Duty - Single Field 06:00 06:15 06:30 06:45 07:00 - Decimal fields etc etc so for example i can enter the following: Sunday Class teacher A 06:00 - 0.00 06:15 - 0.00 06:30 - 1.00 06:45 - 1.00 07:00 - 2.00 this should then show in a
Next Page