【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

        • Export all of our manuals from Zoho Learn in one go

          Hi, I know there's a way to export manuals in Zoho Learn, but I want to export everything in one go so it won't take so long. I can't see a way to do this, can I get some assistance or is this a feature in the pipeline? Thanks, Hannah

        • Automation#31: Automate Splitting Names for New Contact Records

          Hello Everyone, This week, we present to you a custom function, which allows you to split the first and last names from the user's email ID based on the separator used in the ID. Having grown into a large firm, Zylker Techfix aims to optimize its processes,

        • Automatically remove commas

          Team, Please be consistent in Zoho Books. In Payments, you have commas here: But when we copy and paste the amount in the Payments Made field, it does not accept it because the default setting is no commas. Please have Zoho Books remove commas autom

        • Transfer ownership of files and folders in My Folders

          People work together as a team to achieve organizational goals and objectives. In an organization, there may be situations when someone leaves unexpectedly or is no longer available. This can put their team in a difficult position, especially if there

        • Project Change Orders and Additions

          We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure out

        • ZOHO Desk - Description of slave ticket disappeared after Merge

          Dear Support, On Zoho Desk the description of a ticket disappeared after merging two ticket. The one which was the slave one completely disappeared. The problem that in this description there was an image which i had only on Desk in that ticket. Could

        • How do I insert a cross-reference link to a different section within one Knowledge Base article using Zoho Desk?

          I would like to insert a link within a Knowledge Base article to a different section of that same article. The section I want to link to is formatted with the Heading 3 style and is displayed within my TOC. However, I do not see any way to add a link

        • Problem Adding Facebook Account

          Hi, I'm new here, I'm having trouble setting up my Facebook account as a social channel. I think the issue is down to how my Facebook is set up, which is pretty confusing. I have a personal Facebook account (let’s called it A) which is my main Facebook

        • Zoho Desk Teams App is not loading

          Hi Zoho Desk support. Need an assistance on the Zoho Desk Teams app. Once I click View Ticket, it isn't showing anything. Kindly refer to attached: ZohoDesk Teams App_View Ticket Error.jpg For our Dashboard, we are still experiencing the same issue. Kindly

        • About Meetings (Events module)

          I was working on an automation to cancel appointments in zoho flow , and in our case, we're using the Meetings module (which is called Events in API terms). But while working with it, I'm wondering what information I can display in the image where the

        • Zoho People - Retrieve the Leave Details - get("LeaveCount")

          Hi, Zoho People I need to collect all of an employee's leave requests for the calendar year and check how many half-days they have taken. If I run the script on the query he just modified, I can retrieve the information related to that query and use the

        • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

          Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

        • Which WhatsApp API works seamlessly with Zoho CRM?

          I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:

        • Allow people to sign a zoho form by using esign or scanned signature

          Allow people to sign a zoho form by using esign or scanned signature

        • Button to Reapply Filters on Sheet(s)

          I wrote a macro that I attached to a button to reapply the filters on all my sheets and it says it works, but it doesn't actually do anything. What is wrong with it? Is there another way? Or even make it work for one sheet? Sub UniversalFilterRefresh()

        • Integrate Multiple ZohoBooks organization with zoho projects

          We have successfully connected our Zoho Books with Zoho Projects for synronizing timesheet data. Our Business specialty is, that the staff of the Main company (A) is working on several projects, but the Clients are sometimes contracted and paying to a

        • Zoho OAuth Connector Deprecation and Its Impact on Zoho Desk

          Hello everyone, Zoho believes in continuously refining its integrations to uphold the highest standards of security, reliability, and compliance. As part of this ongoing improvement, the Zoho OAuth default connector will be deprecated for all Zoho services

        • Flexible Partial-Use Coupons (Stored Value Credits)

          Subject: Feature Request: Ability for users to apply partial coupon balances per transaction Problem Statement Currently, our coupons are "one-and-done." If a user has a $50 coupon but only spends $30, they either lose the remaining $20 or are forced

        • Unable to Assign Multiple Categories to a Single Product in Zoho Commerce

          Hello Zoho Commerce Support Team, I am facing an issue while assigning categories to products in Zoho Commerce. I want to assign multiple categories to a single product, but in the Item edit page, the Category field allows selecting only one category

        • How do I add todays date to merge field

          I don't see any selection of todays date when creating a letter. Surely the date option of printing is standard? John

        • Add RTL and Hebrew Support for Candidate Portal (and Other Zoho Recruit Portals)

          Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to set the Candidate Portal to be Right-to-Left (RTL) and in Hebrew, similar to the existing functionality for the Career Site. Currently, when we set the Career Site

        • Uplifted homepage experience

          Hello everyone, Creating your homepage is now much easier, more visual, and more impactful. Until now, your homepage allowed you to display custom views, widgets, analytic components, and Kiosk. With the following improvements, the homepage is now a smarter,

        • Tracking Emails sent through Outlook

          All of our sales team have their Outlook 365 accounts setup with IMAP integration. We're trying to track their email activity that occurs outside the CRM. I can see the email exchanges between the sales people and the clients in the contact module. But

        • Whats that

          Price?

        • The same Contact associated to multiple Companies - Deals

          Hi, I would like to know if there is an option to associate the same contact with multiple companies (two or more) deals, using the same contact details for all. This is because we have contacts who are linked to different companies or branches of the

        • Convert invoice from zoho to xml with all details

          How to convert an Invoice to XML format with all details

        • Portals-Adjust Column Sizes

          I am trying to adjust the column widths in Portals tabs. Columns that don't need to be wide are wide and longer ones are very short. I thought adding more to the digits box in Edit would widen them, but it doesn't. Anyone know how to adjust these?

        • Add link/button to open approved record from approval list and detail views?

          Hi, How do I allow users to click on an approval record and open that submission? For example, userA submits a quotation then userB approves/rejects. They both can see the quotation on "completed task" list & detail views, but there's no way for them

        • record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books

          record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books headermap = Map(); headermap.put("X-ZOHO-Execute-CustomFunction","true"); response_inv = invokeurl [ url :"https://www.zohoapis.com/books/v3/invoices/fromsalesorder?salesorder_id="

        • Prevent editing of a record after getting approved/rejectedr

          Hi, I'd like to block any user from editing a record after it was approved or rejected, how can I do that?

        • Formula Field/Campo de Fórmula

          Hello everyone, I have a purchase requisition form in which each department submits a request, and the request is automatically routed to the person responsible for that department. In this form, I have several fields with the following link names: Quantidade1,

        • Free Webinar: Zoho Sign for Zoho Projects: Automate tasks and approvals with e-signatures

          Hi there! Handling multiple projects at once? Zoho Projects is your solution for automated and streamlined project management, and with the Zoho Sign extension, you can sign, send, and manage digital paperwork directly from your project workspace. Join

        • Formatting Problem | Export to Zoho Sheet View

          When I export data to Zoho Sheet View, ID columns are automatically formatted as scientific notation. Reformatting them to text changes the actual ID values. For example, 6557000335603071 becomes 6557000335603070. I have attached screenshots showing this

        • Introducing Workqueue: your all-in-one view to manage daily work

          Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? Sales

        • Feature Request - The Ability to Link A Customer with a Vendor

          Hi Finance Suite Team, Many businesses buy and sell products from the same companies or individuals. For example, a car sales business may buy a car from a member of the public, and that member of the public may also buy a new car from us. This makes

        • Long table name (sync from Zoho Creator)

          Dears, How can I remove the suffix in parentheses? These tables are synced from Zoho Creator and are treated as system tables, so their names cannot be changed. This issue makes the aggregation formulas look awful.

        • [Free Webinar] Learning Table Series - Streamlining incident management process with Zoho Creator

          Hello everyone, We’re excited to invite you to another edition of the Learning Table Series webinar. As you may already know, we've moved to a purpose-based approach in the Learning Table Series this year. Each session now focuses on how a Zoho Creator

        • Unattended - Silent

          How can I hide the tray icon / pop up window during unattended remote access for silent unattended remote access?

        • Importing into Multiselect Picklist

          Hi, We just completed a trade show and one of the bits of information we collect is tool style. The application supplied by the show set this up as individual questions. For example, if the customer used Thick Turret and Trumpf style but not Thin Turret,

        • Text snippet

          There is a nice feature in Zoho Desk called Text Snippet. It allows you to insert a bit of text anywhere in a reply that you are typing. That would be nice to have that option in Zoho CRM as well when we compose an email. Moderation Update: We agree that

        • Next Page