Remove "-" from String
if(input.Full_Name.contains("-") == true) { getsuffix = Full_Name.getsuffix("-"); if(getsuffix.len() == 1) { input.New_Full_Name = Full_Name.replaceAll(getsuffix, "").replaceAll("-",""); } else { input.New_Full_Name = input.Full_Name; } } .........................................
Zoho Writer Merage Template and send for the sign by the API
Tips & Trick - Zoho Writer API Hello All, How to Create a Merage Template inside Zoho Writer. Enter Field.... //...........Get Mearge Field Data <response> = zoho.writer.getMergeFields(<document_id>, <connection>); //...........Create Map........... writermap
Emailed links vanishing
Does anyone else get complaints from some of their portal users that emails are losing links? This is happening on really core emails like password resets. Most users will receive a perfectly good link, but some just see plain text instead. And when
Dynamic Drop Down Population
I have found this useful and assume others will as well. For this activity, I have a form that allows the user to select a sport, which is a lookup field to my sports form. Once a sport is selected, I have two drop down fields that are for event types
Convert an integer to a formatted currency string for use in an html page
TL;DR - the deluge custom scripts below can convert a plain integer into a currency-formatted string, i.e. convert -12345678 to ($12,345,678) or 12345678 to $12,345,678 --------------------------------------------------------------------------------------------------- hey there fellow zoho community members! i have been developing custom html pages for my apps in zoho creator and came across the challenge of formatting integers into nice and clean currency values. i struggled with this for awhile
SHOW DATE & WEEKDAY on SAME LINE in reports
Hi It would be very handy for us, when 'Configuring fields for Web' to be able to show the date as 'Full date AND weekday' We advertise our reports so would be handy to show not only the full date, but the weekday too ie 06-March TUESDAY Thankyou!
Convert Number into Ordinal
Hello Developers, Here is the solution for converting the Number into Ordinal. For Example: This Idea can be used when lets say you are creating the Dashboard where you are showing upcoming celebrations like work Anniversary for you HRMS Application.
Images in export spreadsheet
Hi, anyone have idea as I can export images displayed in a view? I can import all data with MSAccess or MSExcel, but images is not displayed (only as a link). I need link my zoho db with a xls or dbaccess to use the data with CardStudio software and print identity cards. Someone have operated with this? Thanks Mic
close a form only with submit
Hi india Does any know how can i script the following : we can't close or update a form until the submision, in other word i want to prevent the user to close the form without passing by the button submision. I would like to see a kind of alert message, requesting the user to submit before closing his page/form thank you in advance
Print as list in creator
Hi How can I put use the print as list feature within creator and include other details. What I am trying to do is create an invoice using the print as list feature. Thanks
Is it possible to Embed an Image in an Email Notification?
I am trying to add sponsors to my email response/notification. Is it possible to add images to your email notification? Thanks!
Send email when certain fields are updated.
I have a form in Zoho that nearly mimics a local database, except for a handful of fields. When I update the Zoho form, I want to send an email to myself to remind me to update the local copy. Only, I don't want the email if the only fields updated were non-duplicated ones. I'd rather not add one email notification per field I care about, as that's quite a number of fields. Is this possible? Thanks, -Christina
Does Zoho creator has any Upsert functionality ?
Hi I have requirement where I need to update the record if data already exists in database, else if data not there then only create new record. Can anyone suggest the solution. Thanks
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
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
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])?");
Barcode Generate in ZOHO Creator
Hello All, Problem:- How can Generate a barcode inside the Zoho creator? Solution:- BarCode API:- https://bwipjs-api.metafloor.com/?bcid=code128&text=PIyushGoyal&scale=3&rotate=N&includetext rotate:- N : Normal (not rotated). This is the default. R :
How to store Image from a web URL as an image file in Image field?
Hi all, I'm new to Zoho Creator! I'm trying to save an image from a URL and generate public URL from creator. I've understood how to generate a URL of an Image stored in the Image field. The question is: I'm rendering an Image from "https://www.expamle.com/taskID?apikey=xyz"
Send email with HTML page as PDF attachment
I am creating quotes and invoices etc. as HTML pages in PDF format with no problem. I can see that HTML pages in PDF format can be attached to email in Schedules. Has anyone created a general purpose solution to using the Schedule email facility to send emails with attachments on demand?
ZOHO Creator Credit Card Integration
Hi Is there any way to pass an amount field calculated in Zoho Creator to a third party Credit Card processing gateway such as Sagepay Thanks
How can I remove double quote from a string in a formula field ?
Thank You.
Export from Creator to Word Doc
Is it possible to export to a word doc from Zoho Creator?
Week numbering
Does Zoho e.g. getWeekOfYear() calculate week numbers according to ISO-8601? If not then has anyone implemented a function to calculate ISO-860 week numbers?
Regular Expressions Help
Regex such as "^[A-Za-z]$" doesn't seem to work. I also tried an email regex like "^[A-Za-z0-9]+@[A-Za-z0-9]+\\.[A-Za-z]{2,}$" it doesn't work. My code below. emailRegEx = "^[A-Za-z0-9]+@[A-Za-z0-9]+\\.[A-Za-z]{2,}$"; e = input.Email_Address; e = e.trim(); if(e.matches( emailRegEx ) == false) { errors.add("Email not in correct format"); } I am using regex for validation instead of validation that comes with zoho because I am implementing a conditional validation. Some form fields are required
Formatting Text Fields - All Capital Letters
Is there anyway to format text fields to show-up as all capital letters? We can format a numbers field as currency. Why not a text box as caps, or title, or lower case? Thanks.
Sendmail function - enter a delay in e-mail sending - is it possible?
I have a custom action that when finishes it's job send a e-mail message to an address. My wish is that this custom action to send a second mail a half minute later, with another content. Thank anyone who can give me an advice in solving this.
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
Collapse Menus
In Zoho Creator, is it possible to create a page that includes collapsible or accordian menus? Thanks.
Deluge Question: Conditional Statement
Hello, I made a short video showing where I'm stuck. How can I add "For every 5000 over 44,001" execute___? Video: CLICK HERE TO VIEW Thanks for your help! if(Program == "Lawn Mowing" && Property_Sq_Ft >= 0 && Property_Sq_Ft <= 4500) { input.Services.clear();
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:
How To Format Phone Numbers
I am completely new with ZOHO I am trying to build a database how can a make it so when a phone number is entered in a form like this:9876543210 it automatically formats it to 987-654-3210 Thank You
HTML Templates for PDF reports
Hi, I have been working to create a PDF report for the creator record, I know I can do that using record template but in that particular template, I have to add every single field in order to get the report. Now no matter which field has input and which
Execute Function on Collection Of Records
Hi, I would like to select the the execution for "Collection of records" but it seems grey out, any idear how can I select this?
toTime function = Convert ISO Time to Date-Time Field (Zoho booking and zoho creator integration)
Hello, I'm trying to integrate zoho booking with zoho create through zoho flow, The problem is that zoho booking give me the start date appointment with ISO format: 2020-11-16T07:00:00+00:00 I'm using to date function to covert in Date-Time field with
Subform fields width
Hello, I write several times about this problem, and understand that you have your roadmap of developing but... In subforms, we can't control width of fields. Sometimes it's critical - for example, lookups fields, when displaying text is wide. It's very hard to find your value, especally when values a very similar in start. Some time ago, we have ability to use some css tricks and use "notes" field in form with this SubForm where I write something like this: <style> div[...some css selector to select
FYI: how to show/hide subform delete entry for specific users
Create a hidden (admin only) field in your main form, e.g. Current_User Create a workflow for your form: Form > Edited (or Created or Edited) > Field Rules > name of workflow Add two actions: Action #1: Execute without condition, Set value of [Current_User]
Query on Collection variable
Hi, I have a table "Sales" with 3 field: Date Name Quantity I execute a fetch on Sales filtering on date and the matching records are contained in the collection variable "data1". Later I want to execute several queries on data1 using criteria on Name and Quantity. How can I do this? Tks
Nested IF function
Is it possible to do a nested if function in ZOHO creator? I want to be able to perform an action based on two criteria. Does ZOHO have an if and/ if or function?
IF statement on a field
I have to give a value to a field (let say FIELD1) according the following criteria where FIELDXs are type float if (FIELD2 != 0) { FIELD1 = FIELD2; } else if (FIELD3 != 0) { FIELD1 = FIELD3; } else if (FIELD4 != 0) { FiELD1 = FIELD4; } else { FIELD1 = FIELD5; } where I should put it. I tried on Form edit/validate ! form edit/Load but seems not working. the same on the Field /input ! field/validate find in the attachment the right if statement applied. Thx
You can use functions in report filters
FYI, I just learned about the attached the other day while chatting with support.
Next Page