AirTable vs Notion

Image

Moderators: Admiral of the Fleet, Vice Admiral

User avatar
Ztranier
Posts: 1771
Joined: Tue Oct 23, 2018 7:14 pm
Location: Düsseldorf/ Germoney
Contact:
=EBS= Ztranier’s avatar
Loading…

Re: AirTable vs Notion

Post by Ztranier » Fri Feb 05, 2021 10:46 am

I am Brian, and so is my wife
"If in doubt, ....flat out" Collin McRae

User avatar
warlock359205
Posts: 499
Joined: Tue Oct 23, 2018 7:12 pm
Location: portsmouth uk

Re: AirTable vs Notion

Post by warlock359205 » Sat Feb 06, 2021 8:14 am

Ztranier wrote:
Fri Feb 05, 2021 10:46 am
I am Brian, and so is my wife
NO I am Brian, and so is my wife, these gender neutral persons are imposters
Image

User avatar
0verzeal0us
Posts: 2006
Joined: Tue Oct 23, 2018 8:29 pm
Location: Hertfordshire
Contact:

Re: AirTable vs Notion

Post by 0verzeal0us » Sun Mar 07, 2021 10:48 am

Just an update regarding this (if anyone is interested) - I've chosen Notion as it creates relational databases easily without having to create formulas like you would in Excel (I have a lot of data, albeit useless to anyone else). It's got dark mode BUT it doesn't have MFA natively. It's also free for personal use (although I'm seriously considering buying Personal Pro.
I am neurodiverse and communication can be difficult for me. If you would like to know more about neurodiversity, please click here.
Image

User avatar
0verzeal0us
Posts: 2006
Joined: Tue Oct 23, 2018 8:29 pm
Location: Hertfordshire
Contact:

Re: AirTable vs Notion

Post by 0verzeal0us » Sat Mar 20, 2021 9:26 pm

If anyone is interested and/or cares, these is my new Workspace.
Image
I am neurodiverse and communication can be difficult for me. If you would like to know more about neurodiversity, please click here.
Image

Spawnsy
Posts: 1585
Joined: Tue Oct 23, 2018 7:30 pm
Location: Leicestershire
Contact:

Re: AirTable vs Notion

Post by Spawnsy » Sun Mar 21, 2021 9:13 pm

From the perspective of someone as disorganised as myself that appears impressively well organised, to the point of being intimidating! May have been a touch more subtle/relevant to have taken the screenshot on the gaming page though. 😉
Facebook Ebs Spawnsy
Got the SQUEE?
Pick up your suffering and bear it. (J. B. Peterson)
Stay hard. (D. Goggins)
Easy now.

User avatar
0verzeal0us
Posts: 2006
Joined: Tue Oct 23, 2018 8:29 pm
Location: Hertfordshire
Contact:

Re: AirTable vs Notion

Post by 0verzeal0us » Mon Mar 22, 2021 9:11 am

That's one of the joys of being Autistic (for me at least). EVERYTHING needs to be in it's place to help me make sense of it all. I've tried not to have it but that just increases my anxiety more!
Here's a view the gaming page (it's less interesting)
Image
and more specifically, a bit of one of the gaming databases!
Image
I am neurodiverse and communication can be difficult for me. If you would like to know more about neurodiversity, please click here.
Image

User avatar
0verzeal0us
Posts: 2006
Joined: Tue Oct 23, 2018 8:29 pm
Location: Hertfordshire
Contact:

Re: AirTable vs Notion

Post by 0verzeal0us » Thu Dec 30, 2021 2:22 pm

So I've been using Notion for about 10 months now and all I am going to say is that I LOVE IT. Definitely worth it. If anyone else needs a LifeOS, I'll be glad to help.

If you're a geek and love formulas (@darkdeamon I'm looking at you), I have made a formula which is a whopping 20.5 thousand characters long!

Code: Select all

