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
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
Multiselect based off another multiselect
I have a list of contractors, each of which has multiple employees. I also have projects assigned to the contractors, some projects have more than one contractor -- what I am hoping to accomplish is selecting multiple different contractors from a lookup in the project form, then filter another lookup of the contractor employees, based on the contractors selected. Is this possible? Or is there a better way to accomplish this goal? Thanks, Chris
Built in Search using Not Contains doesn't work as expected.
Hello, I have a for with a multi-select field linking people with sessions they have taken. When I use the built in search function in the report to search for a people who have taken a session containing "Y" I get the expected results but if I search for people who have taken a session NOT containing "Y" I get the wrong results. When I search for contains Y I get 77. When I search not contains Y I get 1416 results. I have 1427 total entries in the form. I expect the not contains Y search to get
Name field type causes unsupported type of form error
When I add a name field (the field with a built in first and last name field) to a form and then view the form I get the following message: Unsupported type of form. Please contact your application owner. Removing the Name field causes the form to load correctly again. Am I missing something?
Call function in page
Hello, I have a created a Page to print a letter an wanted to get the name of the person signing the letter. For this I call a function that I have previousl defined under Workflow. When I print the letter, the function returns no result. What am I doing wrong? here's en extract of the code in the page: <p>Unser Kursraum an der Chutzenstrasse in Bern ist zentral gelegen und vom Hauptbahnhof Bern mit den öffentlichen Verkehrsmitteln innerhalb von 10 Minuten erreichbar.</p> <p>Gerne bieten wir
Open Url - html page - hide headers
I have a html page to print invoice. I open this page using OpenURL through custom functions. When the page is open, it displays with application header and footer. openUrl("https://creator.zoho.com" + zoho.appuri + "#View:Generate_Invoice?invoiceId=" + invoice.ID + "&zc_Header=false", "Popup window"); I would like to see only the html page content without header and footer. Is this possible?
signatures
Hi guys! I have 2 signature fields and i have written on a Windows Microsoft surface pro. But when i go to my reports i don't see the signatures. But if i put write on a laptop or iOS device it works perfect? Can i get this checked please? Kind regards *** THE TEST WAS DONE ON A LAPTOP
Join three tables in report?
I have tables A, B, and C. I can make a report using A + B. I can make a report using B + C. I cannot seem to join A + B + C and have a report that shows **all three**. This is simple in a normal database provided the key values are present. How can I do this?
report critera = null or empty
I am trying to report all open or non-completed. I also have some records that were created before I added the completed field so they are empty or null until I we complete them. I can't seem to find the null function tried "isnull", "" , " " Thanks for any advise. report criteria looks like this completed is equal to "No" or completed is equal to ""
Form Layouts
Fairly new to Creator. I have created a form, seems to work well but there is a huge amount of white (wasted) space. I would like to tighten up the layout but cannot find any options for this. When I look for help in this forum, I see questions from 2008 but nothing recent. Is there a way to remove white space, bring the fields closer together? Thanks in advance.
'on user input' action not using updated field value
I have a form action which update three fields A, B and C; when C is updated it triggers its 'on user input' action and calculates a number based on A and B values, but C is actually using A and B old values, not the updated values. Need help!!
get records from zoho project
Hello, I am using zoho creator and I need to fetch records from zoho projects using api ( like zoho.books.getRecords(...) ) to liste all tasks.
Copying data between entries
Hi Zoho, I'd like to give my users an option to copy data from similar entries on the same form. I've created an "Import request" form, where they choose the entry to copy the data from. I will appreciate help in planning the best way to do this. so far, since there is no "copy entry" command in deluge, only add or update, the script is fetching the desired entry to copy from, and one-by-one update the fields in the user's entry (meaning many many lines of Entry_to_Update.Field_Name = Import_From_Entry.Field_Name ; with
Fill field from other form
Hello, I have this situation on one of my application: Form 1 (Opportunity - see pic1) is for manage the IT opportunities we have; here we have a field "opp_id" which is a numeric field we use to autogenerate the opportunity number; we have other fields like Country(Pais), Prime contractor, etc. Form 2 (Proyectos - see pic2) this form is for manage all the projects once an opportunity is won. The fill-in is based the lookup field "Nro. de Oportunidad" on this form which list all the opportunities
Next Page