🚧 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. 👆 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 👆 This button:
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!)