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

COPY TEMPLATE