How to OPEN rather than DOWNLOAD (??)
Hello from faraway New Zealand I am trying to add a link to a PDF document from a Notes field on a form. It is a print version of the form in PDF format. This is something the client has asked for. Unfortunately, the file downloads rather than opening. This is the URL format I am using for the link: https://creatorexport.zoho.com/workingwise/pacrad/KeyDocEdit/654604000011936102/File_upload/download/1473212208812_PRG_Induction.pdf Can somebody please tell me how I can amend this URL so that the document
Logo/Image insert in the form
Can some body tell me how to insert or add image / logo inside a form thru Add Note. if somebody can tell me in detail, it would be greateful.
Is there any options for the 'file upload' field to upload more than one file?
Hi, I have 'file_upload' field in myform. I want to select & upload more than one file at a time. Don't want to use more than one file_upload field. Is there any option to set in file_upload field. Thanks for your help, Appadmin
Sending Emails with Attachments
Has anyone written a general purpose send email function that can send emails with attachments using the ability of schedules to send emails with attachments?
How is the search button working when we have a blank subform in a main form?
I have a main form which has a Subform (blank form) like the following image (Hotels is a multiselect field) In the report I would like to show the Hotels and Category (from the Subform) so I did the following (using a comma separator): So my final report is like: Well my problem is with the search in Remarks.. When I write 'Remarks Contains Promotions' then it returns me only the first record which is correct When I write 'Remarks Contains Issues' then it returns me only the second record which
Open form to edit a specific record with page header
I'm trying to open a specific record to edit, following this guide: https://www.zoho.com/creator/help/views/editing-records-via-record-id.html Link example: #Form:Parent?recLinkID=3032879000000050091&viewLinkName=Parent_Report But I can't make it open with the header on the edit page. This is the header I'm talking about (appears when using the add record form): When I open from the link there's no header: Is there a specific parameter to make the edit page display the header?
postURL and getURL not working for Delete -> On Validate
Hello The deluge code for Delete -> On Validate on the form actions in the form builder is headers = map(); result = getUrl("https://www.zoho.com/creator/", headers,false); info result; cancel delete; And "result" variable is always {}. Should it at least have "responseCode" and "responseText" ? The "cancel delete;" is present on the script to prevent delete during the test phase, since I need to delete (or not delete) depending on the response from a 3rd party service, and the responses are not
Summing up total price in the Order management tutorial
Good day. I am new to Zoho creator and I have been following the Order management Tutorial. I got stuck at the Advanced scripting Tutorial 3 I have copied the code as it is, following the tutorial step by step but the code is not working at calculating the total price of the items. The "Total" field is disabled so user can't edit but the default value "0.0" is not showing and the total products price is not showing. I tried walking-through but I think it might relate to the variable "itemID" used
Fetch Lead Owner Email and pass into Lead Record
I'm trying to fetch a lead owner's email address and pass it into a custom field that I created whenever a Lead Owner is created/updated. So far, here's what I've come up with: I've been able to grab the lead owners name and lead Owners ID but I'm still not sure how to associate the ID/Name with the Users Email address and then pass it into the lead map. Please help! lead = zoho.crm.getRecordById("Leads",input.leadID); leadMap=map(lead); leadOwnerName=leadMap.get("Lead Owner"); info leadOwnerName;
Limiting Class Size/Available Seats For Scheduling Sign-Up App
Doing some planning for a simple application and wanted to make sure I'm going about this the easiest way possible. Purpose of the Application: Allowing people to sign up for seats in our workshops (classes) Information Displayed for Workshops: Date, Time, Location, Name/Topic of Workshop Average Number of Workshops Listed Per Month: 10-15 workshops Number of Seats Per Workshop: 12 Ideally, the display I have set up would allow clients to filter their search results by location (two different locations)
why was "null = zoho.loginuser" statement inserted?
Hi, Below is my insert statement. But the line "null = zoho.loginuser" was inserted when I access the application. Moreover I'm getting error when this statement was executed. Please help me to resolve this issue insert into SelfAssessment_Report_Form [ assessmentNo_SelfAssessmentReport = input.assessment_SelfAssessment_State category_SelfAssessmentReport = "Category1" noofYes_SelfAssessmentReport = 0 noofNo_SelfAssessmentReport = 0 noofNA_SelfAssessmentReport = 0 noofUnanswered_SelfAssessmentReport
Why are some forms limited in the types of fields I can implement into them?
For instance.. Between two similar forms on my app on the left side there are almost twice as many field types I can choose from.. I am editing a form and want to implement a 'file upload' field into it but there isn't even an option of the left-hand side to drag a file uploader onto the form. How do I get around this?
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;
Next Page