Image by Peggy Dyar from Pixabay.
We've already seen how to use the Config sheet in the Installation Guide. Now let's learn how to configure the Lessons sheet.
TSChatWise can post two types of lesson messages to Google Chat Rooms:
- Simple Messages - plain text messages with simple formatting options.
- Card Messages - more complex user interface card messages.
👉 For more information on message types and formatting see Google Chat Message Types and Formatting below.
As show above, each row of the Lesson sheet represents a lesson to be posted to one or more Google Chat Rooms.
Each row contains seven data fields representing each lesson to be posted. These fields are outlined below.
1. Posted
A checkbox automatically checked by TSChatWise when a lesson is posted to any Google Chat Room.
👉 Add a checkbox for each new lesson. Use the spreadsheet Insert > Checkbox menu to add a new checkbox.
👉 Make sure the checkbox is unchecked before posting the lesson.
👉 Uncheck box to reuse a lesson post.
👉 Ensure that there are no extraneous checkboxes in this column or TSChatWise will try to post empty lessons.
2. Posted On
Date stamp automatically added by TSChatWise when a lesson is posted to any Google Chat Room.
👉 Do not modify this field.
3. Post as Card Message
Indicates whether the lesson is to be posted as a Simple Message or Card Message.
👉 Add a checkbox for each new lesson. Use the spreadsheet Insert > Checkbox menu to add a new checkbox.
👉 Check the box to send as a card message.
👉 Make sure there is an checkbox in this column before posting the lesson.
4. Lesson Name
Name of lesson to be posted with lesson.
👉 This is a required field.
5. Lesson Description
Lesson content to be posted.
👉 This is a required field.
👉 Can contain additional formatting based upon type of message: Simple Message or Card Message.
6. Lesson Link
Link to additional lesson content to be included with the posted lesson.
👉 This is a optional field.
👉 Link will be added to the end of the message body for Simple Messages or as a clickable button link at the end of Card Messages.
7. Lesson Image
Link to a public accessible image to be included with Card Messages ONLY.
👉 This is a optional field.
Posting a Simple Message lesson as shown above will produce this output in a Google Chat room.
Once the lessons have been configured on the Lessons tab, TSChatWise can be configured to run by setting up an Apps Script time-based trigger.
To schedule a time-based trigger perform the following steps:
Open the Google Apps Script Editor
- Open the TSChatWise template (copied in the Installation step)
- From the Sheet menu select Tools > Script editor
Create a New Apps Script Time Based Trigger
- In the Apps Script editor, click the clock icon on the left side
- In the dashboard, click the + Add Trigger button on the bottom right
- Under Choose which function to run be sure to select postLessons
- Under Select event source select Time-driven
- Under Select type of time based trigger select the desired interval
- Set any other desired time based trigger options
- Click the Save button to save the configuration
TSChatWise is now configured to run on the timed interval.
Once TSChatWise has posted all the lessons to the configured Chat Rooms it will automatically unschedule the time-based trigger and send an email to the TSChatWise Google Sheet collaborators configured on the TSChatWise Config sheet.
To reuse the lessons, uncheck checkboxes in the first column of the Lessons sheet and reconfigure a new Apps Script trigger following the steps above.
TSChatWise can post two types of lesson messages to Google Chat Rooms:
- Simple Messages - plain text messages with simple formatting options.
- Card Messages - more complex user interface card messages.
Simple Messages are messages which appear inline as if typed by a user.
👉 Simple messages can contain symbols used to create special formatting.
👉 For more on simple message formatting options see the documentation.
Following is an example of a simple message sent to a Google Chat Room.
Following is an example of a simple message with an alternate link sent to a Google Chat Room.
Following is an example of a simple message with code sent to a Google Chat Room.
Card Messages are Google Chat messages which contain a more complex user interface in the form of cards.
👉 Card messages can contain special formatting.
👉 For more on card message formatting options see the documentation.
Following is an example of a card message sent to a Google Chat Room.
Following is an example of a card message with an emoji sent to a Google Chat Room.
