【10/28(金)15:00〜】カスタム関数についてユーザー同士で学び合う勉強会

【10/28(金)15:00〜】カスタム関数についてユーザー同士で学び合う勉強会

お世話になっております。Zoho コミュニティチームです。
Zoho ユーザーさまより発案いただいた「カスタム関数マスター講座」の開催についてお知らせします。

━━━━━━━━━━━━━━━━━━━━━━━━
カスタム関数マスター講座とは？
‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥
スクリプト言語「Deluge」を用いたカスタム関数の事例やコードを、Zoho のエキスパートユーザーの皆さまから共有いただく催しです。

今回は事例を聞くだけでなく、スクリプトをコピー＆ペーストしていただき、実際に参加者の皆さまの環境でカスタム関数の挙動を確認していただく参加型の勉強会となります。 カスタム関数についての情報共有が行えるフリートークや質疑応答の時間もありますので、 Zoho ユーザーの皆さまと交流しながら知識を深められます。
━━━━━━━━━━━━━━━━━━━━━━━━
◎開催概要

名称：「カスタム関数マスター講座 vol.1」
日程：10月28日(金) 15:00 - 17:00　※全6回開催予定
配信方法：　Zoom　※ミーティング形式（お申し込み後の確認メールにて、当日の参加URLをお知らせします）
対象サービス：Zoho CRM
定員：10名
･････････････････････････････････････････････････････････
詳細はこちら：※定員に達したため、お申し込みを締め切りました。（※2022年10月21日（金） 11:55AM 現在）
･････････････････････････････････････････････････････････

◎タイムテーブル

　15:00〜15:05　カスタム関数マスター講座 vol.1とは？
　15:05〜15:10　発案者 自己紹介
　15:10〜15:35　関数共有①「カスタムボタンを作成して、連絡先住所を取引先住所にコピーする」（有限会社西尾システムコンサルタント 西尾 真言さま）
　15:35〜15:50　質疑応答①
　15:50〜16:15　関数共有②「外部サービスを利用して翌営業日を取得しよう」（株式会社トーチライト 松井 邦夫さま）
　16:15〜16:30　質疑応答②
　16:30〜16:50　情報交換会（フリートークの時間）
　16:50〜17:00　記念撮影・連絡事項

◎今回取り扱うカスタム関数の例

対象サービス：Zoho CRM
テーマ：内部のデータ変更と外部URLからの情報取得
　- カスタムボタンを作成して、連絡先住所を取引先住所にコピーする
　- 外部URLにアクセスして翌営業日を取得する
    など……

･････････････････････････････････････････････････････････
参加申し込みはこちら：※定員に達したため、お申し込みを締め切りました。（※2022年10月21日（金） 11:55AM 現在）
･････････････････････････････････････････････････････････


───────────────────────────────────
◎開催回について
今回のカスタム関数マスター講座は、開催回によってアジェンダが変わります。なお、2022年10月から2023年3月まで、毎月1回開催予定です。

第1回、第3回、第5回（奇数回）　                  
  • Zoho ユーザーが活用している関数例の紹介
  • 参加者の皆さまと一緒にカスタム関数の作成
  • 情報交換会（フリートークの時間）
第2回、第4回、第6回（偶数回）
  • 参加者からの質問回答
  • 情報交換会（フリートークの時間）
───────────────────────────────────
◎注意事項
  • カスタム関数マスター講座では、参加者の皆さまにも実際の関数をコピー＆ペーストして動きを見ていただきます。そのため、あらかじめZoho サービス を操作しながらご参加いただけますと理解が深まります。
    ※10/28(金)は、Zoho CRM で使用できるカスタム関数を紹介します。
  •  今回紹介するカスタム関数はワークフロー内での「関数」の処理を使用して動作するものとなります。こちらはエンタープライズプラン以上で利用できます。
  • 本番環境とは別の独立したテスト用の環境が利用できる「サンドボックス」も同様のプラン以上で利用可能です。
  • 今回のカスタム関数マスター講座では質疑応答の時間を設けますが、カスタム関数マスター講座の内容に関する質問をお願いします。個別のご質問がある場合は、毎月開催している、課題解決型のワークショップイベント「Zoho ワークアウト」への参加をご検討ください。
    ※次回のZoho ワークアウト開催日程：11月9日（水）14:00 - 17:00
    次回開催のご案内は当フォーラム上に追って告知します。
  • 今回のカスタム関数マスター講座について、録画の共有は行いません。
  • カスタム関数マスター講座にて共有されたスクリプトによる本番環境への影響、データ消失、その他の問題につきましては責任を負いかねます。
