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
Delete Alert Box Confirmation
I have a delete record button in one of my stateless forms so that can delete a record. The button works fine but I really need a confirmation button so that users don't accidentally delete a record. My Code currently looks like this: if(input.Account_ID != null) { delete from Account[ID == input.Account_ID]; openUrl(("#View:Accounts"),"same window"); } the above script runs when a form button is clicked. I need it first to ask a confirmation with the options confirm or cancel. Again, I just
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
How to search checkbox, dropdown, and multiselect fields in a record for specific input
Have you been trying to search a checkbox, dropdown, or multiselect of a record to see if it matches a specific word that was inputed into a stateless form? Here is how you do it. for each Record in YourFormName { if(Record.FieldName.toString().toLowerCase().contains(SearchCriteria.toLowerCase())) { //do something when you find what your looking for. } } Record.FieldName is the field name in the form you want to access. .toString() will change
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.
CSS Style sheet or google web font in embedded view
Hi, We want to embed a Zoho Creator form in our web site. We of course wants to make the embedded form appear with same layout as the rest of our web site. Is it possible to link to our own css stylesheet 'style.css' and/or a google font type like <!-- Google Web Font --> <link href=" http://fonts.googleapis.com/css?family=Raleway:300,500,900|Open+Sans:400,700,400italic " rel="stylesheet" type="text/css" /> Kind regards, Bo Thygesen
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
Difference between sharing to individual/groups and on role level
I am a bit confused as to what the difference is between sharing forms and reports in an application to individual users or groups compared to giving access to users based on the roles set in Users & Profiles. For my specific applications, under the Share menu, I have set the entire application unshared. But under Users & Permissions I have instead given permissions for all users to access which in return allows all my users to access the forms and reports. I tend to believe, that administrating
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?
sign up
Sorry! Free domains with extensions such as .tk, .cf, .ml etc., are not supported I found this error again and again even my domain is .com but still got this error please help .......
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.
Sorting custom filters in dropdown?
How is the best way to sort my custom filter options in the "filter" dropdown?
Auto Increment ID
Hello, How is the value of the auto increatment ID field created or calculated? I've created a registration database reserving spots at a conference for the first X people who register. Will the auto increment ID always be greater for the most recent registrant--the most recently created record? In other words, I can rely on this ID to tell me the order in which people registered? Thanks for you help.
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];
Using url scripts to show reports for single record
Hi there, I'm slowly getting my head around everything and have built up my app with a couple of scripted features. It's unfinished as yet and I just wondered if anyone could help with some final feature tweaks. I have used a recLinkID URL to draw up a report of a single record, which is working perfectly: void Results.FullRecord(int recLinkID) { openUrl("https://app.zohocreator.com/nathan429/simcentre-hospital-records#Report:Patient_Demographics?recLinkID=" + input.recLinkID, "Same window");
Is there a right way to edit a record and save as a new record?
I would probably save a new record on on validate section and then cancel submit. Is there a better way to do that without an alert message to user? I want to use some records as templates.
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-
How Can People Submit their Tutorials on my Website
I want to make website in which people can submit their tutorials how can i make this type of website what type of things i should do for this I do not have any knowledge of html, programming and any other language (totally zero programming knowledge)
Payment Gateways
Hi Zoho, Is there any plan on integrating Creator with more payment gateways (aside for Paypal)? Stripe would be a good start. Zoho invoice has these 8 options https://www.zoho.com/invoice/addons/. Please advise, Thanks.
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.
creator.zohopublic.com getting a privacy error. My clients are unable to access their forms and data. Huge Issue
Privacy error on Chrome for all embedded forms and reports, this is a huge issue: Your connection is not private Attackers might be trying to steal your information from creator.zohopublic.com (for example, passwords, messages, or credit cards). NET::ERR_CERT_COMMON_NAME_INVALID Need this resolved ASAP my clients are in a 24/7 industry!
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;
Submit by Email
To whom it may concern, We would like to make use of the submit by email feature, however our email system auto appends a legal disclaimer to all outgoing emails. This results in an error and the email is rejected by Zoho. The error is as follows: The Following error has occured while adding this record: Failure, Invalid column value "tel +44(0) 20 XXXX XXXX." specified I have changed the XXXXs as these are our telephone number. Furthermore, what we are trying to achieve is an update of just a
Next Page