【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 までお気軽にお問い合わせください。
━━━━━━━━━━━━━━━━━━━━━━━━
以上、ご確認、ご検討の程よろしくお願いいたします。
ゾーホージャパン株式会社
コミュニティチーム
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Mayu Imanari
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Bookmark Loading is Buffering
Hi, i clicked on the bookmark tab, around yesterday and since then it's been constantly buffering and doesn't allow me to access the mail's i have tried login in and out but of no help also trying to share a screenshot of the issue around 232 kb size,Zoho Webinar custom registration fields into Zoho CRM
I am pushing webinar registrations into zoho crm as leads and this is working fine. I have added a few custom fields to my webinar registration and I wish for these fields values to get mapped into the resulting CRM lead record. I am not seeing anywhereGitLab Extension for Zoho Desk: Connecting support and development for faster resolutions
Hello everyone! We’re excited to introduce the GitLab Extension for Zoho Desk, an integration that bridges the gap between support and development teams. This allows tickets to be converted into actionable GitLab issues for faster resolutions, betterDownload Google Drive Shared Image/File Using Deluge – Complete Guide
Download Google Drive Shared Image/File Using Deluge – Complete Guide When working with Google Drive share links inside Deluge, many developers face a common challenge: 👉 How can we download a Google Drive file directly using Deluge? This article explainsHow to update Acuity appointment fields from Zoho Flow?
Hi, I need help with Zoho Flow → Acuity Scheduling integration. What I’m doing Appointment created in Acuity Zoho Flow creates a Zoho Calendar event I want to send the Zoho Calendar Event UID back into Acuity (into a custom form field) This is so thatError due to - 'Internal Exception' when uploading Sign-generated PDF file to workdrive via Deluge in Zoho CRM
Hi I wasnt getting this error a few days ago and my code had not changed, so I'm wondering if there's a Zoho bug somewhere? I am downloading a PDF file from a Zoho Sign url using invokeurl and then uploading it to a Workdrive folder using zoho.workdrive.uploadFile.When will Zoho Learn be able to support SCORM files on the mobile app?
When I click the SCORM content, I just get a message saying it's not possible yet. Yet implies that it will be coming soon. All I'm asking for is a realistic timeline so I know whether or not to invest my time in using it. If it will be soon, then I willNo horizontal scroll bar in reports
Hi support team, I created a pivot table report which contains many columns (in my application about 15). The problem is that there is no bottom scroll bar to display colums that does not fit within the browser page. I saw that it was possible to resize colums, but colums sizes are not saved within the session. So could you add scroll bar, and eventually make colums sizes stored in the user session ? Best regards,Zoho Map integration tasks have changed - you need to "Locate all instances of Zoho Map integration tasks in your Deluge scripts by searching for the v1 marker... before 16 January 2026"
Details of an issue specific to Zoho CRM + Deluge Functions (originally posted in this forum) can be found here: https://help.zoho.com/portal/en/community/topic/zoho-map-integration-tasks-have-changed-you-need-to-locate-all-instances-of-zoho-map-integration-tasks-in-your-deluge-scripts-by-searching-for-the-v1-markerfilter broke my data
I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize theyRequest to remove domain "greentechcoatings.vn" from previous Zoho account
Hello Zoho Support, I would like to register the domain "greentechcoatings.vn" in my new Zoho Mail account, but I receive the message "This domain is already associated with another account". Please remove the domain from any previous/unknown accountTrigger actions in third-party apps using Zoho Flow
Greetings, I hope you're all doing well. We're excited to share an enhancement to Bigin's workflow capabilities. Zoho Flow Actions are now available in Bigin, enabling you to automate tasks across third-party applications directly from your workflow andEnroll, Script, Win: Hackathon 2025!
Hello CRM Developers! Are you ready to create some magic with Client Script, Widgets and Functions in Zoho CRM? Let’s make Hackathon 2025 an unforgettable adventure! The Zoho Developer Community Hackathon 2025 is here, and it’s your time to shine! REGISTERZoho Help Desk - Not receiving emails
Hello… I am on your trial version of help desk… and I am having trouble getting emails from Zoho Help Desk to my MS Outlook Exchange Server… So when a customer sends ticket request I am not getting an email with a notification? I have read your articlesAlmost all Flows are being queued
A few days ago I saw one of my Flows status was Queued. This was the first time this had ever happened. Now, almost every Flow that triggers is Queued for at least a few minutes. If I re-trigger the Flow (which causes separate problems) they sometimesEmployment Contract / HRMS Documents - Zoho People
How do I create customized HR documents for disbursal from Zoho People ? Example, say offer letters ? appointment letters ? Memos ? We want to be able to preset these in one or ther other form and issue them to employees who are in Zoho People.Send Zoho Forms Link using Zoho CRM Email Templates
I have set up Zoho Forms and CRM integration to pre-populate data from Zoho CRM to Zoho Forms. The setup is working fine. I have also created an email template in the Zoho CRM deals module to send Zoho forms links. So when I send an email using that templateLive webinar: Craft and deliver impactful slides with Show’s desktop apps
If you love the comfort of working on your desktop and want a setup that keeps you focused and uninterrupted, this session is made for you. We’re excited to invite you to our upcoming live webinar: "Craft and deliver impactful slides with Show's desktopEnhancements to Bigin's forms
Greetings, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to Bigin's forms. We'll go over each one in detail. Merge field support in auto-filled forms The auto-fill option in Bigin's forms lets you predefineTable dimensions
I try changing the dimensions of the table on my computer but it doesn't change. Do I have to be a premium member or does it only work on the app?Direct link to Record Summary
Hi everyone, In one of my reports, I have built a Record Summary template to display the details of one record. I would like to be able to link directly to this Record Summary once I submit a new record, without having to go to the list of records first and click on View. Is there a possibility to do so ? Should I use the URL by passing some parameters ? Thank you very much for your help ! GuillaumeAmendment effective date
Hi everyone, I noticed that the amendment effective date mentionned in my amendment is not right. Indeed, when a contract is amended several times, it states the previous amendment and their effective date. However, the effective date stated is alwaysSTOCK history in zohosheets
is it possible to get historical stock value using stock function in zoho sheets? i could not see from and to period in the helper document.Auto sync Photo storage
Hello I am new to Zoho Workdrive and was wondering if the is a way of automatically syncing photos on my Android phone to my workdrive as want to move away from Google? ThanksZoho Desk Training
Hello, We've had Zoho desk for a while now, but we run into issues occasionally, and I was wondering if there was a customer who currently uses it and really enjoys the functionality, that would be wiling to chat with us?Text/SMS With Zoho Desk
Hi Guys- Considering using SMS to get faster responses from customers that we are helping. Have a bunch of questions; 1) Which provider is better ClickaTell or Screen Magic. Screen Magic seems easier to setup, but appears to be 2x as expensive for United States. I cannot find the sender id for Clickatell to even complete the configuration. 2) Can customer's reply to text messages? If so are responses linked back to the zoho ticket? If not, how are you handling this, a simple "DO NOT REPLY" asAgent password reset
Hi Zoho support, I would like to ask if there is a way the admin can reset a password of an agent? RegardsCan receive but not send messages in Zoho Mail
Hello! I was able to configure my email client successfully in that I can receive messages just fine. However, when I send messages out, they seem to go out fine (I don't receive any errors or anything), but the recipient does NOT receive those messages.Mail is sent twice!
Been using Zoho for a while now. Installed Zoho for someone else and some weird things are happening. Mails are being sent twice. He is using Thunderbird as an email client. I already read about email being duplicated in the sent folder. But in my caseCan't login IMAP suddenly
Since this evening I'm getting the error: You are yet to enable IMAP for your account. Please contact your administrator... IMAP always been enabled in my account and was workign fine for the past 7 years. Already tried turning IMAP off and on again.Sending of username did not succeed: Mail server pop.zoho.com responded: User already specified
I am having issues receiving emails from Zoho in Thunderbird. I am getting the above error. The first error tells me Authentication failed, and prompts me to enter in my password. Then I get the above error. I can receive emails when I log in online toBug tracking
Hi, does anyone know how to track errors during picking or packing? This way I can keep track and see how to improve and prevent errors in this area.Exact match in name when searching workdrive
Hello, I am wondering how to search workdrive files/folders with an exact match in the name. For example, when I search across folder with the url param search[name]=someName, I get multiple results such as "someName", "someNameAndMore", or "someNameFlow - Fetch info from drop down in another module
I am running into a road block which I thought would be a simple task. My goal - The account is assigned to a "route" which can be selected from a drop down menu and adds a tag to the account accordingly (easy enough). Now when I create a task for thisMigration of corporate mail environment from Yandex 360 to Zoho mail
I have to migrate a corporate mail environment with an existing domain from Yandex 360 to Zoho mail. It is vital to migrate all users with all the data. I have read the article on this topic using MacMister Email Backup Software just now and have someI'm unable to send mail pthrough Zoho SMTP programmatically
This has been working for years, but today it's been offline all day long. I see nothing anywhere on your site about this. I'm not the only one experiencing this. Downdetector has a spike of reports todayCan no longer send email via Django site
This was working fine as of 11/7/25. Now I am unable to send user verification emails from a Django site on a AWS lightsail sever. When a user attempts to register the following error occurs. I have also attempted to send a test email via the shell andunable to send email but able to receive email
my email address is info@securityforceservices.caCustom Field for Subscription
Hi, I can't find a way to add a custom field (to contain a license key generated from our software) against a subscription? Is the only place to add this information in the Invoice module (as custom field for invoice)? When a customer views his subscription via the customer portal, there appears no way to display a license key for them? The invoice is not the natural place to store a license key for a particular subscription, so where else can this be stored and displayed?Login to server failing
When trying to retrieve my mail, I am getting this error message -- Login to server pop.zoho.com with username (my email address) failed. It gives me the option to retry, enter password, or cancel. Then I get this message -- Sending of username did notNext Page