🅿️

Generating URLS

Master Tag
Tips & Tricks
Created
Nov 25, 2020 07:47 PM
How It Works
Usage
replaceAll
formateDate
Web Tags
Formula
Alternatives
Cover
💬
My conditions for a URL: + www.redgregory.com/notion/ + date published in the format of "YYYY/MM/DD" + convert title to lowercase (hidden property), replace spaces with hyphens, and remove special characters
🔰
How to copy Address: click cell, then click away. If cell is highlighted blue, copy+paste
Generating URLS
Blog Name
Date Published
Address
Formulas
"www.redgregory.com/notion/" + formatDate(prop("Date Published"), "YYYY/MM/DD/") + replaceAll(prop("Convert to Lowercase"), " ", "-")
replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(prop("Blog Name"), "A", "a"), "B", "b"), "C", "c"), "D", "d"), "E", "e"), "F", "f"), "G", "g"), "H", "h"), "I", "i"), "J", "j"), "K", "k"), "L", "l"), "M", "m"), "N", "n"), "O", "o"), "P", "p"), "Q", "q"), "R", "r"), "S", "s"), "T", "t"), "U", "u"), "V", "v"), "W", "w"), "X", "x"), "Y", "y"), "Z", "z"), "[:&#$!']", "")