πŸ•˜

How Concat Works

Master Tag
Tips & Tricks
Created
Apr 14, 2020 05:54 PM
Usage
formateDate
Format
Concat
dateBetween
Web Tags
Formula
Database
Alternatives
Cover
↙️
The following is a quick explanation of the concat function in Notion. If you want to join properties or complicated calculations with text properties, this function will be very useful inside your Notion formula.
πŸ”₯
The Scenario β†’ Below are a few examples of how concat can be used. The first is a scenario where years, months, weeks, days, hours, minutes, seconds and milliseconds are calculated from the birth date of three individuals. At the end of the table, I provide a clean way to present multiple property formulas into one concat expression.
Concat Scenario
Name
Years from birth
Months from birth
Weeks from birth
Days from birth
Hours from birth
Minutes from birth
Seconds from birth
Milliseconds from birth
Concat
πŸ”₯
The Scenario β†’ This scenario showcases a shipping center that wants to create a specific and consistent message layout to send to its customers upon ordering their products. They want the following structure to appear: "Your shipment has been fulfilled for the following items: [INSERT ITEMS]. Estimated delivery is [INSERT DAY OF WEEK], [DATE] between 7am and 4pm.
Concat Scenario 2
Name
Item(s)
Shipped
Estimated Arrival
Message
Pillow
Shirt
Case
Apr 1, 2020
Shirt
Shorts
Apr 9, 2020
Case
Stationary
Apr 7, 2020
Pin
Shirt
Apr 11, 2020
Unique Currency