━━━━━━━━━━━━━━━━━━━━━━━━

以上、ご確認、ご検討のほどよろしくお願いいたします。

ゾーホージャパン株式会社
コミュニティチーム




        • Recent Topics

        • Zoho Inventory. Preventing Negative Stock in Sales Orders – Best Practices?

          Dear Zoho Inventory Community, We’re a small business using Zoho Inventory with a team of sales managers. Unfortunately, some employees occasionally overlook stock levels during order processing, leading to negative inventory issues. Is there a way to

        • Problem for EU users connecting Zoho CRM through Google Ads for Enhanced conversions

          Has anyone else experienced this problem when trying to connect Zoho CRM through Google Ads interface to setup enhanced conversions? Did you guys get it fixed somehow? The Problem: The current Google Ads integration is hardcoded to use Zoho's US authentication

        • integration zoho form - drive

          I integrated my form with Google Drive. The report of user submissions from the Google Form becomes a Google Sheets table. When I used Google Forms for the same task, the summary sheet adapted to the form. For example, if I added a new field to the form,

        • Revenue Management: #9 Revenue Recognition in Media & Publishing

          Media & Publishing industry has evolved in recent times. It offers subscriptions, bundles digital and print access, runs sponsored content, and sometimes even sells ad spaces. If you run a media or publishing business, you will always get into a situation

        • Zoho CRM Community Digest - July 2025 | Part 2:

          Hello, Everyone! We’re closing out July with a can’t-miss highlight: Zoholics Europe 2025! Happening from September to October, it’s your chance to level up your CRM skills, covering everything from automation and CPQ to dashboards and advanced workflows.

        • How can I trigger a flow action only once while updating contact?

          Hi, we have a trigger to merge&mail file when the field YYY is filled out. For this acion I used "Create or update module entry". But unfortunately we get tens of email on a day with this merged file, because the contact is being regularly updated. The

        • Copy a Record Template from one Form to another

          I have a Creator application with several forms.  I developed a record template for one of the reports/forms but want to use most of it for another of the form/report combinations in the application. Is there a way to copy the template (code or otherwise) to another form?

        • Tip of the Week #70 – Create common team signatures for your shared inboxes

          Did you know that a small detail, such as an email signature, can make a big difference in how your brand is perceived? One simple yet smart way to enhance your team’s communication is by creating common team signatures for your shared inboxes. Instead

        • Enhanced data export features: XLSX format, custom character encoding, and selective record export

          Greetings all, Here are a few enhancements related to exporting CRM data, including the ability to export data in XLSX file format now. The Export feature under Data Administration now offers new options that expand its flexibility and enable users to

        • Invalid value passed for file_name

          System generated file name does not send file anymore - what is the problem?

        • Tip #42 – How to manage data security with Privacy Settings – 'Insider Insights'

          Data privacy is a cornerstone of trust in remote support. Through Privacy Settings in Zoho Assist, you can set up how data is gathered, stored, and handled in your organization. These settings ensure compliance, data protection for sensitive details,

        • Zoho DataPrep and File Pattern configuration

          I'm using Zoho data prep to ingest data from One Drive into Zoho Analytics... The pipeline is super simple but I can't any way to get all the files that I need. Basically I need to bring all the files with a certain pattern and for that I'm using a regex

        • Custom Function for Estimates

          Hey everyone, I was wondering if there was a way to automate the Subject of an estimate whenever one is created or edited: * the green box using following infos: * Customer Name and Estimate Date. My Goal is to change the Subject to have this format "<MyFirm>-Estimate

        • Introducing Dark Mode / Light Mode : A New Look For Your CRM

          Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for

        • Quick Item Search & Auto-suggestion for Invoices

          Hi Team, I am facing an issue while creating invoices in Zoho Books. Currently, I have to type the full item name in the correct sequence and spelling for it to appear. For example, my item name is: "Distemper Acri Silk Special White 10kg" If I type something

        • Ticketbai! en el Pais Vasco

          Hola a todos, En enero de 2.022 se va a implantar en el país vasco un nuevo sistema de facturación, denominado ticketbai!, ¿hay alguna previsión de realizar las adaptaciones en zoho books o zoho invoices? Ignoro la cantidad de clientes que tienen estas

        • Zoho CRM mobile app feature update: home page widgets, field tooltips and user image upload

          Hello everyone! Your business doesn't pause when you're on the move, and neither should your CRM. That's why in our latest update, we've introduced a few new features to make your mobile CRM experience smoother and more efficient. Let's take a quick look

        • Zoho CRM Plain Text Template: Line Breaks and Formatting Issue

          Hello, I'm following the instructions to create email templates in Zoho CRM, but I'm having a problem with the plain text version. https://help.zoho.com/portal/en/kb/zoho-sign/integrations/zoho-apps/zoho-crm/articles/zoho-crm-email-templates#Steps_to_create_a_custom_email_template

        • Optimizing Task Handling: Auto-Remove Recurrence for cancelled Tasks.

          Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:

        • Important updates to your connectors

          Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of the

        • Create, collaborate, and manage agreements with Zoho Sign

          Agreements drive business. We launched Zoho Sign in 2017 as a simple digital signature tool to sign agreements from anywhere, at any time. Over the years, we've learned that most agreements go through last-minute changes before they're signed. Our users

        • Function #25: Automatically generate purchase orders from a sales order

          We kicked off the "Function Fridays" series with the goal of helping you automate your everyday accounting tasks. As we delve into today's post, I'm delighted to announce that we're here to present the 25th custom function in this series. While it is

        • Has Anyone successfully integrated Zoho and Sage Intact?

          Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

        • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

          ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 ▷▷参加登録はこちら：https://us02web.zoom.us/meeting/register/6OSF2Bh6TumsMIlDwaY_PQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho

        • hiding a topic from all but one segment (or list)

          My organization sends out a number of newsletters using Zoho Campaigns. One of those newsletters is for volunteers. In order to become a volunteer, a person has to first go through our volunteer orientation (training). After that, they can receive newsletters

        • How do I set up this automation correctly?

          When contacts enter my Subscribers list, I want it to reference a custom field to see if it is empty. Then I want it to do two things: If empty: Assign a tag based on a different custom field. If that custom field is empty, assign a different tag. If

        • Function #62: Display associated Quote on Invoice details screen

          Hello everyone! Today, we are sharing a Related List script that makes it easy to view and access the quote from which an invoice was created right from the invoice details screen. This Related List displays the Quote number and Amount, allowing you to

        • Custom confirmation message

          How can I change the message that users see after they submit the booking form? I have to confirm some details before their appointment is officially "confirmed", so I want to change it where it doesn't say their appointment is "confirmed" but rather

        • Desk x CRM Integration

          Howdy! We currently use SalesIQ but we are considering moving across to Desk as it seems to have more functionality that we want. One of the pulls is the ability for our customers to self serve. But, I might be getting over excited and not actually need

        • Function #53: Transaction Level Profitability for Invoices

          Hello everyone, and welcome back to our series! We have previously provided custom functions for calculating the profitability of a quote and a sales order. There may be instances where the invoice may differ from its corresponding quote or sales order.

        • Issue with Save & Share Link – Works for Others but Not Creator

          I’ve enabled the "Save and Share" feature in Zoho Forms, and it works correctly for all users accessing the public link—except for me (the form creator). Issue Details: When I save and share the link, recipients see a “no permission” error. The form is

        • Save the pdf report from a registration form in a Folder

          Through Zoho Forms I created a registration form with quite a lot of rules to handle different variables (TEAM types, payment in installments, etc.), and the result is pretty good. The automatic PDF that is sent to the respondent upon submission is already

        • zoho forms integration to zoho work drive

          Scenario: A user fills out a Zoho Form, entering details such as email, mobile number, and other required information, and uploads supporting documents like PAN, Aadhaar, etc. Upon submission, the data is available in Zoho Forms Reports. Requirement:

        • Zoho Forms to Zoho CRM Integration failed - can I restart it?

          The integration of Zoho Form to Zoho CRM has failed. Is there a way for me to restart it for the impacted entry?

        • insert an equation, but in document, it shows an image not available.

          I'm new to Zoho writer and used Zoho writer in desktop app version . When I inserted an equation, I got an image not available sign. Any help is appreciated. Thanks, Charles

        • Zoho Desk Android app update - Swipe action customization

          Hello everyone! We have brought in support for the swipe action customization in latest version(v2.9.13) of the Zoho Desk Android app update, enabling you to configure left and right swipe gestures on tickets to carry out the actions swiftly without opening

        • Import KB template OR Export template for zoho desk?

          Greetings. Can you tell me if there is a way to get an EXPORT of my KB articles? OR is there a template you supply for importing KB articles into my zoho desk? I am looking for a method of understanding what fields can be imported, and what their possible

        • XML format to import knowledgebase into Zoho Desk

          Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.

        • Zoho Desk integration with Power BI

          Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack

        • Arranging Ticket Templates

          Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical

        • Next Page