Entries

ID

(empty(prop("Created by")) ? "NA" : "") + replaceAll(prop("Created by"), "[a-z-. ]", "") + formatDate(prop("Created at"), "DMHm") + format(length(prop("Name")))

(empty(prop("Created by")) ? "NA"

If Created by is empty, display NA

: "")

Otherwise show nothing.

+ replaceAll(prop("Created by"), "[a-z-. ]", "")

Replace all the lowercase alphabet characters, dashes, periods and spaces in Created by with nothing, which will return the initials.

+ formatDate(prop("Created at"), "DMHm")

Format the Created by date in the DMHm format.

+ format(length(prop("Name")))

Get the character count of the Name property.

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>