【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
    次回開催のご案内は当フォーラム上に追って告知します。
  • 今回のカスタム関数マスター講座について、録画の共有は行いません。
  • カスタム関数マスター講座にて共有されたスクリプトによる本番環境への影響、データ消失、その他の問題につきましては責任を負いかねます。
━━━━━━━━━━━━━━━━━━━━━━━━

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

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

    Access your files securely from anywhere








                            Zoho Developer Community




                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts





                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ




                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方







                                                                                                              • Recent Topics

                                                                                                              • I am trying to integrate my module in sandbox environment to add data via API

                                                                                                                I went through the documents and tried to setup the API for adding the module via the api but the problem is the token setup is done on "https://accounts.zoho.in/oauth/v2/token" domain and the bulk write is done on "https://content.zohoapis.com/crm/v8/upload"
                                                                                                              • Setting up primary mobile number.

                                                                                                                Hi Sir Earlier I joined IIFL team and got an organizational email of zoho services. Later i quit and now my account is deactivated with IIFL but i am unable to link my mobile number to my own email id with zoho.
                                                                                                              • Tables for Europe Datacenter customers?

                                                                                                                It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?
                                                                                                              • Guided Conversations - Ticket Creation

                                                                                                                Hi there, Using Guided Conversations to Take Customer Data and apply it into a Support Ticket for internal use, Is there a way to take multiple Textual Variables Inputs (A series of questions), and have the answers all appear in the Description of the
                                                                                                              • How to send certain invoices for Approval based on condition?

                                                                                                                To streamline operations, I need the invoices to go for approval when certain conditions are met. For example, if my staff gives a discount of x amount, it must go for approval. If there is no discount, then the invoice will be approved automatically.
                                                                                                              • Unable to continue payment

                                                                                                                Hi, I want to make a payment for my email subscription, but I cannot proceed with the payment because my NITKU is invalid. In Indonesia, the NITKU consists of 22 digits, but Zoho only provides 20 digits, causing my NITKU to be invalid. Please help me
                                                                                                              • Is there a way to show contact emails in the Account?

                                                                                                                I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail
                                                                                                              • Massive spam pretending to come from our address – is this a Zoho security issue?

                                                                                                                Hi, We’ve been receiving more and more suspicious emails lately — many of them clearly look like scams. But yesterday, we got an email that appeared to be sent from our own address, which was very concerning. We're starting to wonder if this might be
                                                                                                              • Cant recieve mails

                                                                                                                I’m having an issue with my external IMAP account not fetching any emails into Zoho Mail, even though the connection test says “Success”. I can send, if someone sends an email to me. my original directory (home.pl host) recieves it in their portal but
                                                                                                              • Zoho Sheet Autofit Data

                                                                                                                While using Autofit Data function in Zoho Sheets with Devnagri Maratji or Hindi Fonts, a word or a number, it keeps couple of characters outside the right side border.
                                                                                                              • Enhancements to finance suite integrations

                                                                                                                Update on the migration (October 28, 2025): Starting this week (October 29 tentatively), we’ll begin migrating Zoho CRM users to Zoho Books as integration users. This means actions will now run under each user’s own Zoho Books access, instead of the admin’s.
                                                                                                              • Edit 'my' Notes only

                                                                                                                The permissions around Notes should be more granular, and allow to user to be able to edit the notes he created only. The edit Notes permission is useful as it allows the user to correct any mistakes or add information as needed. However, with this same
                                                                                                              • Job Alerts for Candidates

                                                                                                                hi All, I have 2 questions relating to sharing job details with candidates. 1. is there a way to notify candidates that meet certain criteria of current jobs available? eg. I run a candidate search, and identify 50 candidates that might be suitable. Can
                                                                                                              • Add multiple users to a task

                                                                                                                When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman
                                                                                                              • Enhancing Task Accuracy: Automatically notify the owners upon Task duplication.

                                                                                                                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. The requirement
                                                                                                              • Nodemailer not working with Zoho

                                                                                                                Hi All, I'm having issues with Zoho working with Nodemailer. It works as expected when using gmail as the service. Below is the code I get when using zoho. Error sending email: Error: connect ECONNREFUSED 127.0.0.1:587 at TCPConnectWrap.afterConnect [as
                                                                                                              • desktop app for TODO

                                                                                                                Is there a desktop app for Zoho TODO?
                                                                                                              • Show/ hide specific field based on user

                                                                                                                Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just
                                                                                                              • Where are Kanban swimlanes

                                                                                                                So i've been playing with Zoho Projects Kanban view a bit more. It appears that task lists are being used as the Kanban columns, which makes sense from the implementation point of view but not the logical one.  Kanban columns are statuses that a task can flow through, while a task list has been a logical way to organize related tasks and relate them to a mislestone. In other words a task in a particular task can go through several stages while remaining in the same task list. After doing some research
                                                                                                              • Tip 19: How to display images in Pages using ZML snippets

                                                                                                                Hi folks, We're back with another tip on how to use Zoho Markup Language (ZML) to create interactive pages in Zoho Creator. You can use ZML snippets to add various kinds of components to your pages and structure them in meaningful ways. That's not all, though—using ZML you can ensure your application is automatically compatible with all kinds of devices without any inconsistencies. We often get questions from users about how to invoke Deluge scripts within ZML code. Here's a simple use case for adding
                                                                                                              • Can zoho swign format block text spacing automatically when prefilled from zoho crm?

                                                                                                                I'm sending zoho sign template from zoho crm, so that zoho crm pre-populates most fields. I have existing pdf documents that i am having signed. I have no ability to change the pdf documents, they are standardized government forms. The problem I am facing
                                                                                                              • Zoho Inventory / Finance Suite - Add feature to prevent duplicate values in Item Unit field

                                                                                                                I've noticed that a client has 2 values the same in the Unit field on edit/create Items. This surprised me as why would you have 2 units with the same name. Please consider adding a feature which prevents this as it seems to serve no purpose.
                                                                                                              • Reference lookup field values in Client script

                                                                                                                hello all, I'm using a "ZDK.Apps.CRM.Products.searchByCriteria" function call, which is returning the matching records correctly; however, one of the fields is a lookup field which I need the associated data. I believe there is a way to get this data
                                                                                                              • In App Auto Refresh/Update Features

                                                                                                                Hi,    I am trying to use Zoho Creator for Restaurant management. While using the android apps, I reliased the apps would not auto refresh if there is new entries i.e new kitchen order ticket (KOT) from other users.   The apps does received notification but would not auto refresh, users required to refresh the apps manually in order to see the new KOT in the apps.    I am wondering why this features is not implemented? Or is this feature being considered to be implemented in the future? With the
                                                                                                              • Every time an event is updated, all participants receive an update email. How can I deactivate this?

                                                                                                                Every time an event is updated in Zoho CRM (e.g. change description, link to Lead) every participant of this meeting gets an update email. Another customer noticed this problem years ago in the Japanese community: https://help.zoho.com/portal/ja/community/topic/any-time-an-event-is-updated-on-zohocrm-calendar-it-sends-multiple-invites-to-the-participants-how-do-i-stop-that-from-happening
                                                                                                              • How can I filter a field integration?

                                                                                                                Hi,  I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
                                                                                                              • How to implement new online payment gateway?

                                                                                                                Hello, Can you tell me how to proceed to implement my local payment gateway? DIBS has an open avaiable API that should be easy to implement into ZOHO BOOKS. http://tech.dibspayment.com/dibs_payment_window
                                                                                                              • Zoho CRM - Portal Users Edit Their Own Account Information

                                                                                                                Hi Community, I'm working on a client portal and it seems like the only I can make the Account record editable to the Contact, is if I add another lookup on the Account to the Contact record. Am I missing something as the account already has a list of
                                                                                                              • Connecting Zoho Mail with Apollo.io

                                                                                                                Hi, I am trying to connect my Zoho Mail account with my Apollo.io account to start sending cold email for prospecting purposes. I have activated the IMAP setting but I am still unable to connect to the Apollo account. I am using my email credentials but
                                                                                                              • Where does this report come from in the Zoho One ecosystems?

                                                                                                                Is this directly from MA, Analytics or ??? ???
                                                                                                              • Contact's title in "Contact Role Mapping"

                                                                                                                When I'm creating a deal, I'd like to see the contacts title in the listing. Right now, I only see this: How can I get the contact's title in there?
                                                                                                              • Zoho CRM - Client Portal - Hide Notes Related List

                                                                                                                Hi Community, I'm building a customer portal and I can't find a way to hide the notes related list. I don't want the client to see the notes I have about them. Is there a way to do this as it is no bin/trash icon when I hover over.
                                                                                                              • "Pivot Table" Conditional Formatting

                                                                                                                Team, I there a way to use conditional formatting a "Pivot Table"  report? Thanks, Arron Blue Pumpkin Hosting | Solutions Made Simple
                                                                                                              • How many clients can be added to Zoho Practice?

                                                                                                                How many clients can be added to Zoho Practice without having their zoho app?
                                                                                                              • Stage History

                                                                                                                when viewing a ticket , and you look at stage history tab (kanban view) and look at the stage duration column in days, it shows the current stage of the ticket as " current stage ". Should it not rather show the amount of days it has been in that current
                                                                                                              • Automating Ticket Responses Using Zoho Desk's AI Features

                                                                                                                We’re looking to set up an automation within Zoho Desk that can analyze incoming emails or tickets and automatically respond with relevant knowledge base articles based on the content of the request. Could you please guide us on how to configure this
                                                                                                              • Optimising CRM-Projects workflows to manage requests, using Forms as an intermediary

                                                                                                                Is it possible to create a workflow between three apps with traceability between them all? We send information from Zoho CRM Deals over to Zoho Projects for project management and execution. We have used a lookup of sorts to create tasks in the past,
                                                                                                              • Service locations are tied to contacts?

                                                                                                                Trying the system out. And what I discovered is that it seems that the whole logic of the app is, I'd say, backwards. There is a Customer - a company. The company has contact persons and service locations can be associated with different contact persons.
                                                                                                              • Enhancements to Zoho Map integration tasks

                                                                                                                Hello everyone, We're excited to announce enhancements to the Zoho Map integration tasks in Deluge, which will boost its performance. This post will walk you through the upcoming changes, explain why we're making them, and detail the steps you need to
                                                                                                              • Bug in Total Hour Calculation in Regularization for past dates

                                                                                                                There is a bug in Zoho People Regularization For example today is the date is 10 if I choose a previous Date like 9 and add the Check in and Check out time The total hours aren't calculated properly, in the example the check in time is 10:40 AM check
                                                                                                              • Next Page