Incomplete expression Else If
I'm stumbled. Please help ! Why "Error at line number: 12 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" (Line 12 is at the Else If) { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Confirmed" message:"Your message" content type:HTML ] else if(input.Assessment_Status="Not Successful") { } sendmail [ from:zoho.adminuserid to:input.Email subject:"Not Successful" message:"Your message" content type:HTML ]
TLS v1.2 upgrade
Hello everyone, We(Zoho Creator) want to let you know that we are upgrading our TLS standards to the latest version 1.2 which is more secure and meets the updated PCI standards. We will be retiring the support for TLS versions 1.0 and 1.1 on 31 August 2018. After this date, all our users will be required to update their processing solutions to TLS v1.2 for the secure transfer of data with us. What is TLS? Transport Layer Security (TLS), formerly Secure Sockets Layer (SSL), is the old security
Number field + stepper
Hi, any chance to have a Number field with stepper? Example: Number field, default is 100 and I would need to add or remove step 1 by using (+) or (-) "buttons". Ja
Stateless form
Hi, how to create stateless forms and how to customize the button in creator5.
SubForm field updating form field record and Auto Number
In the below Workflow, identifying re update the filed is not working well for each row in SubForm info "Add Stock in Inventory" + row.Part_Name; rec = Add_Item[ID == row.Part_Name]; rec.Stocks_in_Inventory=rec.Stocks_in_Inventory + row.Number_of_Items; } I want to use Auto numewber to fill the Form Field but it is getting generated only on submission. I want to add Text + Auto number for some filed. What is the option
Zoho Creator - Dynamic Lookups
HI There, I have read multiple threads around using sub forms and looking up certain data in the sub form but I'm struggling to get anything to work. My problem is as follows: I have a main form called Service_Request and in this form I have a filed called "Account1" and a sub form called "Service_Address". The "Service_Address" subform pulls through several fields from the "Service_Address form including the fields, Site, Building_Name/Number, Address_Line2, County, Post_code. I also have a field
portal do cliente
pessoal, tenho uma aplicação no zoho creator, construída antes do creator 5. ontem instalei uma nova aplicação, sendo que utilizei um modelo. na primeira aplicação (antes do creator 5) não aparece uma tela relacionada ao portal de cliente, inclusive ela remete para a versão anterior. na segunda aplicação (após o creator 5) aparece uma tela relacionada ao portal do cliente. Isso tem prejudicado meu pojeto, porque não consigo vincular ao meu domínio.
Detail View of Report on Zoho Creator 5 not showing 3rd level subform data
Hi all, So I want to show on a detail view of a report data of a subform which belongs to a form that's a subform on the form in which de report is based on. Form 1 (Report based on this one) Form 2 (Subform on Form 1) Form 3 (Subform on Form 2, this one has the fields I want to show on the Detail View of the report) The thing is that I select the 3 fields of the subform that I want to show, delimited by a space, but when I go to the report, the fields that I selected are ignored and it shows me
Zoho Creator - Salesperson Login
Would Zoho Creator allow each salesperson to login through a portal and enter their own sales order and not be able to view other salesperson orders? Thanks
Events in mobile's own calendar
Hello, Is there a way to send events to my customer portal users to their cellphone calendars? For example, when you have a flight to take, you recieve an email with the date and time and then it automatically appears in the cellphone's own calendar, (not Zoho calendar) I would like to send events and post them in the user's cellphone calendar, (not Zoho calendar), through my app which runs under the customer portal
Point of sale
Hello, I have tried to put this point of sale for one of my clients, integrating the entire zoho one suite, but the point of sale fails and fails and fails again, we have made it from scratch three times, and in the end it fails, I can recommend a point of sale that is from another brand, but that is integrated with Zoho inventory, because we can no longer waste time with this app my case is 1093529
POST request to attach file
Calling on ZOHO Creator gurus! Can anyone tell me if it's possible to post file attachment using Deluge? I'm developing app that works with ZOHO Books sales orders module. When client 'accepts' quote, application generates PDF file and attaches it back to a Sales Order record in ZOHO Books using API: https://www.zoho.com/books/api/v3/#Sales-Order_Add_attachment_to_a_sales_order
customer portal - different permissions for different users
hi in customer portal there is same permission level for all users how can i make different permissions for different users? oк make to see different sets of views and forms for different group of users? group1 - set1 (view 1,2,3, form 1,2,3) group2 - set2 (view 4,5,6, form 4,5,6) "You can share select components of an application (forms or views) or the entire application with the members of your portal. All your users will have the same level of access privilege. Access privileges can be revoked
Ask the Experts 3: Live Q&A: Find out all about sharing your Zoho Creator application with other users.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be shared with other users — be it people within your organization or even outside. As an admin of the app, you can share the entire application or specific components of the application with your users. You can add users and permit them to access, edit, and modify relevant data and app components. In this month's Ask the Experts session, we would like to address all your questions related to sharing your
Calculation errors in formula to compute age
I'm using the suggested formula to compute Age from DOB, but random errors are occurring in a View. Manual update of DOB fixes individual Age fields. Given that a formula should be updated when a dependent field value changes, Using 'zoho.currentdate ' - since it changes daily - would be thought to cause recalculation. Do I need to perform some process to force all records to recalulate (for instance, sort on Age)
Report-Pivot-Chart - View underlying data
HI, when the "View underlying data" is flagged a view related to the specific graph element is opened. This is a very cool function. Is there a way to select what columns let to show and what column hide? tks, Pippo
Zoho creator with payments integration
Dear all, We need to create a form with payment option which payment option is best for us. Can you please help me to integrate based on that payment gateway we didn't have any account like paypal account etc..
Access control issue with links on lookup fields
Hi Everyone, If you follow few basic steps below you will find security issue I am really concerned about. 1. Create Form1 2. Create Form2 3. Link Form2 in Form1 with lookup field 4. In Detail View > Layout for the Form1 Report enable lookup field to link to Form2 data with URL 3. Restrict User1 with permissions set to access Form1 (do not allow to access or see Form2 at all, untick all boxes for this form in permissions set) 4. Login with User1 and click on link in Form1 which links to lookup record
Expression Error
Hi, I have a Form by name Document_Library which has following fields. 1. Document Type 2. Document Reference Number 3. Cargo Arrival Date Field 1 and 2 is updated much before the Cargo Arrival date. To update Cargo Arrival date, the user has to search by Document Reference Number. For this I have created a stateless form which has got Document Reference number as a lookup field. x = Document_Library[ID == input.Document_Library]; openUrl("#Form:Document_Library?ID=" + x.ID,"same window"); On clicking
Import lookup field
Hello Is it possible to import data with a lookup field ? If yes, what do I have to import (id of field, unique value of field) ? Thanks for your help Regards
PHOTO ATTACHMENT FORCES ZOHO LOGIN REDIRECT
Hello I am still using Zoho C4. When a user submits a form-mobile with photo attached it forces the zoho login page. Not sure what is happening. This was always a problem in the past, but now it is starting to occur for a large set of my users. Before we thought it was the image sizes being too big, but we had our limit increased and it stopped happening.
How to Change Report Options
So I have two questions that I am unable to locate answers too in the help area. 1) In a report, the search drop-down shows fields I do not want people to be able to search by. How do I change what fields can and can not be searched by in the report? for example, I have some image fields and I do not want people to be able to search by those fields in the report. 2) Along those same lines there is the more options function in my report that i would like to get rid of completly, unfortunity the only
Use data from ZOHO CRM
Hi all, is it possible to use (read only) datas from the CRM in the ZOHO Creator? We need customer informations like address and ordered products. Thx for help!
Print multiple sub form items in Record Summary - Separate Rows
I need help with printing multiple rows of orders that are submitted into a subform in the main form report record summary. At present, the record summary will combine multiple row items into a single cell. How do I get multiple rows to print? The items are separated by a comma, but I cannot figure out how to get to print on multiple rows individually. Please help!
output window is not displayed in learn deluge
when i try to execute the script .i cannot find a console to show the output
Has anyone had issues after creating a new form using an existing form as a template?
I needed to split one existing form into two so I thought it would be faster to create a new form using the existing one as a template then remove from the new form, all the fields I didn't want then do the same with the existing form. In other words I want split Form A into two forms Form A & Form B. So create Form B, using form A as the template. Remove fields I want to keep on form A from Form B and vice versa. Now the problem is that after I did that, I could only remove some of the fields
Update a record from current subform to another form
Hi, I am trying to update record from a current subform to another form, but failed for many times. Here is my case: Current Mainform: Inspection(Inspection_Nbr(SingleLine), Inspection_Date(Date), Product_Supplier(Lookup), Inspection_Subform(subform)) Lookup Field: Product_Supplier -- Supplier.ShortName Current Subform: Inspection_Subform(Item(Lookup),Quantity(Number)) Lookup Field: Item -- PO_Subform.PO_Prdt Another Form: PO_Subform(PO_ID(Lookup),Item(Lookup),Order_Qty(Number),Inspected_Qty(Number),PO_Prdt(SingleLine))
Fetch Records Help
I have been through several of the pages that describe how to fetch records from 1 form and use in another, but I still am having a problem. Here's the set-up: Form 1 collects the name of projects in Project_Name field Form 2 collects a list of tasks and due dates for various projects. Form 2 uses a look-up field to provide a drop-down of the Project_Name field from form 1 - in form 2, this field is labeled Project - below is the code, which is still returning a numeric value for Project_Name in
Zoho Creator report grouping record counts?
Is there a way to show the record counts within groupings? For example, if I am grouping records on a date column, can I show the number of rows for each date? Thanks in advance!
What has precedence when you need to hide/show fields on a zoho creator form
I am working on an enhancement to an existing application and reducing large form to a series of smaller forms. There is a lot of business rules that will mean that some fields will need to be hidden until certain values are set on the form, there are others that will result in fields being shown or hidden as the forms are progressed. Some will be set on forms as a result of other forms having certain status values. I know fields can be hidden using the automation rules and tasks also using the
Send subform data with posturl
Hi, Does anyone know how (or even if it's possible) to send data from a record that includes the related subform data to an external api using posturl or similar method? I need to populate my external accounting application with invoices and their related line items from my Creator app. I'm able to populate the invoice data correctly but I'm not sure how to get the related subform data (line items) over as well and can't seem to locate anything specific in the forum or help guides that demonstrates
Dynamic lookup through different applications
Hello, I'm trying to configure a dynamic lookyup between two different applications. In an anagraphical application A I've a table called "Activities" with these fields: "Area" (lookup field that get data from another application A table) and "Activity" (input text). And this is ok. In application B I've a form called "Race Activities" in which I use a lookup field to choose an area (and this is ok!) and then I need to populate another lookup fields with application A, table "Activities" datas, filtered
Zoho creator, Deluge script very buggy
Hello, I'm relatively new to ZoHo creator. I was looking for a RAD tool in which some coding was possible. We also need the possibilty to make external calls. With the 'postUrl' function, all this seems possible. After two weeks now, I find myself continiously struggling with the internal mess of Zoho or Deluge: - scripts crash, without having the possibilty to catch the errors; - loops in scripts suddenly crash at random points with non-informative error messages. These crashes seem to be caused
Run out of list fields and need to add more to a form.
I'm working on an existing zoho creator application for client and they have 84 list type fields. Now the information I have found on the help system is that there are know problems with having more than 30 list type fields on a form. Now I notice that you can add html code to a note field, so would it be possible to create a drop down list and radio buttons list using html in that field and once a value is selected copy that selected value top a zoho form field to be saved when the form is submitted
Convert Rich Text to Multi Line
Is anyone aware of a way to convert a rich text string to plain text such that it doesn't contain all the formatting html markup? Here is the situation: Users enter notes into a note field. Upon saving the form, any new notes are copies from the notes field (rich text) to a multi line field (for use in a downstream system). The problem is that when the notes are copied to the multi line field, the multi line field now contains all sort of rich text html markup for the formatting. Example: <p style="background-color:
Creator IDE
Hello All, Firstly sorry to ask such a basic question, just starting out. I am beginner with creator and have been trying to check out how the sample inventory application code has been set up. I have downloaded the .ds file from application IDE. Is there a specific IDE that is suggested to view/edit/work with the code? Trying to directly work with the Zoho application takes a while since my internet is intermittent/slow. Thanks much Sowmya
Unable to change Lookup DisplayType in Zoho Creator 5 once selected
I'm unable to change lookup fields in Zoho Creator 5 once I've selected the Display Type (Its grayed out). See screenshot attached In previous versions I could change the Display type after the fact. Has this changed? SC
Calendar Report - Change Today Colour
The background colour of the current date (today) is a very subtle yellow. It would be better if we could customise this as sometimes it is difficult to see with the white background!
How to set Monday is first day in Chart filters?
How to set Monday is first day in Chart filters?
Custom Reporting on Zoho Creator Application
Hi All, we have finally found out that Zoho Creator is a much better application for our business needs. I am stuck at just one point which is custom reporting. I am using a similar application like Fleet Hub which registers Driver & Vendor Information. What we were looking for is individual reporting of these drivers with a better print report. I am currently using creator 5 and having a hard time to understand how to make Custom Reports. The form will have a logo and form information in header while
Next Page