Zoho Creator Search Engine for Applications
Recently I've been working on Zoho Creator applications that require search tools. I've been using the stateless form in conjunction with HTML view approach; however, the scripting involved is a lot of work and can get very complex as more search fields are added. I've noticed that the List View has a pretty good built-in search capability. It would be great to be able to use this search feature separately from the List View within forms. If it is not possible, it would be great for Zoho Creator
A method for renaming tab titles in Creator to display more relevant information
Hi Zoho Devs, Updates: Rules Export File attached; you can now import this into Tab Modifier instead of manually entering the rules yourself) 2022-06-08: Updated rules so that crm.zoho.com tabs are not affected; uploaded new .json import file 2022-06-09:
Stateless Fields and push buttons in a Database Form
Many times you want to use a field to store temporary values that do not need to be stored in a database or to have some push button functions that can perform tasks that will help in filling out fields. I know this can be done in a stateless form but it seems more economical to allow this kind of functionality in a form rather than to have all fields saved in a database.
Style the forms and reports in your CSS
I did a simple trick. - On a form, added a ritch-text field called pageStyler (Admin can only view) - Added a deluge on load as - input.pageStyler = "<style>#zc-component { background-color: yellow;}</style>"; - Login as Admin and submit one record against the form Now this makes my form width 100%. I need this for a huge form. However, I would suggest override the CSS with extreme care.
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 :
Unleash your Zoho Creator HTML Views using "ZCML"
What is ZCML? ZCML is HTML with a Zoho Creator twist. ZCML let's you write HTML on your website or web application very much the same way you do in a Zoho Creator HTML View. You get the benefits of the same embedded variable syntax without the need to use the ZC REST API. This is not iframing. ZCML is HTML native to the website or web application it's being rendered on. Please watch the video. Why use it? It's Fast Zoho Creator HTML Views can be very slow to render depending on the number of statements
Push data to Zoho CRM
Zoho Creator can push Form data to Zoho CRM. Below example steps (and explanation) tell you how to add a CRM lead from Zoho Creator Form. We have created a sample application for this at https://creator.zoho.com/sampleapps/push-data-to-zoho-crm/# . Sign in and click on options (at the top) -> Copy application to copy it to your account. 1. Create a Lead Form in Zoho Creator: Create a Zoho Creator Form with the following fields. (See https://help.creator.zoho.com/By-adding-new-forms.html ) Company
How to extract Email address from string (Deluge)
The task was to extract an email address from a string variable, or any text-based field. It is usually done in javascript using regular expressions. Surprisingly, Deluge allows to replace substring using regular expression, but do not allow to search substring using regular expression. OMG. I finally came to below solution. It works. string GetEmailFromText (string Txt) { /* Extract first email address from the text Txt */ original_text = input.Txt; EMAIL_REGEX = ("[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?");
Automating Backup
I have moved my business' blood and soul to Zoho Creator. Is there a way to automate backup so it happens every day without any action from me? Thanks much. S
Creating an event in Google Calendar
Hi, I have listed below the deluge code snippet for creating an event to GoogleCalendar. The script uses the PostUrl function to send header parameters and write XML Data in the request body. Function for generating authoization header string getGoogleAuthToken(string email, string passwd, string GoogleService) { accountType = "HOSTED_OR_GOOGLE"; url = "https://www.google.com/accounts/ClientLogin?accountType=" + accountType + "&Email=" + email + "&Passwd=" + passwd + "&service=" + input.GoogleService;
Split Forms similar to Access
Is it possible to set up a Split Form similar to what they have in MS Access. This form would have the following: - On the top half of the form would be the parent record information. You would be able to scroll between parent records by scrolling from page to page. - On the bottom of the form would be the child records. This would be a listing of the child records that were associated with the parent record on top half of the screen. You would be able to scroll up and down through the child
Fetching leads from Zoho CRM into Zoho Creator, automatically
I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible? Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM. For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically
How to style a form using CSS
I put my programmer on this task and they found a solution. Using your browser's Inspect feature, get the CSS classes of both the <label> and <span> of any element you want to style in your form. Create a page. Embed the form in the page. Add an HTML
Fomatting Fields
1) Can you add some formatting functionality to the field descriptions so we can avoid using functions. String {Title,Upper,Lower,Sentence,Alfa Numeric} [Format ###,###.00] The best way would be to have a descriptor field. Also for report VIEW output it would be nice to have proper numerically formatted fields.
yourtime.tostring() format 12hr 24hr share
https://help.zoho.com/portal/en/community is too poor resource for us, but it's the only ! Some function are enable in creator, but many people don't know where to find them. Example, same with me ,try multiple methods to transform 12hr or 24hr, in fact, zoho creator have this function. Suppose now is 2016-04-29 15:30:12 : info zoho.currenttime.tostring("hhmmss") // show 033012 info zoho.currenttime.tostring("HHmmss") // show 153012 If it can help somebody, I should be very
Quick tip on using JSON data resources & sharing records between apps.
Howdy, Just thought I would bring this to your attention. If you don't know this already when you make a getURL/postURL request to a JSON resource Zoho allows you to convert that JSON to XML using toXML(). BUT, did you know that you can convert it straight to a map var? This is especially useful when you just want to grab one single JSON record to populate an html page or form. Example : Let's say that you want to grab a SINGLE record out of a separate app in the same account. The traditional
Key Shortcut for New Record
I suggest a control-key combination that acts like the "ADD" button. Bruce "Speedy G" Peaslee The World's Fastest Programmer
URL field, Link Name, Default Value
Hello, I think it would be great if the Link Name option of the URL field could have a default value field in field properties. It would make it easier and faster to define a simple unique word or expression as a link for each record containing a URL field without the need of entering the same word for each record we submit.. Anyway, while waiting for Zoho to add this feature to Creator, here is a working solution I found based on the following source : https://www.zoho.com/creator/help/fields/configuring-a-url-field.html
Record Collection Tips
If anyone ever sales they've never written bad code they are either lying or they are God himself. I starting using Zoho in Feb of 09 and like almost everyone that comes to Zoho Creator; I was looking for a way to make my business processes better. This led me to the wonderful world of Deluge Script! I would like to Deluge Script learning curve, well, less curvaceous for many of the new DS'ers out there. One aspect about Deluge Script that I immediately picked up on and enjoyed is how you do looping
Get input.ID on Stateless Form Submission
Concerning stateless forms: One thing that bugs me is that an ID number is generated after form data is submitted. This is an issue in my mind. Here's an example: A user submits a stateless form proposing some idea to a team. The team is then notified by email of this action along with a url linked to the idea. We cannot use a url link that has https://creator.zoho.com/admin/myapp/form-perma/newidea/&ID=212085000003178069 form because the ID is created after the fact. Rather, we are forced to create
Accessing XML attributes Tip...
Hi Just a tip..... If you ever need to drop a bunch of xml element attributes into a map variable. Here's how I did it. //create element variable file = xml.executeXPath("/response/tree/folder/files/file"); //create a map to hold the attribute variables data = map(); //make a list of attributes (note their is a way to do this agnostically where you don't know the name of the attribute //prior. But it's more complicated.. attributes = {"id","created","shared","sha1","file_name","size","updated"};
postUrl needs to support XML REST Services
I have an urgent need to interface an application in ZOHO Creator to an online bookkeeping system which supports REST based web services. I was a little surprised to see that the postUrl function only supports maps (key->value) pairs and not the ability to specify an XML body in the POST request. When is this going to be changed? Is there any chance that we can have a special key "data" that simply uses the value in the body. This would allow for backward compatibility in the function call and at
Nice way to persist params across page changes & note about hash URL's.
Zoho Creator uses Javascript's hashchange event, window.addEventListener("hashchange") or $(window).bind("hashchange"), to perform actions when a url's hash is updated. When a link like <a href="#View:my_view">My link</a> is clicked the window's hash is updated triggering the hashchange event. Then ZC uses AJAX to load in the html for the desired view. (Obviously not in view-perma mode). Anyways, usually you see demos of params being added to urls like so.. http://creator.zoho.com/zoho.adminuser/zoho.appname/#View:testing?param1=testing¶m2=testing
Extensible form logic based on lookup record...
Just a tip on creating user input logic.... I often see deluge script in forms where people are trying to do a lot of dynamic show/hides based on a lookup record.. You know something like this... if(field1 == "David Palmer" || field1 == "Wayne Palmer") { show good; } else if(field1 == "Charles Logan") { show bad; } OR a little better if they have a lot of || statements they'll make a list goodGuys = {"David Palmer","Wayne Palmer"}; if(field1 in goodGuys) { show good; } BUT..
A list of reusable functions!!!
I was wondering if there is a list of the sample applications to show how certain user created Functions work? If not I think it would be a really good idea to have a list of Functions with a link to the sample app which uses the function. Maybe a Sticky Post? Just an idea!!! Damien.
Tip 32: How to set form field values using custom functions
Hi folks, We're back today with our next tip—how to set form field values using custom functions. Before we get started, though, let's take a look at the basics. What do you mean by setting values for a field in a form? To assign a value to a form field
In zoho creator do we have search with barocde scanning for form detail page?
i want to create an app from which a person can read the barcode of prouct and get the details of that stored in form detail page
Embed a form/view on our website with 'logout' option
I would like to embed a form on our website, but require a login to access the form.. I've done that & it works. However, I would like to place a 'Logout' button or preferably have Zoho provide a built-in button for the user to logout. Thanks
Message Box function
Please provide a function to display a message box, ideally of the CSS later type rather than JS. EDIT: oops, I meant the "CSS layer type".
Auto increment in 2 lines of self supporting code.
As long as you have 1 record with a number field that has a number in it, then these 2 lines of code will work: LastRecord = Magnet_Board_Form [ID != 0] sort by OrderID desc range from 1 to 1; input.OrderID = (LastRecord.OrderID + 1); So how does it work? The first line is a "fetch" it sorts all records in form "Magnet_Board_Form" by the field "OrderID" in descending order, then grabs just the top record and calls it "LastRecord" The second line then increments the "OrderID" field of the "LastRecord"
Functions for faster accessing to application items
Hello I have applications with a great number of forms, reports, pages and so on (for example, in one app: 83 forms & 535 reports, 111 HTML pages, 715 deluge functions in workflow tab) I want to fast acces to: last modified elements (Forms, Reports, HTML-pages) - actually - very often it's hard to remember the name of report, you have worked on 3 days ago or name of the test function you use to make some changes in database and so on Please....... 1. add SORT BY LAST CHANGES link which will show
Save those precious 5000 statements and use xpath!
In the past I used to loop over XML using the toXmlList() function combined with some if statements... PROBLEM: Each iteration adds to your # of statements used and it's slow. There's a better way! Use xpath to it's fullest and let xpath do the heavy lifting.. Here's a function that let's you pass a "filter" map to your xml. It iterates over a map's keys and then builds up an xpath statement. Once the xpath statement string is built up it filters ALL your xml nodes (based on your xpath prefix change
How to build business form and other documents in your own format quickly
Hi guys, Let me share a tip to develop original business form and document such as invoice or receipt in Zoho creator. Problem: When you have to write a template of invoice with HTML in Zoho creator / Deluge script, what you would do is to write a function to return HTML strings so that the invoice would be generated dynamically with client name, product and whatever. Here is an example of codes from generateInvoice function of Order Management app provided by Zoho officially. This function will
Here's how to set a numeric field to null or to blank
I'm not sure this tip is discussed anywhere, so I thought I'd share it. When a form has a numeric field, it initially is blank (assuming you have not given it a default value). However at runtime, once you give it a value, you are not able to clear the field again.with a script unless you click the reset button or reload the form. Unfortunately, that will clear all the fields in the form, not just the one field. Although you can compare the value of a numeric field to null, you cannot assign a
Tip on checking existance of records..
So I don't know about you, but I get really tired of having to use the count function to check for the existence of records first before making a collection. (From my knowledge this is how most do it) Example... cnt = count(myForm[field == value]); if(cnt != 0) { myRecords = myForm[field == value]; } One must use the count function because if you try to do this, ZC throws an error myRecords = myForm[field == value]; info myRecords.ID; However, I've found what I think is a very convenient way of
Sharing uploaded files - Integration with Zoho Viewer
Zoho Creator currently does not support sharing of uploaded files. This could be simply avoided by integrating Zoho Creator and Viewer. Is this on the cards? How do I share a file I uploaded on Zoho Creator without the recipient having to log on to Zoho? I believe currently the recipient will also have to have admin access to my application to view the file. Am I right in saying so? It would be great if an option was provided to integrate file upload with Viewer. On uploading a file in a Zoho
Quickly create insert, collect, update DS code for your forms
Link to Code snippet Ok, so I just got so tired of writing lengthy Zoho form field scripts full of the same code over and over! ZC doesn't have any feature to dump field names onto the text editor for easy script writing. Nor do they offer anyway to dynamically reference input names through meta programming methods (code that makes code, DSL's). So if you want to generate insert, collect, and update code really quickly you might be interested in this javascript snippet. Read the comments in the
Make your HTML views (appear to) load more quickly
Just a small trick I discovered the other day... When you embed a view into an HTML view you get a piece of code that looks something like: <div elName='zc-component' viewLinkName='My_View' params='zc_Header=true'>Loading View...</div> In this case, when the user loads up the page, they'll see 'Loading View...' for a second or so, then the view itself will pop onto the page once it's been fetched from the Zoho servers. As I discovered, you can replace 'Loading View...' with anything else and Zoho
WhatsApp and Zoho Creator Integration
#Tips of the Day ======================================================================================== How to Connect WhatsApp With Zoho Creator. -> Create an account on WATI API EndPoint https://app-server.wati.io/api/v1/sendTemplateMessages Pass
Extending Objects/maps
Just a tip... You can extend maps much like you extend an object in javascript. Deluge Script does a great job of overwriting map members when you redeclare a put! Old pairs stay the same new pairs get added. Thanks DS dev team for making this an overwrite method rather than having to remove the key first. :) map private.editRecordMap(map recordMap, map editMap) { editKeys = editMap.keys(); for each key in editKeys { recordMap.put(key,editMap.get(key)); } return recordMap;
Next Page