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
Executing...
When I try to execute my code on the learn deluge website, the button just remains in the "executing..." position, without any output. I've tried restarting my browser, but this hasn't helped. What should I do?
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
Making the Customer Portal Look Great in Zoho Creator
Hi All I am new to Zoho and I want to see if Zoho can be customised for portal user. The portal will need to follow the design of an existing website. How would you do this? and are there any examples I can look at on the Web Thanks for any help. Tony
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
Question about the file uploader
Right now I have a form that acts as a file uploader.. The result of uploading a file is stored in a report. Is there any way to view that report so that I don't have to download the file? The file uploader is mostly used to host images.
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?
Issue when trying to create app
Hi, After enabling Zoho creator in Zoho CRM Plus, I am unable to go on the the app creation process due to what I believe is a technical issue. I keep getting this message when trying to proceed when I clearly am not using any of the characters they mention (please see below screenshot). Would anyone be able to identify the problem and help me out? Thanks!
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
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-
Next Page