【2/15(水)15:00〜】実際にスクリプトを作成して学ぶ! カスタム関数マスター講座 vol.5

【2/15(水)15:00〜】実際にスクリプトを作成して学ぶ! カスタム関数マスター講座 vol.5

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

━━━━━━━━━━━━━━━━━━━━━━━━
カスタム関数マスター講座とは?

「Deluge」というスクリプト言語を使用してカスタム関数をカスタマイズした事例を、Zoho のエキスパートユーザーの皆さまに共有いただいたり、参加者全員でディスカッションをする時間です。

今月の開催回は、「日付けの取り扱い」についての関数共有とディスカッションを中心に構成されています。
Zoho ユーザー同士で交流しながら、カスタム関数に関する理解を深めましょう。

・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・
参加申し込みはこちら:https://zoho.to/minimeetup20230215
・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・
━━━━━━━━━━━━━━━━━━━━━━━━
◎開催概要
「カスタム関数マスター講座 vol.5」

日程: 2月15日(水) 15:00 - 17:00 ※全6回開催予定
配信方法: Zoom ※ミーティング形式
  • お申し込み後の確認メールにて、当日の参加URLをご案内します。
  • 残席をチェックした後に参加の承認を行うため、確認メールの返信に少々お時間をいただく場合がございます。あらかじめご了承いただけますと幸いです。
定員: 10名

◎タイムテーブル
15:00〜15:05 カスタム関数マスター講座とは?
15:05〜15:20 発案者&参加ユーザー 自己紹介
15:20〜16:40 関数共有・質疑応答
「日付の取り扱いについて - 以前寄せられた質問への回答 - 」
16:40〜17:00 参加者感想発表・記念撮影・連絡事項
━━━━━━━━━━━━━━━━━━━━━━━━
◆共有する関数の詳細
「日付の取り扱いについて - 以前寄せられた質問への回答 - 」
対象サービス:Zoho CRM
今回は、以下の二つの質問を解決する方法を紹介します。
1. 顧客の誕生日にアラートを出したい
- ワークフロー:顧客の誕生日に基づくアラート表示(商談タブ)
2. 自社のサービスを顧客が最初に契約した日から何年経ったかを表示させたい
- 数式項目・日付項目:顧客の契約年数の表示(カスタムタブ)
- カスタム関数:上記の共有に関して、そのほかに実装可能な設定(カスタムタブ)

これまで開催したカスタム関数マスター講座のアンケートにて寄せられたご質問に対する回答や関数の共有、および実際の回答を参加者の皆さまのZoho サービスの環境で動作確認していただきます。
また、質疑応答のお時間もございます。こちらでは、関数に関する疑問点や不安な部分を発案ユーザーさまへ確認しながら進められます。
━━━━━━━━━━━━━━━━━━━━━━━━
※一部タイムテーブルの内容を変更する可能性がございます。最新情報につきましては申し込みフォームをご確認ください。

・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・
詳細 / 参加申し込みはこちら:https://zoho.to/minimeetup20230215
・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・

──────────
◎開催回について
今回のカスタム関数マスター講座は、開催回によってタイムテーブルが異なります。
2022年10月から2023年3月まで、毎月一回開催予定です。

第1、3、5回目(奇数回)           
  • Zoho ユーザーが活用している関数例の紹介
  • 参加者の皆さまと一緒にカスタム関数の作成
  • 情報交換会(フリートークの時間)
第2、4、6回目(偶数回)
  • 課題の回答共有、課題に関する質疑応答
  • 情報交換会(フリートークの時間)
──────────
◎注意事項
  • カスタム関数マスター講座では、参加者の皆さまにも実際の関数をコピーペーストして動きを見ていただきます。そのため、あらかじめZoho サービス を操作しながらご参加いただけますと理解が深まります。

  •  Zoho CRM のクライアントスクリプト、ワークフローの実行する処理におけるカスタム関数はエンタープライズプラン以上で利用できます。
    本番環境とは別の独立したテスト用の環境が利用できる「サンドボックス」も同様のプラン以上で利用可能です。

  •  講座の途中で質疑応答のお時間がございますが、個別のご質問になってしまう場合は別日程に開催予定の「Zoho ワークアウト」への参加をご検討いただけますと幸いです。 
次回のZoho ワークアウト 開催日程:2023年2月21日(火)14:00-17:00
・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・
詳細 / 参加申し込みはこちら:https://zoho.to/workout20230221
・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・・
  • 本講座の録画の共有はございません。
  • 本講座にて共有されたスクリプトによる本番環境への影響、データ消失、その他の問題につきましては責任を負いかねます。
  • カスタム関数マスター講座に関するご不明点については、community@zoho.co.jp までお気軽にお問い合わせください。
