■Overview
This is a flow that determines holidays and business days, and only advances the flow bot on business days.
It is a convenient flow for cases where you want to execute regular communications only on business days.
■Preparation (You can copy and use the following sheets. *Please make sure to copy them as they are view-only*)
・Prepare a spreadsheet that extracts the determination results of holidays and business days using functions.
・Prepare a sheet to accumulate holidays (including company-specific ones).
■Creation Method
① Select a schedule trigger from the triggers, check the weekdays excluding weekends, and set it to activate at the specified time.
② Press the + mark under the trigger, select the spreadsheet from "Connect with Apps," and perform the following settings, then test and save.
・Action: Retrieve values
・Spreadsheet ID: Select the spreadsheet ID of the prepared spreadsheet from the options.
・Sheet Name: Select the target sheet from the options. (In this case, select "Example 7_Retrieval")
・Range: Enter the range of cells you want to retrieve, like A2. (In this case, enter A2 as the cell where the determination result is reflected)
・Direction: Column direction
③ Press the + mark, select the branching operation, perform the following settings, and save.
・Operation: Operation from step ②
・Output: Retrieved value
・Condition: Equal to value
・Value: 0
④ Press the + mark in the other direction, select Slack from the operation to connect with apps, perform the following settings, and save.
・Action: Send a message to the channel
・Channel ID to post: Select the channel ID to post from the options.
・Message Content: Set the desired post content. *If there is a value obtained in advance, you can embed it as an output.
* For dynamically changing values using output, please refer here. https://intercom.help/yoom/ja/articles/8223528