Link to page

🚧 Internals

Look ma, no Automation.
Only Lookup() s!
Reasons why I built it:
Because my to the Makers Festival is pretty complex, and people may favor simpler things.
(UPD: And because half of other contestants in the Life Hacks category also built goal / habit trackers 😁)
Because I wanted to see if it was possible with the limited set of no code devices Coda provides.
Chat
Message
Is by bot
There are no rows in this table
Replies
Select
Reply
Potential exchange
There are no rows in this table
👆 Initially I simply used a filter to show related answers, but then created a separate table.
The problem with filters is that previously clicked items don't go away unless they lose focus. Doesn’t look nice when rows jump as you try to click a reply button.
Clearing and re-populating a dedicated table looks more cohesive.
The button in this table:
appends selected answer to the chat
saves selected exchange into Last exchange table
presses the "load next exchange" button, where all the magic happens
Last exchange
Bot said
User replied
Bot will say
There are no rows in this table
Load next exchange
👆 This button:
Clears the Replies table
Appends bot's reply from the last exchange into the chat
Looks up potential exchanges (i.e. answers) for last bot message, and using FormulaMap(), iteratively adds answers to the Replies table (yep, that’s possible!)

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.