filmov
tv
Notion: How To Create Unique IDs For Database Pages/Items
Показать описание
------------------------------------------------------------------------------------
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
------------------------------------------------------------------------------------
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
------------------------------------------------------------------------------------
Комментарии