Zoho Creater Custom Actions
I installed the default module "order management" within this module there is a page called "active" which shows all active purchases. Within this, there is a custom action with the following script. void purchase.postToInvent(Purchase purRow) { proRowList = purRow.Add_Product; for each proRow in proRowList { fet = Products[ID == proRow.Product]; fet.Available_Stock=fet.Available_Stock + proRow.Quantity; thisapp.inventReportColor(fet.ID); } purRow.Order_Status="Received"; purRow.Handled_By=zoho.loginuserid;
Just getting started Need to create hyperlinks
I am just starting the process of possibly migrating all of my systems into Zoho. This question may be answered somewhere in the help files, but I have been through the 15 videos and didn't see an answer. I have a single line text field which contains a ticket number. I need to concatenate a rather long URL (www.specialsite.com?ticketnum="[value of ticketnum field]. I need to be able to click on this and launch the web page either in a new window, or at least a new tab, I believe that this will
Form Data in Email no longer formatting correctly.
I have forms coming to email with all form data in body. They use to arrive formatted correctly. Starting last week, they all come broken now. Shown below. Please help. User submitted data Are_you_18_years_of_age_or_older :Yes If_no_why_not : Email : May_we_contact_your_supervisor :null Address :test Your_Job_Title : Reason_for_leaving1 : Employer_s_Phone_Number : Present_Last_Employer : It use to be like this: User submitted data First Name John Last Name Doe Address 123 Main St City Sunnyville
Chat Bar in Zoho Creator
Apologies for this probably very basic question. Is there any way to permanently disable the chat bar from taking space at the bottom of the browser window? You can collapse the bar to the left by clicking << but it comes back every time our users return to Zoho Creator. Many thanks in advance.
EPSON Printer
Hi, Is it possible to print a record on a epson printer? FOr a receipt? Thanks!
Get Territory
Hi Has anyone managed to retrieve a Zoho CRM Users Territory (or territories) using deluge script in Zoho Creator ? I've tried GetUsers but this does not return the territory in the resultset. Thanks in advance.
Search Zoho entries using Zapier
Hi Zoho, I'm using Zapier, and on the workflow I need to be able to search in a specific report (to see if a relevant entry was made) How can I do this? Thank you Ravid
Send confirmation email question
Hi All I am using the send confirmation email function on a form upon the user creating a new record. One on the fields on the form (Name field) is a look up to another form. I am using the code below to address the user by his/her name, however the code below is referencing the 16 digit unique code, not the actual name of the user. How do I overcome this and add the name of the person to the email, not the 16 digit code? Hello <%=Assigned_QS%> Please help!
Push CRM Attachments to Creator
Is it possible to push all Zoho CRM products attachments to Zoho Creator? For ex: I want the attachments in 'Zoho CRM Products' to be uploaded in Zoho Creator Form file upload field.
Create a Report of Child Records Which Includes Parent Data and Data From a Table Only the Parent is Related To (Example)?
Dear Developers, I have been playing with ZoHo Creator for a little while now, I really like the minimalist IDE they've come up with, this sure does feel similar to writing code in Java, except for some syntax differences... I'm happy to learn something new! Anyway, I am having a difficulty conceptualizing my report design in ZoHo Creator. Essentially my goal is this: To display a Report (a List) based on the Child records in the database which incorporates data from key fields in the Parent table.
code on success
I'm just getting started with zoho, so please bear with my ignorance. I'm building an inventory system. One form holds the parts, and the second form if for my technicians to enter what they are taking/return to/from the inventory. Correct me if I'm wrong on this: Tech comes into the warehouse and takes a part off the shelf. Enters a record in the second form indicating that he has taken the part. Now I have two decisions to make? First is who is the tech? He has selected his name from a drop
Changing number field to text
I have created a form with a number field. We have so far generated around 400 records, now it has been identified that we actually need to be able to replace the number field with a text field. Is there any smart way to implement this or is the only solution to create a new text field and update all records manually to move the data entered so far in the number field to the text field?
Easy CSS Styles for your forms
Hi ZC users, Just whipped up a little ZC function that makes it super easy to customize the look of ALL your forms in all your applications. I got tired of having to make markup changes in many, many html views and links when using the customization parameters. Here's the code.. Also, this is up on the marketplace as well. string style.getFormStyle() { /* Author : -Stephen Rhyne -Owner -Rhyne Design -stephen@stephenrhyne.com -http://stephenrhyne.com Created : 11-25-09 Version : 1 Copyrights :
UnPredicable exception, Invalid statement found Line:(4)
I've recently deployed my Creator app to a client and he's receiving errors that I can't reproduce on my development account. One of these is "UnPredicable exception, Invalid statement found Line:(4)" when a custom action is run. The first few lines of the function called are: void CustomizationCompleted(Customization_Form Pers) { OrderID_List = List(); for each P in Pers { //set Personalization Complete to "Yes" P.Customization_Completed = "Yes"; TheOrderItem
How do I import people's availability from spreadsheet and generate a calendar?
Hi Zoholics, How do I import a spreadsheet of people's availabilities? I've been using Zoho Creator as part of my attempt to create a client/provider availability calendar, and although the form What I Have I have a spreadsheet (attached to this question as a Google Sheet) similar to a CRM format. The information represents students' names, ID#, and availability. Each availability time-slot is represented as a column - F1 for Monday 1st Period, G1 for Monday 2nd Period, H1 for Tuesday 2nd Period,
Copy records from one subform to another using function
Hi I have 2 parent forms with the same subform, the subform also contains lookups to the parent forms. In the first parent form I have a function that lets me copy over the records to the second, this works for all the standard fields, I'm having problems copying over the subform rows/data. 1. How do I 'access' the subforms fields for the function, at the moment I have something similar to this: void copyRecord(string First_Name, int CountryID) { insert into Parentform_2 [ First_Name
How to make a decision box unique inside a subform?
Hi there, first I want to say that I have less than basic programming skills. Anyway...I have managed to build my own application with some little scripts. But there is one thing I can not solve: In a form I am using a subform where I enter more than one lines. One of the fields is a decision box. Now I want to manage that only one decision box can be active. So if I check e. g. the box in a line all boxes in the other lines should be unmarked (if marked). Any idea how to script that? I hope the
Product contains product?
Let me start by saying I have barely even started using Zoho Creator. I am trying to verify it will do what I need before investing much time into it. Please forgive me if this is a dumb question :-) Also, I'm not sure how to even begin searching for this, so I hope this is not a FAQ. It is easy enough to explain, but I'm not sure what to search for. I know I need a lookup, but I need a lookup to the same table. I sell products, and some of those products are made up of other products. The easy
Changing Font size on zoho creator?
https://help.zoho.com/portal/en/community/topic/adjust-font-size-in-zoho-creator this is a post from two years ago, does anyone know if this has changed? is it possible to change the size of the font?
Auto reload reports in Creator
Is it possible to auto reload reports in Creator to display fresh data on a predetermined interval?
Call google maps with customer's address?? How to..
I have an app to enter in new customer information. A form with several single line fields. Address, City, State, Zip. Necessary to filter based on these fields. While entering in the customer information the next step is.... map their full address and view it in google maps while discussing the location with the customer. So I need to combine the address fields into a complete address and use it to bring up a browser tab with google maps directly to the customers address. then we use the measuring
Any tool to build a "Take a tour" for my Zoho Creator Application?
Hi, Are there tools to help build a "Take a tour" for an application developed with Zoho Creator? This is a good way to help users understand how an application works. Thank you! Stephane.
How to make a schedule automatically run a macro daily
I need to make a schedule to automatically run my macro everyday. I need to have all the records in my opportunity module automatically updated everyday so when i run my report the dates and things in it are accurate and zoho can calculate the proper age since zoho does not automatically update the current date on records continuously.
How can multiple users edit same row in spreadsheet
Hi I would like to know if there is a possibility for 2 (or more) users to edit the same row in a spreadsheet, we tried to do this, but it seems only the data from the user who clicks SAVE button last works. Meaning, that if 2 people worked on the same row, User 1 data is lost, and only User 2 (who clicked Save) later is kept. Is there a way to enable multiple users to edit same row at the same time? Or to somehow block the row, so that other users do not try to change it. Please let me know Thanks
if a total amount over the past 31 days is ..
Hello, is there any guru to help me out with that How could i script the following : if a total amount over the past 31 days is then.. I totaly lost at it thank you in advance
if and period of time
Hello there, Does anyone to give a hand with the "if" and a certain period of time and a quantity fetch if over the last 10 days the quantity is > than 10" { } in fact i want to condition my if to a period of time && to a quantity thank you many time in advance buddies
How to get previous value added to Zoho Creator by import?
When I do an import in Zoho Creator Report, in the On Success, I want to take in every record, his previous record ID (of the previous inserted record), with the objective of comparing the previous ID with the actual ID of the record and see if it is the same. How could I get that previous record ID?
How to update a field value from another form's field value ?
I have two forms in my application . I want to Update a field value of one form where the value will come from another form's field . Thanks in advance .
Setting a Default subForm entry, On Add Row code does not work
When I set a default entry on a subForm, the On Add Row code does not run on the default entries as it would if I manually added those rows. It probably should. Any workaround?
Report Image is not viewed to the shared users
I want to display my report which contains images with the URL Format http://creatorexport.zoho.com/zoho_admin_user/app_name/report_name/ID/image_field_name/image-download/1493994637400_3029081000006627203]_photo_one. If i share my report to other users, the image is not displaying. how can i solve this issue?
Workflow Automation Task
Hi I would like to ask for some help or idea on how to maximize the use of Workflow Automation, I've created some workflow process and has instant action for the tasks, but I have more than 5 tasks which limits me to add more tasks on each workflow process. Any recommendation on how to add more tasks? Also how to create Pipeline stages like on Insightly? Is it possible here in Zoho? Thank you in advance. Regards, Arvin
Is there any predefined options for getting the list of countries/cities/state?
Hi, I want to get the address from the user. Each address line has separate fields(i.e AddressLine1,AddressLine2,City,State,Zipcode and Country). Is there any predefined rule/options for populating the list of countries/cities/states in dropdown box?
Limit records in view: zc_RecLimit=<number>
With reference to: http://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html Where do i put the zcRecLimit parameter in an Iframe embedded on my web page? - I want to limit the records shown to 2 <p><iframe height="500px" width="100%" name="zoho-Stem" frameborder=""0""""" scrolling="auto" allowtransparency="true" src="http://LINKTOMYVIEW/zc_Header=false&zc_SecHeader=false/>="" paging="false&<span" id=" xinhaeditingpostion"></iframe><br></p>
Add lookup selections to other multiselect lookup
Hi I have 3 lookup fields on a form, first two list two different types of training, and the third hidden one needs to contain both selections from the first two lookups. This is all so I can then use a custom function to show training participants. This should happen as lookups 1 and then 2 are selected, so no extra steps are needed. Lookup 1 dropdown select - Training type 1 Lookup 2 dropdown select - Training type 2 Lookup 3 multi-select auto adds - Training type 1, Training type 2 Thanks
My Frist Creator Application
Hello Zoho Community, I created my first Zoho Creator Application. It consists of a basic form in which I record usage data by date. The form consists of 5 columns Date - Value1 - Value2 - Value3 - Value4 01-01-2017 - 1000 - 2000 - 3000 - 4000 08-01-2017 - 1100 - 2200 - 3600 - 4050 16-01-2017 - 1201 - 2400 - 3800 - 4100 23-01-2017 - 1308 - 2600 - 3990 - 4150 How can I add a column that calculates the number of day since the last entry?
Dashboard
Hi All, Can someone help me with the code to a simple but beautiful dashboard? I need to display 6 reports and 2 charts. Thanks in advance
Two dropdowns (not lookups) return ID numbers when adding.
In my Add Student form I have Grade and Class Day as dropdowns with a few values each. On adding the values become IDs, but when I edit them, I can X out the ID and choose a dropdown value again to save them as the correct non-ID values. I'm not really sure...
Show/Hide fields in HTML page on click of a button?
I'm aware that Creator does not support javascript, but is there a work-around to show/hide elements in an HTML page via buttons?
Header space still shows after params='zc_Header=false'
I am trying to completely remove the header in reports embedded in an HTML page but the white space still shows even if I input the parameter params='zc_Header=false' I hid all of the parameters but this still does not do the job. How do I hide this white space on top of the report?
Fields
Hi all, Is it possible to have 3 fields: Price: Discount: Total: (Price - discount) If yes how do i do it? is it with a function? Thanks!
Next Page