Notion Scripts for Personal CRM

assoc_list.csv

generate_formula.py

ASP = 'prop("Associations")'

def days_gt(days):
  dgt = 'dateBetween(now(), prop("Last Contacted"), "days") > ' + days
  res = 'if(%s, "😓", "💯")' %  (dgt)
  return res

f = open('assoc_list.csv', 'r')
ls = f.readlines()
x = []

for l in ls:
    a, b = l.split(',')
    a = a.strip()
    b = b.strip()
    x.append((a, b))

nl = 0
res = []
for y in x:
    a, b = y
    res.append('if(%s == "%s", ' % (ASP, a))
    res.append(days_gt(b))
    res.append(', ')
    nl += 1

res.append('"Invalid Association!"')

for i in range(nl):
  res.append(')')

print(''.join(res))