【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 までお気軽にお問い合わせください。
━━━━━━━━━━━━━━━━━━━━━━━━

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

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



    • Recent Topics

    • Introducing 'Queries' In Zoho CRM

      Hello everyone! We are here with an exciting feature - Queries in Zoho CRM! A little context before we dive right into the feature specifics :) In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.

    • Enable Sending Direct Messages to Self in Zoho Cliq

      Hi, I would like to request a feature enhancement for Zoho Cliq to allow users to send direct messages to themselves. Currently, Zoho Cliq does not have the option to send a direct message to oneself. While creating a channel with just one member (the

    • Admin Access to Direct Messages in Zoho Cliq

      Hi Zoho Cliq Team, We would like to request a feature enhancement to enable admin access to one-on-one conversations (direct messages) conducted through Zoho Cliq. Use Case: As administrators, there are situations where it becomes essential to access

    • Need help with KPI Widget on Dashboard

      What I am trying to accomplish seems simple, but I cannot figure it out.  Please help. I would like to show in a KPI Comparison Widget: Number of Meetings (CRM) Held in Last 30 Days compared to Number of Meetings Held the previous 30 days (from the date

    • Need to send message to slack channel from zoho people form

      - I have setup slack connection in zoho people, it is successfully showing connected - I am using connection name to send message view custom function, but it is not working: response = invokeurl [ url :"https://app.slack.com/client/T78002gHF/C089773324"

    • User tiers

      I am trying to add tiers of users. I would like: Me - CEO Next Tier down - Managers Next tier down - All the salepeople reporting to each manager I can only seem to add myself with mansagers below. Surely I can add more tiers?

    • Flow to follow up on trade fair contacts

      Hi, Before we moved to Zoho we had some flows (sequences) in HubSpot to follow up on trade fair contacts. To explain further on this it had the following characteristics: New contacts could be added to the sequence When added a flow of communication started.

    • Queries filtered by current page/record

      I have been trying to use the new queries feature, and I can filter the query, but I'm coming unstuck because I don't understand how to make the query dynamically include the filter of the current record. ie if I'm on a deal, to filter all the records

    • Article Numbers for KB articles

      Hello, I was wondering if it's possible to turn on article numbers/ part numbering for KB articles. If this is not already a feature, we'd like to request it. Frequently a solution will require multiple articles so tracking which articles are referenced

    • Audit Log Export via API

      Hello, Based on the documentation here https://www.zoho.com/crm/developer/docs/api/v7/create-export-audit-log.html I need to specify the scope ZohoCRM.settings.audit_logs.CREATE to create a log export. I've created a Self Client app but when I specify

    • Zoho CRM API Credits & Limits for Workflow

      Hi Team, Just wanted to clarify how the API credits work for Zoho CRM and workflows with custom functions. API Credits are based on your subscription and are set at the account level. You can buy additional credits if needed. For Enterprise customers,

    • How to easy change layout in existing records in Deals?

      Hello, So far i have used only 1 layout in Deals. I have about 1000 records. Now i want to make new layout. So i have 2 layouts: Layout Old (1000 records) Layout New (0 records) How to easy change layout from Layout Old into Layout New for existing records?

    • Change Last Name to not required in Leads

      I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions for

    • "Copy Field Values from one Module to another" how to use?

      Hi everyone! I'm sorry if this question was already asked, I didn't find it! So let me explain:  In my Tickets module, we have the custome field "customer type" where we indicate if it's a lead, user, etc... In the Contact module I used the "type" field with exactely the same entries. I would like when in the tickets module an operator choose an option that it automatically update it in the contact module. I found the "Copy Field Values from one Module to another" custom function which seems perfect

    • New Leave Type: Compensatory off

      Hi, there is a new Leave Type: Compensatory off. Can someone tell me how to use it, because it sounds it could work for overtime compensation for our techs. Thanks Andreas

    • Introducing bot filtering for accurate analytics

      Dear Zoho Campaigns Users, We're happy to introduce bot filtering to enhance the accuracy of your email campaign analytics. This new feature is designed to help you filter out bot-generated opens and clicks, which will ensure your campaign reports reflect

    • Introducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities

      Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text based

    • How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

      How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

    • Zoho Desk Validation Rule Using Custom Function

      Hi all, I tried to find the way to validate fields using custom function just like in Zoho CRM but to no avail. Is there a way to do this?

    • Archive Option in Conversation View

      Hello, I have a suggestion\request to add an "Archive Thread" button in conversation view of Zoho Mail. The best suggestion I have is to put an "Archive Thread" button next to the "Label Entire Thread" button in conversation view. Most users don't just

    • Possible to backdate Stage shifts in Deals module?

      I want to enter my organisation's historical dealflow data into the CRM and it's important that the Stage history is showing the correct dates in the past of when it happened. Is there a way for me to modify the "Modified Time" in the Stage History Related

    • Layout Prompt when creating an oportunity

      Hi There, Is there a way to create a pop-up prompt when I create a new Deal giving me the option of what layout to use based on a certain requirement? So, if the prompt had two options 1. is a new business Deal 2. is a renewal Deal Thanks in advance

    • Conditional layouts - support for multi-select picklists

      Hi, The documentation for conditional layouts says the following: "Layout Rules cannot be used on the following field types: Auto Number Lookup Multi Select Lookup User Lookup Formula File Upload Multi Line" I have a custom module with a multi-pick list

    • Elevating Email Security on Zoho Desk: DKIM Now Mandatory

      Hello Zoho Desk Users! It has been a wonderful journey with you on Zoho Desk. As we welcome 2025, we are strengthening our efforts to ensure a secure and seamless experience for you. To enhance email security, DKIM configuration will be mandatory for

    • How to upload mass inventory quantity adjustment with batch number?

      I wanted to clean-up our inventory list; however, I have trouble performing the task as I don't know how to mass upload inventory adjustment with batch numbers. I don't want to do it manually as there are if not thousands at hundreds of inventory tr

    • Product sale report with margins

      we unable to get the data as per product sale report with margins so we need help in this

    • CLIENT PORTAL (If clients can place orders directly on the portal)

      Zoho client portal is excellent. Everything is there except one thing. Client should be able to place orders directly on the portal. This would enhance the portal and end users will be extremely happy. This suggestion infact came from one of our client.

    • Is there provision to charge the attendees to join the webinar?

      We want to host some webinar of public interest and want to charge them to participate in this. Does this feature in-build in the application? Offcourse, we will be having Razor pay account activated for these purpose.

    • Zoho Vault App for Windows

      Hello, is there a Windows app that can be used to access the passwords saved in Zoho Vault? Thank you

    • Emails take up to 14 hours to arrive and often never arrive at all.

      I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from

    • Emails take up to 14 hours to arrive and often never arrive at all.

      I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from

    • Print PO receipt

      Hi I would like to print the PO receipt. There does not seem to be any way to do this. I track batch numbers and printing the PO does not show this. Only the receipt would show the details of the receipt. Currently I print the screen which does not have

    • "We’ve fine-tuned Zoho Inventory..."

      Every day I have this message at the top of my screen. I hit refresh everyday and then the next I see it again. What is being "fine-tuned" on a daily basis?

    • How can the direct link to a ticket be created from ticket #?

      Our agents will be using ZDesk but we will have to create direct link to tickets in another ERP by providing the Desk Ticket # Is there a way to create the direkt links from the ticket # alone? Do we have to use the API to get the direct links?

    • Allow standard layout to be used/edited as a starting point for canvas

      Hello, I would really love to improve the look of our CRM interface using Canvas but we have spent so much time customising the screens already (in standard view) that the thought of starting from scratch and building everything again, field by field,

    • How to link to/displaya png stored in workdrive in a Creator HTML snippet?

      How to link to/display png stored in workdrive in a Creator HTML snippet? I've tried it as a plain external link and as an iframe. The iframe works but is kinda slow...and I'd prefer to be able to do finer-grained positioning but referencing the png as

    • Has anyone built a ticket export that allows Help Center users to export the tickets shown in the My Area list they are looking at?

      Hi, We are moving to Zoho Desk soon. Our current support system displays an option in our help center allowing customers to export their Open, Closed, or all tickets based on which list they are looking at. We need to offer the same in Zoho Desk help

    • Contemplating moving my site from WordPress to Zoho Sites

      Hi Everyone, We currently find ourselves in a situation where we ant to review and update our current sites content. We are small business owners, not developers. We currently use a wide range of Zoho products. We sometimes think about the possibility of either moving or just starting from scratch on Zoho Sites. I would like to know if anyone has done this and of course the things that need to be considered. We have spent quite a bit of time getting our current site positioned organically and I guess

    • Using AVG in SQL Query

      My current SQL Query is: SELECT "Client Info", avg("Revenue") FROM "Funded Deals" GROUP BY "Client Info" The current table that this is creating: Client Info avg(Revenue) Previous 4175 1st - New 3411 1st - Old 3013 Renew 3069 While this works as I had

    • Unified customer portal login

      As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is that

    • Next Page