if(slice(if(not end(prop("Date")) == start(prop("Date")), if(formatDate(end(prop("Date")), "dddd DD MMMM YYYY") == formatDate(start(prop("Date")), "dddd DD MMMM YYYY"), if(and(dateBetween(end(prop("Date")), start(prop("Date")), "minutes") < 120, dateBetween(end(prop("Date")), start(prop("Date")), "minutes") > 0), concat(formatDate(start(prop("Date")), "h:mm"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ⇾ ", formatDate(end(prop("Date")), "h:00"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")")))), ""), format(concat(if(not empty(toNumber(formatDate(start(prop("Date")), "HH:mm"))), concat(formatDate(start(prop("Date")), "h"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY")), " ⇾ ", formatDate(end(prop("Date")), "dddd"), " ", if(or(toNumber(formatDate(end(prop("Date")), "D")) == 21, toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(formatDate(end(prop("Date")), "D")) == 22, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 23, concat(formatDate(end(prop("Date")), "D"), "rd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 24, concat(formatDate(end(prop("Date")), "D"), "th"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 1, concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 2, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 3, concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th")))))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), format(concat(if(not empty(toNumber(formatDate(end(prop("Date")), "HH:mm"))), concat(formatDate(end(prop("Date")), "HH"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), "", concat(formatDate(end(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(end(prop("Date")), "D")) == 1, toNumber(formatDate(end(prop("Date")), "D")) == 21), toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 2, toNumber(formatDate(end(prop("Date")), "D")) == 22), concat(formatDate(end(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(end(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 3, toNumber(formatDate(end(prop("Date")), "D")) == 23), concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th"))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY")), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), 0, 1) == " ", slice(if(not end(prop("Date")) == start(prop("Date")), if(formatDate(end(prop("Date")), "dddd DD MMMM YYYY") == formatDate(start(prop("Date")), "dddd DD MMMM YYYY"), if(and(dateBetween(end(prop("Date")), start(prop("Date")), "minutes") < 120, dateBetween(end(prop("Date")), start(prop("Date")), "minutes") > 0), concat(formatDate(start(prop("Date")), "h:mm"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ⇾ ", formatDate(end(prop("Date")), "h:00"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")")))), ""), format(concat(if(not empty(toNumber(formatDate(start(prop("Date")), "HH:mm"))), concat(formatDate(start(prop("Date")), "h"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY")), " ⇾ ", formatDate(end(prop("Date")), "dddd"), " ", if(or(toNumber(formatDate(end(prop("Date")), "D")) == 21, toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(formatDate(end(prop("Date")), "D")) == 22, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 23, concat(formatDate(end(prop("Date")), "D"), "rd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 24, concat(formatDate(end(prop("Date")), "D"), "th"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 1, concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 2, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 3, concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th")))))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), format(concat(if(not empty(toNumber(formatDate(end(prop("Date")), "HH:mm"))), concat(formatDate(end(prop("Date")), "HH"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), "", concat(formatDate(end(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(end(prop("Date")), "D")) == 1, toNumber(formatDate(end(prop("Date")), "D")) == 21), toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 2, toNumber(formatDate(end(prop("Date")), "D")) == 22), concat(formatDate(end(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(end(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 3, toNumber(formatDate(end(prop("Date")), "D")) == 23), concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th"))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY")), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), 1, length(if(not end(prop("Date")) == start(prop("Date")), if(formatDate(end(prop("Date")), "dddd DD MMMM YYYY") == formatDate(start(prop("Date")), "dddd DD MMMM YYYY"), if(and(dateBetween(end(prop("Date")), start(prop("Date")), "minutes") < 120, dateBetween(end(prop("Date")), start(prop("Date")), "minutes") > 0), concat(formatDate(start(prop("Date")), "h:mm"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ⇾ ", formatDate(end(prop("Date")), "h:00"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")")))), ""), format(concat(if(not empty(toNumber(formatDate(start(prop("Date")), "HH:mm"))), concat(formatDate(start(prop("Date")), "h"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY")), " ⇾ ", formatDate(end(prop("Date")), "dddd"), " ", if(or(toNumber(formatDate(end(prop("Date")), "D")) == 21, toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(formatDate(end(prop("Date")), "D")) == 22, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 23, concat(formatDate(end(prop("Date")), "D"), "rd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 24, concat(formatDate(end(prop("Date")), "D"), "th"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 1, concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 2, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 3, concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th")))))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), format(concat(if(not empty(toNumber(formatDate(end(prop("Date")), "HH:mm"))), concat(formatDate(end(prop("Date")), "HH"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), "", concat(formatDate(end(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(end(prop("Date")), "D")) == 1, toNumber(formatDate(end(prop("Date")), "D")) == 21), toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 2, toNumber(formatDate(end(prop("Date")), "D")) == 22), concat(formatDate(end(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(end(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 3, toNumber(formatDate(end(prop("Date")), "D")) == 23), concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th"))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY")), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))))), if(not end(prop("Date")) == start(prop("Date")), if(formatDate(end(prop("Date")), "dddd DD MMMM YYYY") == formatDate(start(prop("Date")), "dddd DD MMMM YYYY"), if(and(dateBetween(end(prop("Date")), start(prop("Date")), "minutes") < 120, dateBetween(end(prop("Date")), start(prop("Date")), "minutes") > 0), concat(formatDate(start(prop("Date")), "h:mm"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ⇾ ", formatDate(end(prop("Date")), "h:00"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm"), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")")))), ""), format(concat(if(not empty(toNumber(formatDate(start(prop("Date")), "HH:mm"))), concat(formatDate(start(prop("Date")), "h"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(start(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), " ", concat(formatDate(start(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(start(prop("Date")), "D")) == 1, toNumber(formatDate(start(prop("Date")), "D")) == 21), toNumber(formatDate(start(prop("Date")), "D")) == 31), concat(formatDate(start(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 2, toNumber(formatDate(start(prop("Date")), "D")) == 22), concat(formatDate(start(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(start(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(start(prop("Date")), "D")) == 3, toNumber(formatDate(start(prop("Date")), "D")) == 23), concat(formatDate(start(prop("Date")), "D"), "rd"), concat(formatDate(start(prop("Date")), "D"), "th"))))), " ", formatDate(start(prop("Date")), "MMMM"), " '", formatDate(start(prop("Date")), "YY")), " ⇾ ", formatDate(end(prop("Date")), "dddd"), " ", if(or(toNumber(formatDate(end(prop("Date")), "D")) == 21, toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(formatDate(end(prop("Date")), "D")) == 22, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 23, concat(formatDate(end(prop("Date")), "D"), "rd"), if(toNumber(formatDate(end(prop("Date")), "D")) == 24, concat(formatDate(end(prop("Date")), "D"), "th"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 1, concat(formatDate(end(prop("Date")), "D"), "st"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 2, concat(formatDate(end(prop("Date")), "D"), "nd"), if(toNumber(slice(formatDate(end(prop("Date")), "D"), 1)) == 3, concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th")))))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY"), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))), format(concat(if(not empty(toNumber(formatDate(end(prop("Date")), "HH:mm"))), concat(formatDate(end(prop("Date")), "HH"), if(and(not empty(prop("Date")), multiply(toNumber(formatDate(end(prop("Date")), "HH:mm")), 60) < 720), "am", "pm")), ""), "", concat(formatDate(end(prop("Date")), "dddd"), " ", if(or(or(toNumber(formatDate(end(prop("Date")), "D")) == 1, toNumber(formatDate(end(prop("Date")), "D")) == 21), toNumber(formatDate(end(prop("Date")), "D")) == 31), concat(formatDate(end(prop("Date")), "D"), "st"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 2, toNumber(formatDate(end(prop("Date")), "D")) == 22), concat(formatDate(end(prop("Date")), "D"), "nd"), if(and(toNumber(slice(formatDate(prop("Date"), "D"), 1)) == 3, toNumber(slice(formatDate(prop("Date"), "D"), 0, 1)) == 1), concat(formatDate(end(prop("Date")), "D"), "th"), if(or(toNumber(formatDate(end(prop("Date")), "D")) == 3, toNumber(formatDate(end(prop("Date")), "D")) == 23), concat(formatDate(end(prop("Date")), "D"), "rd"), concat(formatDate(end(prop("Date")), "D"), "th"))))), " ", formatDate(end(prop("Date")), "MMMM"), " '", formatDate(end(prop("Date")), "YY")), if(prop("Type") == "Saturday", "", concat(" (", prop("Type"), ")"))))))
I am neurodiverse and communication can be difficult for me. If you would like to know more about neurodiversity, please click here.
Image

darkdeamon
Posts: 346
Joined: Tue Oct 23, 2018 6:16 pm

Re: AirTable vs Notion

Post by darkdeamon » Thu Dec 30, 2021 2:44 pm

Not got a formula that big but I do have an excel spreadsheet for managing our backups that builds an array table from 10 different data sources.
It lists 250+ backup policies in a rolling 5 year window and shows the id, status and location of the backup tapes used each month per backup policy.
When you hit the update button, it takes around 10 mins for all the formula to run and the CPU usage is around 90%
Lording it over the plebs and putting my hacks on your PC by many devious methods

User avatar
0verzeal0us
Posts: 2006
Joined: Tue Oct 23, 2018 8:29 pm
Location: Hertfordshire
Contact:

Re: AirTable vs Notion

Post by 0verzeal0us » Thu Dec 30, 2021 9:51 pm

I manage a Discord server for the IT and Theatre people at work and I’ve started using Automate.io to manage roles based upon a Notion spreadsheet. It’s made me think about developing my own API. Someone on one of the other Discord servers I’m a member of (which is for various tools including Notion) has created an API to pull data about a movie based solely on its title. https://nwatchlist.notion.site/nwatchli ... 98d2147ae3
I am neurodiverse and communication can be difficult for me. If you would like to know more about neurodiversity, please click here.
Image

Post Reply