I saw Grist on HN yesterday and thought it would be a good exercise to port my family financial database over as a trial run.
I just ran into a road block with
I have two tables: transactions and categories. I’m trying to automatically populate
transactions.payee with the first
payees record where
payees.Pattern. In python code, it’d look like this:
for payee in payees: payee.Pattern in $Description and return payee or continue
The formula I used was
Payees.lookupOne(Description=CONTAINS($Payee.Pattern)) but looks like it’s not quite what the grist-core expects.
What am I doing wrong?
Thanks for creating grist. I like what I see. Can’t wait to port a few other internal apps over.