━━━━━━━━━━━━━━━━━━━━━━━━

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

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




      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

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

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • How can I see content of system generated mails from zBooks?

                                    System generated mails for offers or invices appear in the mail tab of the designated customer. How can I view the content? It also doesn't appear in zMail sent folder.
                                  • CRM Blueprint Notification by Cliq

                                    Dear Zoho team, In Workflow, there is nofication by cliq, but in blueprint, there is no option as cliq notification. I think it is very convenient to get notified by Cliq , as there are multi modules in apps, but we will always check Cliqs
                                  • Sync Contacts in iOS

                                    What does the "Sync Contacts" feature in the iOS Zoho Mail app do?
                                  • Live webinar: Craft the ideal sales pitch deck with Show

                                    Every great sale starts with a great story. And your pitch deck? That’s where the story takes shape. But too often, these presentations end up looking generic, overloaded with text, or lacking structure. The good news is, it's easier to fix than you think!
                                  • Project Statuses

                                    Hi All, We have projects that sometimes may not make it through to completion. As such, they were being marked as "Cancelled". I noticed that these projects still show as "Active" though which seems counter intuitive. In fact, the only way I can get them
                                  • 👋 Welcome to the Zoho MCP Community

                                    Hello all, glad to have you here! This is your space for everything AI agents, MCP tools, and intelligent business apps. This community is for you — developers, partners, creators, and businesses exploring how agents can transform work. Whether you’re
                                  • DNS Manager

                                    Where Can I find my DNS manager so I can link this to click funnels or AWEBER
                                  • How do I sync multiple Google calendars?

                                    I'm brand new to Zoho and I figured out how to sync my business Google calendar but I would also like to sync my personal Google calendar. How can I do this so that, at the very least, when I have personal engagements like doctor's appointments, I can
                                  • Need to extract date from datetime field

                                    I have a datetime field and need only the date part from it. I am unable to find a built-in function that would be <DateTime>.Date(). I don't think I want to go the string conversion route of converting the datetime to string and then parsing out values and create a date out of it. Any one out there has a better solution to this? Thanks in adavnce. Regards Moiz Tankiwala Smart Training & IT Solutions
                                  • New in Cadences: WhatsApp follow-ups, upgraded limits, and options for add-ons

                                    Hello everyone, We're rolling out two key updates to help you engage better and scale smarter with Cadences in Zoho CRM. Reach customers on WhatsApp, directly from Cadences Previously, Cadences have enabled you to automate follow-ups through emails, calls,
                                  • additional accounts

                                    If I brought 5 emails to my account. Can I later buy additional emails.
                                  • Why I am unable to configure Zoho Voice with my Zoho CRM account?

                                    I have installed Zoho Voice in my Zoho CRM, but as per the message there is some config needed in Zoho Voice interface. But when I click on the link given in the above message, I get an access denied page.
                                  • Issue with Hour Calculation in Zoho People Attendance Module

                                    I have noticed an issue in the attendance regularization feature of Zoho People. When trying to regularize past dates, the total working hours are not calculated correctly. For example, if I enter a check-in and check-out time for a previous day, the
                                  • Cliq Meeting Calls No Audio and Screen Share

                                    When in a Cliq channel meeting, the audio does not work at all on pc. When i use my phone as audio source, screen share on pc does not work. I have updated audio drivers but the strangest thing is that during a 1 on 1 call, it works well. Therefore the
                                  • Work anniversary and birthdays on connect

                                    Hello, I like the idea of having employee's work anniversary and birthdays on the dashbaord. Do you have to have the employee complete this information themselves in connect settings, or does it pull from their directory settings? (ie. we use Zoho one
                                  • Alias Email Id already exists

                                    Hi I'm trying to create an alias : contact @ yoavarielevy.co.il but i get the message  Alias Email Id already exists I had an account with the same name but I deleted it. Can you help? Thanx Yoav
                                  • Feature Request: Ability to Set a Custom List View as Default for All Users

                                    Dear Zoho CRM Support Team, We would like to request a new feature in Zoho CRM regarding List Views. Currently, each user has to manually select or favorite a custom list view in order to make it their default. However, as administrators, we would like
                                  • Adding Multiple Products (Package) to a Quote

                                    I've searched the forums and found several people asking this question, but never found an answer. Is ti possible to add multiple products to a quote at once, like a package deal? This seems like a very basic function of a CRM that does quotes but I can't
                                  • webinar registration confirmation are landing in SPMA folders

                                    I am trialing zoho webinar and do not have access to custom domains. When I test user registrations, they are working but the resulting confirmation email is landing in a spam folder. How can I avoid this?
                                  • Multiple organizations under Zoho One

                                    Hello. I have a long and complicated question. I have a Zoho One account and want to set it up to serve the needs of 6 organizations under the same company. Some of the Zoho One users need to be able to work in more than 1 organization’s CRM and other
                                  • Error AS101 when adding new email alias

                                    Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                  • Unbundle feature for composite items

                                    We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form
                                  • Regarding the integration of Apollo.io with Zoho crm.

                                    I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on Google
                                  • workflow not working in subform

                                    I have the following code in a subform which works perfectly when i use the form alone but when i use the form as a subform within another main form it does not work. I have read something about using row but i just cant seem to figure out what to change
                                  • Fetch data from another table into a form field

                                    I have spent the day trying to work this out so i thought i would use the forum for the first time. I have two forms in the same application and when a user selects a customer name from a drop down field and would like the customer number field in the
                                  • Record comment filter

                                    Hi - I have a calendar app that we use to track tasks. I have the calendar view set up so that the logged in user only sees the record if they are assigned to the task. BUT there are instances when someone is @ mentioned in the record when they are not
                                  • How to View Part Inventory and Warehouse Location When Creating a Work Order in Zoho FSM

                                    Hi everyone, We’re currently setting up Zoho FSM and would like to improve how our team selects parts when creating a Work Order. Right now, when we add a part or item to a Work Order, we can select it from our Zoho Inventory list but we don’t see any
                                  • FSM too slow today !!

                                    Anybody else with problem today to loading FSM (WO, AP etc.)?
                                  • Not able to Sign In in Zoho OneAuth in Windows 10

                                    I recently reset my Windows 10 system, after the reset when I downloaded the OAuth app and tried to Sign In It threw an error at me. Error: Token Fetch Error. Message: Object Reference not set to an instance of an object I have attached the screenshot
                                  • Mapping a custom preferred date field in the estimate with the native field in the workorder

                                    Hi Zoho, I created a field in the estimate : "Preferred Date 1", to give the ability to my support agent to add a preferred date while viewing the client's estimate. However, in the conversion mapping (Estimate to Workorder), I'm unable to map my custom
                                  • Is there a way to request a password?

                                    We add customers info into the vaults and I wanted to see if we could do some sort of "file request" like how dropbox offers with files. It would be awesome if a customer could go to a link and input a "title, username, password, url" all securely and it then shows up in our team vault or something. Not sure if that is safe, but it's the best I can think of to be semi scalable and obviously better than sending emails. I am open to another idea, just thought this would be a great feature.  Thanks,
                                  • Single Task Report

                                    I'd like a report or a way to print to PDF the task detail page. I'd like at least the Task Information section but I'd also like to see the Activity Stream, Status Timeline and Comments. I'd like to export the record and save it as a PDF. I'd like the
                                  • Auto-response for closed tickets

                                    Hi, We sometimes have users that (presumably) search their email inbox for the last correspondence with us and just hit reply - even if it's a 6 month old ticket... - this then re-opens the 6 month old ticket because of the ticket number in the email's subject. Yes, it's easy to 'Split as new Ticket', but I'd like something automated to respond to the user saying "this ticket has already been resolved and closed, please submit a new ticket". What's the best way to achieve this? Thanks, Ed
                                  • How to Push Zoho Desk time logged to Zoho Projects?

                                    I am on the last leg of my journey of finally automating time tracking, payments, and invoicing for my minutes based contact center company - I just have one final step to solve - I need time logged in zoho desk to add time a project which is associated
                                  • Cannot access KB within Help Center

                                    Im working with my boss to customize our knowledge base, but for some reason I can see the KB tab, and see the KB categories, but I cannot access the articles within the KB. We have been troubleshooting for weeks, and we have all permissions set up, customers
                                  • Export to excel stored amounts as text instead of numbers or accounting

                                    Good Afternoon, We have a quarterly billing report that we generate from our Requests. It exports to excel. However if we need to add a formula (something as simple as a sum of the column), it doesn't read the dollar amounts because the export stores
                                  • why my account is private?

                                    when i post on zohodesk see only agent only
                                  • Getting ZOHO Invoice certified in Portugal?

                                    Hello, We are ZOHO partners in Portugal and here, all the invoice software has to be certified by the government and ZOHO Invoice still isn´t certified. Any plans? Btw, we can help on this process, since we have a client that knows how to get the software certified. Thank you.
                                  • 500 Internal Server Error

                                    I have been trying to create my first app in Creator, but have been getting the 500: Internal Server Error. When I used the Create New Application link, it gave me the error after naming the application. After logging out, and back in, the application that I created was in the list, but when I try to open it to start creating my app, it gives me the 500: Internal Server Error. Please help! Also, I tried making my named app public, but I even get the error when trying to do that.
                                  • Client Script | Update - Client Script Support For Portals

                                    Dear All! We are excited to announce the highly anticipated feature: Client Script support for Portals. We understand that many of you have been eagerly awaiting this enhancement, and we are pleased to inform you that this support is now live for all
                                  • Next Page