【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

                                                                                                              • Impossibile inviare il messaggio;Motivo:554 5.1.8 Indirizzo del mittente bloccato

                                                                                                                " Impossibile inviare il messaggio;Motivo:554 5.1.8 Indirizzo del mittente bloccato" Hi need to send email, how can fix this? Thanks, Alice
                                                                                                              • Image inputed in Zoho Form were displayed to small in exported version

                                                                                                                Good evening, my name is athallah, i am a trainee in government office Right now, i use Zoho form to digitalize an airfield monitoring form. my problem is, the image were to small to displayed in exported version. it really bad for formal presentation
                                                                                                              • API. How do I get responses submitted to the form?

                                                                                                                Hi, I'm trying to retrieve a list of form responses via the API. I've created a Self Client application in API Console. What scoup should I enter? What are the endpoints? Is there documentation on this anywhere? I've wasted a lot of time searching. GPT
                                                                                                              • Question about Zoho CRM Professional plan users

                                                                                                                Hello! I have a question about the Zoho CRM Professional plan. Is the pricing charged per user or per organization? Are there any free users included in this plan, or do I need to pay for each additional user separately? Thank you!
                                                                                                              • Communicating with emojis

                                                                                                                On July 17, we celebrate World Emoji Day! We're a bit late 😐 sharing insights about this day. But we just couldn't let it pass without a mention 😊 because emojis have a meaningful connection with customer service 💬 🤝. We do not want to miss out on
                                                                                                              • Help integrating Aircall into Zoho CRM

                                                                                                                Hi all, We are need to get better AirCall integration into Zoho. We have configured in the Aircall dashboard but we have not done the Zoho side. We cannot see Zoho CRM information on incoming calls. And we calls and text's are not being logged. Specifically
                                                                                                              • Shopify Extension no longer working in CRM

                                                                                                                Zoho CRM and Extension are no longer working properly. We have used Shopify Basic for years. All of the sudden it stopped working, then started working again, and now no longer working again. There are several ways for Personal Information to sync from
                                                                                                              • How to keep track of bags, cans, drums of inventory?

                                                                                                                We buy and sell products that are packaged in bags 🛍️, cans🥫, drums🛢️, etc. with batch numbers. When we get a shipment of one of the products, how do we track we received (say) 10 cans each of 5L of a product and maybe we received 10 cans of another
                                                                                                              • Easy third party collaboration: Zoho Flow Integration

                                                                                                                Third-party integrations extend your project functionality with improved workflow, and data processing. With Zoho Flow integration you can include multiple third party actions into your project or task automation. Add Zoho Flow action in Workflow rules
                                                                                                              • Introducing Configure, Price, Quote (CPQ) in Zoho CRM | Public early access 2023

                                                                                                                Greetings Customers! We're excited to announce that the CPQ feature will soon be available in Zoho CRM and accessible to all accounts using the Professional, Enterprise, and Ultimate editions. We've opened this feature to select customers, and it'll be
                                                                                                              • how to edit the converted lead records?

                                                                                                                so I can fetch the converted leads records using API (COQL), using this endpoint https://www.zohoapis.com/crm/v5/coql and using COQL filter Converted__s=true for some reasons I need to change the value from a field in a converted lead record. When I try
                                                                                                              • Share Video Response Card ion Zobot

                                                                                                                I am using the zobot codeless bot builder in SalesIQ. I want to share a video but delay the next response card until after the video has finished playing or has been stopped. Is this possible?
                                                                                                              • Zoho Bookings <> CRM integration

                                                                                                                Hello Zoho community! We are enabling our Zoho Bookings <> CRM integration. What is the workflow if the integration detects that the contact already exists in the CRM? Does it create a duplicate record? Overwrite the record? Merge the record? (in this
                                                                                                              • Cannot reject empty expense report

                                                                                                                Hello, We are currently having issues with two empty expense reports where if we try to reject them, either manually or through the REST API, we get error 114016, which says some of the expenses have already been billed and must be removed. I'd appreciate
                                                                                                              • Use of Zia within Forms

                                                                                                                I have noticed that recently you have added Zia to help create forms from scratch. Would it be possible to add Zia functionality to free text fields for form submissions or if this is already on the roadmap an ETA for this please? We have a lot of field
                                                                                                              • Default in fields on Form B based on the user selection in Form A

                                                                                                                Hi Everyone, I have added an action button to a form report to bring up a new form based on user selection, see it indicated in red below: Then when the ne form loads, I want to default in some of the fields based on the record the user was selected on.
                                                                                                              • Last activity time is acting like last modified time

                                                                                                                When i edit the description or any field in the potential, account, contact and lead, the Last Activity Time is being updated like the Modified Time. This is messing all workflows and reports and we are unable to track real last time of activities like
                                                                                                              • Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

                                                                                                                Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With
                                                                                                              • HEX/RGB Color Input in Visual Editor

                                                                                                                Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to improve the color selection options in the Pagesense popup editor. Current Limitation: Currently, to set text colors, users must move the color slider manually.
                                                                                                              • CRM and Campaigns- tags not integrating?

                                                                                                                Hi! I am setting up an automation in zoho campaigns and it says the crm is integrated...but when I want to use a trigger of a certain tag I created for people in the crm to denote those who purchased, it doesnt have that tag available as an option in
                                                                                                              • Maximum limit of rows exceeded

                                                                                                                I am trying to add a row to a spreadsheets that has fewer than 60 rows. I keep getting an error message that says I have exceeded the maximum limit of 65,536 rows. Any ideas out there?
                                                                                                              • Can't change form's original name in URL

                                                                                                                Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new
                                                                                                              • Tip #7: 5 formas de mantener tus listas de correo electrónico

                                                                                                                Tips and Tricks #7, adaptado de Susmit Sen ¡Hola, comunidad! Esta semana volvemos con nuestros Tips and Tricks para Zoho Campaigns. En esta ocasión, voy a darte algunos consejos para mantener limpias tus listas de correo electrónico, y empezar el 2021
                                                                                                              • Mail Merge related Lists

                                                                                                                When I try to merge an associated list the fields do not have a checkbox to choose them as it does in the tutorials. Am I missing something? Any ideas would be appreciated.
                                                                                                              • create-a-purchase-receive API issues

                                                                                                                Hello all, I'm trying to use the create a purchase receive inventory API documented here (https://www.zoho.com/inventory/api/v1/purchasereceives/#create-a-purchase-receive) however when I do am getting the following error {"code":9,"message":"The purchase
                                                                                                              • Zoho Pagesense really this slow??? 5s delay...

                                                                                                                I put the pagesense on my website (hosted by webflow and fast) and it caused a 5s delay to load. do other people face similar delays?
                                                                                                              • Heatmap: Missing Content Elements - Zoho Page Sense

                                                                                                                Hi there, I'm trying out Zoho Page Sense to generate heatmaps for my Wix pages. My problem: Some parts of my Wix pages don't show on my heatmap, the heatmap is just empty there. Maybe Wix default lazy loading setting causes this error? Is there a way
                                                                                                              • Marketing Tip #3: Use social proof to build trust

                                                                                                                People trust people. Showcasing reviews, testimonials, or “bestseller” badges on your product pages can nudge hesitant buyers toward purchase. Try this today: Add one customer testimonial or highlight your top-selling product on your homepage. Or, do
                                                                                                              • Writing by Hand in "Write" Notes

                                                                                                                Hi there! I just downloaded this app a few moments ago, and I was wondering if there was a way to write things by hand in "Write" mode instead of just typing in the keyboard. It would make things a bit more efficient for me in this moment. Thanks!
                                                                                                              • Make CAMPAIGNS email look as simple as possible

                                                                                                                Hi there I'm trying to make my Campaigns email look as much like a normal email as possible. I'm a bit stuck with the "justification" of the email email block. Can I LEFT JUSTIFY the "whole email" to make it look "normal"? (Please see screenshot attached)
                                                                                                              • Zoho Sign Reminder email template

                                                                                                                Is there a template we can edit for the reminder emails? I don't see it in Settings / Choose a template
                                                                                                              • Preview an upload PDF or File

                                                                                                                I have a form where the customer has to upload a file (normally PDF - never jpeg)  When in report view I want to be able to preview the uploaded file without having to download it.  If I click on the upload it downloads to my computer, I want to be able
                                                                                                              • How to filter emails by Reply-to field?

                                                                                                                I receive a very particular newsletter from an association A registered on a website W (that is used by many associations), and the emails fields are not great: the From just contains the generic website's W's email, while A is only mentioned in the Reply-to
                                                                                                              • How to invite friends on other social media platforms to one of my group chats in arattai?

                                                                                                                Hello, I have formed chat groups in arattai. I want to invite my friends on other social media platforms like WhatsApp/ FB to one of my groups. Different friends would be invited to different groups. How to share an invite link of one of my groups to
                                                                                                              • Line spacing

                                                                                                                I coudn't decrease the line spacing to space smaller then a single line. There is too much space between the lines that make the document look ugly. Please fix that. Liran. fonar
                                                                                                              • Google Fonts Integration in Pagesense Popup Editor

                                                                                                                Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to enhance Zoho Pagesense’s popup editor with Google Fonts support. Current Limitation: Currently, Pagesense offers a limited set of default fonts. Google Fonts
                                                                                                              • Control Position of “X” (Close) Button in Popup Editor

                                                                                                                Hello Zoho PageSense Team, We hope you're doing well. We would like to request a customization improvement in the PageSense popup editor. Current Limitation: Currently, the position of the “X” (close) button is fixed and cannot be customized in the popup
                                                                                                              • Add Standalone “Save” Button in Pagesense Popup Editor

                                                                                                                Hello Zoho Pagesense Team, We hope you're doing well. We would like to request an important usability improvement in the Pagesense popup editor. Current Limitation: There is currently no dedicated Save button while building a popup. The only way to save
                                                                                                              • Text Direction Control in Pagesense Popup Editor

                                                                                                                Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to add text direction control in the Pagesense popup editor. Current Limitation: Currently, the popup editor does not provide native support for RTL (Right-to-Left)
                                                                                                              • Autosave in Pagesense Popup Editor

                                                                                                                Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to enhance the Pagesense editor with an autosave functionality. Current Limitation: Currently, changes made in the Pagesense editor must be manually saved. In
                                                                                                              • Next Page