Properties included in this Notion template:
Unique Invoice ID โ slice(prop("STATUS โ
"), 0, 2) + ((prop("AMOUNT PAID") == 0) ? "000" : "111") + formatDate(prop("DUE ๐ฅ"), "MDYY")
Corrections โ Parent-Child relation
Assigned To โ Name
Due Date โ Date
Job Cost โ Number
Amount Paid โ Number
Status โ
if(date(dateSubtract(prop("DUE ๐ฅ"), 5, "days")) == date(now()), "FOLLOW UP NOW", if(date(now()) >= date(prop("DUE ๐ฅ")), "๐ฉINVOICE NOW", if(now() < prop("DUE ๐ฅ"), "๐โโ๏ธWORKING", if(now() > prop("DUE ๐ฅ") and prop("TOTAL ๐ธ") == prop("AMOUNT PAID"), "โ COMPLETE", ""))))
Rating โ 1-5 Stars
Job Type โ Select
Hourly Rate โ Number
Email โ Worker's email
Complete? โ Checkbox