【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

    • VAT rates - exempt and out of scope

      Good Evening, UK based company here. I am a bit confused in respect of setting up VAT rates for exempt goods and services; at present I am simply leaving the VAT rate blank in the transactions in order to prevent any VAT appearing in the VAT return. When

    • How to loop through Multiple Upload and Display Actual File Name

      I have been reading the help on the File Upload Control and reviewed the Deluge help on files and I can not figure out how to loop through the uploaded files and do anything but get the automatically created file names. The code below will run but each

    • abou arattai

      I want to use the Arattai app for business purposes, so please convert my account to a business account.I have my own invoice app, and I want to link it with the Arattai app for direct messaging.

    • Overlapping Reports in Dashboards

      It's rare, but occasionally it would be a good feature if I were able to overlap reports, either fully or partially in the Dashboards. Also, then having the ability to move objects to the front or rear, or make them transparent/translucent would be good

    • Looking back at Zoho Calendar in 2025

      Hello Zoho Calendar Community, As we step into a brand-new year, we’d like to take a moment to thank you for being an active and valued part of the Zoho Calendar community. Your trust, feedback, and continued engagement motivate us to keep evolving and

    • There was an error while connecting to GSTN

      I am trying to file GSTR1. Everything flows smoothly until I reach the final step of filing the return. After I enter the PAN and OTP for filing it raises the error "There was an error while connecting to GSTN"

    • Zoho Books Extension: What Happens If Custom Fields Already Exist?

      When developing Zoho Books extensions, what happens if the target Zoho Books organization already has a custom field with the same API name as one defined in the extension? I’m asking because we originally created an on-Books version of this functionality,

    • Internal Server Error (500) When Attempting to View Banking Transactions

      I am experiencing an Internal Server Error (500) when attempting to view transactions across all of my banking accounts. Despite multiple attempts to resolve this, I have received little more than runaround from support, and the issue remains unresolved.

    • How do I add a blank line to the Organisation Address Format?

      I'd like to have my VAT number, for example, shown prominently by having a clear gap between it and the address block above, but any blank lines in the address format get ignored in PDF outputs.

    • Automatic Invoice Number generation for createRecord

      Hello, while testing some custom Buttons in my Zoho Books application, I noticed that I get an error that previously did not occur. After some further digging I found that the automatic transaction numbering of invoices no longer work in my organization.

    • Adding number of days to an estimate.

      I need both QTY of item and "number of days hire" in my estimates at the line item level. Any clues as to how this is done would be greatly appreciated. It needs to calculate. Thanks J

    • Books Api: listing expenses created after certain dates

      Is there any parameter I can add to the List Expenses endpoint that will let me look up expenses by when they were created?

    • Why can't we change the Account type from an Expense to an Asset?

      Like the question. Why in QuickBooks for example if I mistakenly created an account as an expenses and I already captured information in those accounts, I can just change the account type from expense to asset

    • Is it possible to do validation for the Actions added to Reports?

      We have an all-around On Validate function that checks all the possibilities before the Created/Edited form submissions. We want to have a button in the report view, so we can change records without entering. We are able to add this button, and it does

    • Ability to Edit Ticket Subject when Splitting a Ticket

      Often someone will make an additional or new request within an existing ticket that requires we split the ticket. The annoying part is that the new ticket maintains the subject of the original ticket after the split so when the new ticket email notification

    • [Free Webinar] Environments in Zoho Creator - Creator Tech Connect

      Hello Everyone, We’re delighted to kick off the 2026 edition of the Zoho Creator Tech Connect Series and are excited to continue this learning journey with you. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions

    • Zoho Voice API SMS

      I made a post request in Zapier to try to send an SMS. Authentication appears to be configured correctly. I followed the documentation and I'm getting a 400 Error "Internal Server Error". Not helpful at all. Anyways, I could not find any information on

    • How do I change (error) display messages

      Hi! I would like to edit display messages like "invalid entries" and "enter a value for Nome" and so on into Italian language messages. How can I do that? Already tried on Validate on form submit. Where I am failing? Thanks in advance.

    • Record Overseas Transactions Along with CC charges

      Hi All, We receive payments via stripe in multiple currencies and stripe takes around 2.5% fees. The amount is settled in INR into our local bank. What should be the currency of the income account used for Stripe payments? Here is a sample flow that we

    • Easier onboarding for new users with stage descriptions

      Greetings, I hope all of you are doing well. We're happy to announce a recent enhancement we've made to Bigin. You can now add descriptions to the stages in your pipeline. Previously, when creating a pipeline, you could only add stages. With this update,

    • Pieds de page personnalisé - Document Zoho Writer

      Bonjour à tous, Je rencontre un souci avec l’ajout d’un pied de page personnalisé dans un document Zoho Writer. Je souhaite insérer les informations de mon entreprise (notamment un logo + adresse) dans le pied de page. Le problème, c’est que lorsque j’ajoute

    • Permissions on Views

      Having the option of any agent creating custom views is firing back and got a situation where there are a hundred different views across the team and tickets are not being dealt in the most efficient of ways. Tickets seems to be missed by some agents,

    • Credit card transactions are backwards after importing statements

      I am new to Zoho Books so I'm importing my firm's bank and credit card statements in. My credit card statements have a single column with negative numbers so that is the option I chose. But when I went to categorize the credit card transactions, I can

    • import data from Apollo.ai into zoho crm via zoho flow

      I might be asking this question in the wrong forum. We use Apollo.ai to find potential new leads for our business, there are around 10000 leads that we have initially found. We have an Apollo.ai account but just to do searches, we dont use it as a crm.

    • Knowledgebase SEO

      We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by search

    • VIsual maindmaps in Zoho notebook Ai

      Can I create and export VIsual maindmaps in Zoho notebook Ai

    • 1stDibs Integration to Zoho Inventory

      Hello is it possible to integrate my Zoho inventory and 1stDibs?

    • Community Question: Renewal vs Invoicing

      This is a question for the community. Does anyone else consider there to be a difference between a subscription renewal event and sending out a recurring invoice for a subscription? For example, let's say customer XYZ purchases a 1-year subscription to

    • cloud console support for music websites

      Hi Friends, I am not from a very technical background.. So need support from the Zoho family. I want to build a e-commerce website which is in Musical Niche. It will help people learn music & play instruments of all types. There are a few players in the market like Chordify , Guitaa, Guitar Dashboard, ChordU & few others. But I all these websites allow only a few instruments  to play. So I want to build a better  website than the one I mentioned. So wnated to know what UI & AI should I use so that

    • Scheduled Reports - Do not send empty report

      Hello, We are intensively using reports in the CRM, especially for sales managers. When data is empty, they still receive an email. Can you add an option to avoid sending the report when data is empty?

    • Is Zoho One Desktop more secure than Zoho One Web SaaS?

      Is Zoho One Desktop more secure than using Zoho One in browser? Inherently, it seems desktop would be unless you don't do things like share your pw or leave pc on. I am concerned about data being on the cloud or someone else's server and database.

    • Reminder Settings - Time Tracker

      On the time tracker in Reminder Settings I created a reminder according to the Zoho manual. But a manager asked me to change the message that goes in the email. Is it possible to change the message? I didn't find that in the Zoho manual. Another question: I configured to receive the reminder everyone who logged in less than 40 hours. Does Zoho consider less than 40 hours of the current week or the whole month? Another situation, I put it so that I and another specific user would receive the notification,

    • Create Item group from a composite Item

      I have applied my mind for hours but cannot figure this out. Can you have a composite item in an item group?. E.g. We bundle different color and size SKU's together as composite items. Also Using composite items as Bill of Materials. We want to create

    • Main difference of Zoho Recruit Corporte version and Staffing HR vesion

      Hi Zoho, I need help to fully understand what is the main key point differences of Recruit Corporate version versus the Staffing HR version? We are currently using Corporate HR version and we are looking on having an insightful automated reporting, does

    • Out of Stock items showing in Commerce

      I have over 6000 items and most are not in stock, but all items are showing up in Commerce whether they are inventory or not. What option or feature can you use to hide items in Commerce at zero or negative quantities? I currently am using Commerce for

    • Is it possible to transfer data from one related list to another within the same module ?

      In the Leads module, there is an existing default Product related list that already contains data. Recently, I added a custom multi-lookup field, which created a new related list in the same Leads module. Now, I need to move the existing data from the

    • 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

    • Formula working in MS Excel , is not working in Zoho Sheets, Filter fuction which is working in MS sheets per the attached workbook / Daily update.

      Filter function , which is working in MS Excel is not working in Zoho sheets. Please help on function of filter of particular class sheets and extract students name who has more than 3.5 hours of study hours on particular day depending on date in D7 cell.

    • New in Smart Prompt: Record Assistant for contextual assistance, and support for new AI models

      Smart Prompt helps teams stay informed and move faster by providing relevant suggestions where work happens in CRM. With this update, Smart Prompt becomes more adaptable to your organization’s AI preferences. You can now choose which Large Language Model

    • Improved Integration Failure Information (And Notification Options)

      Hi, When an attachment service for example fails, you just get "Field x - Error", I can check the field it is failing on and find nothing wrong, same file size, type, dimensions, etc. so more information as to the actual issue would be helpful. And an

    • Next Page