An simple workflow example of how to use Google Forms/Sheets as a quasi-database for LawHelpInteractive's hosted Hotdocs, as a replacement for an overlay answer file. Why? Because LHI does not support overlay answer files. Bonus: this makes it easy for anyone across the state to submit additions to our database.
Here's the basic workflow:
- A user submits a new database entry (attorney or court name) with a Google Form.
- A Google Apps Script converts the resulting Google Sheet into a HotDocs computation that adds each row as a REPEAT value.
- The computation is copied and pasted into the Interview computation.
I used a HotDocs text template to convert the existing overlay answer file into a CSV file that could be imported into Google Sheets.
This repository has the Google Apps Script file and the HTML "sidebar". It also has a sample of the CSV text template I used to get data out of the existing overlay answer file.
http://nonprofittechy.com/2017/06/07/google-forms-workflow-to-replace-hotdocs-overlay-answer-files/