Notion: How To Create Unique IDs For Database Pages/Items

preview_player
Показать описание
------------------------------------------------------------------------------------

Notion: How To Create Unique IDs For Database Pages/Items

Sample Formulas:
- Prefix with text: "SB_ID-" + id()
- Prefix with date:
- A date property is needed, example “Created time”
- formatDate(prop("Created time"), "YYYY_MM_DD-HH_mm-")
- Remove 1st 4 chars: substring(id(), 4)
- Keep 1st 4 chars (range): substring(id(), 0, 4)
- Keep last 4 chars: substring(id(), length(id())-4)
- Remove last 4 chars (range): substring(id(), 0, length(id())-4)

------------------------------------------------------------------------------------

TIMESTAMPS / CHAPTERS

00:00 INTRO
[1] 00:11 Method 1: Using the ID property
[2] 01:03 Method 2: Using the Formula property
[3] 02:34 Text Prefixing
[4] 03:58 Link Prefixing
[5] 04:53 Date Prefixing
[6] 07:41 ID Slicing - Remove 1st 4 characters
[7] 08:56 ID Slicing - Keep 1st 4 characters & Range
[8] 10:28 ID Slicing - Keep last 4 characters
[9] 11:32 ID Slicing - Remove last 4 characters & Range
12:08 OUTRO

------------------------------------------------------------------------------------

INTRO, OUTRO & LOWER THIRDS:
By - Kingsley Chimezie

All rights reserved by Kingsley Chimezie Creations and/or affiliates.

------------------------------------------------------------------------------------

Description last updated: 05/JAN/2024
KCC Video ID: SB-2024-01-05-1

------------------------------------------------------------------------------------
Рекомендации по теме
Комментарии
Автор

That's all good and all, but how do you get the created id to be the master id of the record, instead of the name property?

DrJohnPollard