Date Validation
I added a validation for a date field to check whether user is selecting a past date. I used below script in On_user_input field action: if (input.Date_field < zoho.currentdate) { alert("Not Allowed!"); input.Date_field = zoho.currentdate; } It works the first time I select a past date but after closing the alert box, I am able to select a past date. I tried this several times and found it to be an intermittent problem.
import multiple CSV file onto one form?
Hi there, is it possible to import 3 different tables onto a form? I have 3 tables that make up one complete set of data linked to a Order. Or then maybe a way to parse a text file with all the data in maybe? thanks for your time? Derrick
report header
hi. how can i add my company name in the header and company address in the footer of my reports.
How to display form data
Hi, I am new to ZOHO Creator. I thinks its simple question for all of you, I have a form "contact us(Name, Cell-No, Dept, Email, Message,)" with report as well.This form is embedded in one page , say 'index'. I want to display some specific fields like only (Name, Cell-No) (Cell-No, Message) or any combinations of fields in different page say 'details'. Any one , help me with this ..???
Newbie needs help on App concepts
Hey there... We need an app that will track each of our clients' biz process. So it's kind of like a CRM on steroids. In addition to name, address, phone number and contact info, we need to be able to track dozens of items on a per company basis. We understand how to create the forms for that information, just unsure how to have that form for EACH different company, where we could search for co name and pull up records and edit, etc. for one company and then for another company. Is there a good
Creat Gantt Chart using data from Creator
Is there a chance I can create a gantt chart in Zoho creator? What I really wanted wasto use a annual calendar to show rooms booked between dates, something like this: http://www.filebuzz.com/software_screenshot/full/hotelogix-45716.gif I think i could twick things with a gantt chart
Data communication between state and stateless form
This is the scenario. I've question form with single select question field. When I select the question, it has to popup answer stateless form. Once I click ok button, data which I entered in answer stateless form need to go to the question form. I'll submit the question form, once after collecting all the answers. I've the following issues, 1.I could pass data as querystring from question form to answer stateless form. But the vice versa couldn't. 2.Once the answer stateless window popup, question
Call function from a form field and pass a value back to another field in the form?
Is it possible to call a function from a Field On User Input and then have that function send data back to the form? Either to the same field or to another field within the form? I realise i could update a value in an existing record but in this case i want to pass a value to a form which the user is currently filling in. Form 1 Field 1 => calls Function => Function calculates some value Field 2 || Field 3 <================ Function passes value back to field
Is it possible to fetch the total quantity of an item in a report?
Hi, Is it possible to fetch the total quantity of an item in a report? for example I have a report with all the requested items, I grouped this report by description. So if 3 people ordered 2 apples each I will have 6 apples as total for this item. Then I have a Purchase Order form with a subform to add the products. There is a lookup field in the subform. I will like that when I select apples in the lookup field then number 6 is fetched to the quantity field of this row in the Purchase Order's
Lookup's not working.
Is anyone else experiencing problems with lookup's? all of my applications are not working and I have 2 accounts. Not really sure if it's a global problem or just my accounts. I opened 3 cases with support and haven't heard anything.
Multiple CSV import to single form
Hi there, is it possible to batch import 3 different CSV files onto one form? thanks, Derrick
GCM connectivity using PostURL
Hi everyone, Im trying to send data to Google Cloud Messaging server using zoho creator... Here is what i have done so far... P.S. - postfields is a JSON array. void api.apiCall() { httpheader = map(); httpheader.put("Authorization", "key=A************************************"); httpheader.put("Content-Type", "application/json"); postfields = " {\" registration_ids\":[\"sEvg******************************\"],\"data\":{\"message\":\"my message\"}}";
hyperlink
hi. in my online booking form i would like to create a hyper link in order for the customers to click and get to the terms and conditions page. can someone please tell me if it can be done and if not any other idea to achieve it. kind regards.
Anyone integrate Zoho Creator with EchoSign or DocuSign
Have a business need to prepare documents in Zoho and then integrate with EchoSign, or DocuSign, or any other like service that might work easier/better. Anyone have any experience doing this that would be willing to share info? Thanks.... Steve Henry
Search and Sort by Multiple Lookups
We are a community college. I have one report for instructors and one report for course schedule. I want to create a Course_Schedule_Search form that allows the user to pick an instructor from a lookup field and, in a multi-select lookup field, show only those courses in course schedule that the selected instructor is teaching. However, I'm having trouble with the "on user input" code. I keep getting an error, and I think it relates to the ID. Here is my "on user input" code for Find_Instructor
Edit record using record ID and pass parameter without displaying zoho header and application components?
Alternatively, you can also use the default functionality of Zoho Creator to view and edit individual record using its record ID. The following url will display the form alone without displaying top header and other application components. http://creator.zoho.com/<userName>/<applinkname>/<formlinkname>/record-edit/<viewlinkname>/<recordID> Is it possible to edit a record in the above mentioned way and also pass a parameter to the form?
Date Validation between two date fields
Do you have an example of date fields validation? I have two date fields (from, to). I would like to check if the date in FROM field is earlier of the To field then it's ok...If the date is after or same to To field then give an error message. I know how to do it in javascript but I do not know if it is possible to do it here.
Help with script for custom action
Hi, I have a custom action that works fine for the form's report it was created. In this main form (Requisici_n_de_Compra) there is a subform (Detalle_RC). I would like to have the same feature for the subform report. this is the script that currently works for the main form report. void PostInv2(int PurchaseID) { proRowData = Requisici_n_de_Compra [ID == input.PurchaseID]; for each r in proRowData.Detalle_RC { fet = Agregar_Producto_Almac_n [Descripci_n == r.Descripci_n];
API Call with Authtoken in url not working
Hi, I am try to make the api call to following url - curl --data "notificationCode=766B9C- AD4B044B04DA-77742F5FA653- E1AB24¬ificationType= transaction" https://creator.zoho.com/api/zoho_rahul179/xml/demo/form/TransactionID/record/add/?authtoken=mytoken&scope=creatorapi But I am always getting the 2899 error, I have given the public permission for entering the data to my form. The problem is that I cannot pass authtoken and scope as POST data variable. If I do like this - curl --data "notificationCode=766B9C-
Transfer a file from Creator to Box?
Is it possible to transfer an uploaded file in a form to Box.com (or any other site) using the API or cURL or Post URL or by any means? Thanks!
Stateless Form button error in App View
I have 2 stateless forms which perform search functions. When the page reloads to the left of the search results the buttons do not display correctly. In the app builder they appear normally on reload but in the live app on reload they are repeated numerous times down the page and have the form_field_name on them. The only code in this page is 'on click' to specify the Search Parameter; childname = Child_Registration [ID == input.Search_Child]; searchParam = childname.Child_s_Name; openUrl(((((("https://creator.zoho.com/"
Passing in parameters into a hidden field in a view
I would like to pass parameters into a hidden field. There are some things I pass into a view on load via URL that I would prefer my users didn't see.
Displaying an image in a HTML page
I have a Child_Registration form with an image field and a HTML search page that fetches and displays individual data from this form. I want to include the child's picture (Photo_ID) but it always displays as a broken image. I have looked at all the guides and information on images but can't seem to get the right code so the image displays.
Mobile Form showing hidden fields.
I have a Form that in the browser is behaving correctly. i.e. it hides a field until a rule/task is activated and then shows the form field. However on the mobile device it behaves differently. On initial load the field appears. Other rules within the form behave correctly. I have deleted and re-created the rules as well as the form fields but each time it is the same. Can you please provide any assistance as to the cause? Thanks Kevin
Logo or Image insert in a form or Page in add note
Dear Sir I have created one form having two field "Name" and "Image", and update data with company logo and create a function module for fatching the logo Code as follows string Pipeline_Management.Image(string name) { imagelnk = Image[Name = input.name].Image; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","#View:Image_Report"); imagelnk = imagelnk.replaceAll("fieldName","Image");
why checkbox automatically deselects and how to sovle it?
hi there is list with 2 variants of checkboxes checked variant_1, before script variant_2, after script script is " // search entry by ID record = zayavki_form [ID == input.record_ID]; // check on in a list "email_process" // value of checkbox "subscription_page_visited" // (in input.email_process variable) record.email_process = input.email_process; " why after script execution "SMS_subscription_sent" is unchecked?
How can I make an Autonumber Creator field visibile?
Is it possible to make an autonumber field visible ?
why there is a endless loop for .remove() ?
hi try remove "On User Input" some characters all works well but interface views that there is a endless loop of operations code "On User Input" mob1 = input.mobile3.remove(")"); mob2 = mob1.remove("("); mob3 = mob2.remove(" "); mob4 = mob3.remove("+"); mob5 = mob4.remove("-"); input.mobile3 = mob5;
Invalid JSON String Format
Hello, We are trying to fill-in the pincode of a customer through an API call. The API returns the values in JSON format such as: {"query":"Delhi","pincode":"110001"} If the pincode cannot be found, the API returns with the values such as: {"query":"Searched Address","pincode":"","error":"Not found"} We get a "Invalid JSON string format" error when address fields are left blank on add customer record form. The code we are using to make the API calls is: if (input.Address_Line1 != null || input.Address_Line2
how to set admin permissions to notes?
hi! need document all fields by notes there are more than 50 fields how can i set for notes view permissions "Admin only"?
Add product detail in PurchaseOrders of CRM
Hello, i user ZCREATOR to create PurchaseOrders in ZCRM. I put only Product in a List as itemsList = List:Map(); ..... For each ligne in MyView..... { itemsList.add({ "Product Id" : ligne.ID_produit_ZCRM, "Unit Price" : MonProduit.get("Unit Price"), "Quantity" : newQty, "Total" : newTotal, "List Price" : ligne.Prix_achat, "Net Total" : newTotal }); } My ItemsList is full with product. responseCreate = zoho.crm.create("PurchaseOrders",{ "VENDORID" : idFournisseur, "Subject" : Subject, "PO Number"
can't able to imort app?
When i just trying to import app as a .ds extension it shows me Invalid Request
Dropdown field is showing "Other" option
We have a Creator application where we are tracking Customer's visit activity. Currently the Activity dropdown field has 4 options: Buy - Yes Buy - No Decision Pending Return/Exchange When adding a record, we get the desired 4 options. However, on the edit screen, Creator shows an additional option - "Other" as shown in the image. We suspect it has something to do with the On Load screen of that form but can't really figure out whats the issue. Any help would be appreciated. Thanks!
lost field in report!
hi! previously was made a report all works well few days ago lost 1 field "дата доставки" in field it is, but in report there it is not how to solve it?
What is wrong with this code?
I am new to Zoho Last_Purch_Price, Sup_Cost_Factor, & DPI_Cost are decimal fields, Units_in_Purch is a number field In the same form. I want to calculate the DPI_Cost, but only if there are valid values in the 3 fields needed for the calculation I tried to enter this code in the On User Input field action of the DPI_Cost field: if(input.Last_Purch_Price != null && input.Sup_Cost_Factor != null && input.Units_in_Purch != null) { input.DPI_Cost = ((input.Last_Purch_Price * input.Sup_Cost_Factor ) /
Searching in a lookup field
I am trying to set up a search page based on a lookup field (Child's Name). This generates the ID number. The search field (Search Child) is defined as a Bigint but in the HTML page the searchParam is defined as a string even though it is actually a number. This means the searchParam never matches the Child's Name field. I tried changing the searchParam to be defined as a number but it gave an error saying it was trying to update to a different data type. How can I adjust the code so the search
Child fields
Hi all, I am building a simple database and I would like to focus on 4 forms : Companies: legal company details Addresses: a list of addresses, zipcode, city, aloso defined by an "address name" Sites: association of a company and an address, because companies may share the same address. I have two lookup fields by company legal name (relation to Companies) and address name (relation to Addresses) People: all details for on person with a lookup field to Sites, so that each person is linked to a site,
Filtering Lookups
I am a newbe to Zoho I have three forms: Inventory (with among others 2 lookup Fields, Product_Class and Product_Sub_Class) ProdClass (with one field, Product_Class) containing all unique ProdClass in ProdSubClass ProdSubClass (with 2 fields, ProdClass and Product_SubClass) containing all valid ProdClass and Product_SubClass combinations The Product_Class lookup of ProdClass works fine. I want to filter the Product_Sub_Class lookup to only include records where ProdSubClass.ProdClass = Inventory.Product_Class
Fetch and Update
Hi, I have a form "Lesson Items" with the dropdown field "To_Do". I have a second form called "Plans" that has a lookup field to "Lesson Items", and (also) a dropdown field called "tasks". I already have it set up to pull in the values of the lookup items "To_Do" field and populate the "Tasks" field. That works fine. But what I want to do is make it so that when I update a "Lesson Items" form, it will update any "Plans" forms that have the same ID in the "Lessons Items" lookup field. I have tried:
Subform Record Delete Behavior
Hi, Can someone confirm for me that as soon as i click the "X" delete button on the subform, that record is deleted, regardless whether i Submit the main form or not. Is there any official documentation about this behavior? Is the subform On Delete script executed before or after the subform record is deleted? Again, can't find any documentation that addresses this.
Next Page