Skip to content

Concatenate Workout Routine

Let's get this workout started!
What is it?
Concatenate lets you put combine multiple values to create custom labels or make sense of your data.



Exercise 1
Create a heading for the notes from today’s date.
Your answer
Hint
Put the text portion of your heading in quotation marks. Don’t forget a space.
Reveal answer
Note from
12/7/2021

Exercise 2
Use Concatenate to create a byline for each article. For example “My great blog by Maria Marquis”

Your answer
Doc Title
Author
Concatenate
There are no rows in this table
Hint
If you type = in the column, your formula will automatically apply to every row.
Reveal answer

Doc Title
Author
Concatenate
There are no rows in this table

Exercise 3
Create a custom message welcoming the user to your doc and using the adjective from the Adjective select list.

Pick an adjective
awesome

Your answer
Hint
Right click on the dropdown menu to see its name.
Reveal answer
Weclome to the doc System Writer, you're awesome!


Exercise 4
Create a blog tagging system that combines the row number with the category and date.

Your answer

ID
Doc title
Author
Date published
Category
2
MM
Maria Marquis
5/21/2020
Launch
3
TH
Thomas Hils
5/13/2020
Product
5
AC
Al Chen
4/15/2020
Al's column
6
NP
Nathan Penner
3/26/2020
Launch
There are no rows in this table
Hint
You’ll use the RowID formula component
Reveal answer



ID
Doc title
Author
Date published
Category
1
1-
5/27/2020
-Al's column
AC
Al Chen
5/26/2020
Al's column
2
2-
5/22/2020
-Launch
MM
Maria Marquis
5/21/2020
Launch
3
3-
5/14/2020
-Product
TH
Thomas Hils
5/13/2020
Product
4
4-
4/29/2020
-Al's column
AC
Al Chen
4/28/2020
Al's column
5
5-
4/16/2020
-Al's column
AC
Al Chen
4/15/2020
Al's column
6
6-
3/27/2020
-Launch
NP
Nathan Penner
3/26/2020
Launch
There are no rows in this table

Exercise 5
Customize the button label so that it includes the person’s name.

Add a task for

Your answer
Hint
You’ll be concatenating the text using quotation marks and the User() formula. Right click the button to update the content.
Reveal answer
Add a task for System Writer
@Maria Marquis

Exercise 6
Write a dynamic message to send via the Gmail pack. Add the formula in the "Message” column below. Then, try pushing the button to send yourself an email!

There’s no one correct answer here - come up with your own creative message to send!

Your answer:

Message
Notify
Doc title
Author
Date published
Category
2
Notify
MM
Maria Marquis
5/21/2020
Launch
3
Notify
TH
Thomas Hils
5/13/2020
Product
5
Notify
AC
Al Chen
4/15/2020
Al's column
6
Notify
NP
Nathan Penner
3/26/2020
Launch
There are no rows in this table
Hint 1
This seems tricky, but you got this! You’ll want to combine a few different column values with some text to make a dynamic message, just like you did in Exercise 2.
Hint 2
Here’s a sample message: “Good news -
Author
‘s doc called
Doc title
was just published! You can find it in the
Category
category on the blog.”
Reveal answer
Push buttons

Answer
Notify
Doc title
Author
Date published
Category
1
Good news - Al Chen's doc called
was just published! You can find it in the Al's column category on the blog.
Notify
AC
Al Chen
5/26/2020
Al's column
2
Good news - Maria Marquis's doc called
was just published! You can find it in the Launch category on the blog.
Notify
MM
Maria Marquis
5/21/2020
Launch
3
Good news - Thomas Hils's doc called
was just published! You can find it in the Product category on the blog.
Notify
TH
Thomas Hils
5/13/2020
Product
4
Good news - Al Chen's doc called
was just published! You can find it in the Al's column category on the blog.
Notify
AC
Al Chen
4/28/2020
Al's column
5
Good news - Al Chen's doc called
was just published! You can find it in the Al's column category on the blog.
Notify
AC
Al Chen
4/15/2020
Al's column
6
Good news - Nathan Penner's doc called
was just published! You can find it in the Launch category on the blog.
Notify
NP
Nathan Penner
3/26/2020
Launch
There are no rows in this table


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.