由于Notion默认的公式中并没有UrlEncode的函数,好在Notion附件上传后,文件名称的特殊符号、中文字符会自动被清除,所以我们只需要使用replaceAll函数将: / ! 这几个特殊符号替换为URL encoding就完成了。
不排除这个公式存在错误,比如一些未知且Notion支持的特殊字符,如果存在错误,可修改下公式或者留言告诉我
replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(prop("Files"), ":", "%3A"), "/", "%2F"), "!", "%21"), ",", "\\n\\n"), "https%3A%2F%2F", "<https://www.notion.so/signed/https%3A%2F%2F>")
一次无意测试,发现 formula 属性 支持 id() 函数 输出 item(数据库的page)id,我们来进一步优化公式,免除手动输入page link 的繁琐:
replaceAll(concat(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(prop("1. Files"), ":", "%3A"), "/", "%2F"), "!", "%21"), "https%3A%2F%2F", "<https://www.notion.so/signed/https%3A%2F%2F>"), " ", ""), "?table=block&id=", slice(id(), 0, 8), "-", slice(id(), 8, 12), "-", slice(id(), 12, 16), "-", slice(id(), 16, 20), "-", slice(id(), 20, 32)), ",", concat("?table=block&id=", slice(id(), 0, 8), "-", slice(id(), 8, 12), "-", slice(id(), 12, 16), "-", slice(id(), 16, 20), "-", slice(id(), 20, 32), "\\n"))
<aside> 💡 使用:
1. Files 列上传附件。2. Name 列输入附件标题。3. URL 列中”单元格“,再按 ctlr + c 复制内容(不是点击打开输入公式,可拖动鼠标多选单元格)Files URL 的URL,可用于不对外分享链接,假如你有在自己私人页面中重复使用相同附件、图片、视频等的需求。
</aside><https://www.notion.so/signed/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F2c57f001-2f02-4d1f-a3ed-bd5705b761f7%2Fnotion-logo_(2).zip?table=block&id=3f17e755-ea05-4af1-bf99-e21d03809f81>
<https://www.notion.so/signed/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F41ca637d-1139-431e-bd6b-b712c85674d2%2Ftemplates.png?table=block&id=75622b09-39d0-4bcc-9b8f-fff2ec2af292>
<https://www.notion.so/signed/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F3c401a26-c19a-4fed-8f7a-2658a66384d5%2F1_Team_wiki.mp4?table=block&id=7596b163-e3fc-4dc4-abb6-8bb46d5b023a>
<https://www.notion.so/signed/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fb4c6e3eb-24cc-4d20-83de-8fc8f2a0c0b1%2F2_Projects__tasks.mp4?table=block&id=7596b163-e3fc-4dc4-abb6-8bb46d5b023a>
<https://www.notion.so/signed/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F4605e0b0-f84b-45b5-a14f-aebd977dc0c2%2F3_Notes__docs.mp4?table=block&id=7596b163-e3fc-4dc4-abb6-8bb46d5b023a>