Check out our prototype [here] (http://codeforamerica.github.io/abq-financial-wellness-wizard/)
This is a prototype application created by the City of Albuquerque Code for America Fellows. It helps people understand their own financial wellness by giving them an evaluation and using that data to generate a report and recommendations as to what things to do to help you grow financially.
- Log in to Formkeep
- Create a new bucket for the data
- Pay for the bucket ($7 a month) (will only except 4 request to demo)
- Paste in this 'Thank You Page' url
http://codeforamerica.github.io/abq-financial-wellness-wizard/thanks.html
- Make a copy of the unique Formkeep id, this is needed for the url
- In the google spreadsheet, add a new tab.
- Name it the name of the business, replacing any spaces with a dash. For example, if the business is 'Two Hours' the tab should be named 'two-hours'. Remove any special characters like '&'.
- Copy over the table headers from another tab.
- Login to Zapier
- Create a new action that connects FormKeep to Google Sheets
- If Formkeep gets a submission create a row in google sheets
- Select FormKeep bucket
- Select Google Sheet (can select tab)
- Before the next step we'll need to submit the form
- Now go to the survey
/abq-financial-wellness-wizard/?formkeep=
at the end of the url add the Formkeep ID that you made a copy of above - Fill out the entire survey for testing and submit it
- Go back to Formkeep and finish your setup
- Go back to Zapier
- Now match each field to columns in the google sheet (this task is done one by one)
- Submit and create the Zapier action
- Go to your Google Sheet tab and remove the row that says "Added by Zapier, ensuring we can access this spreadsheet. Feel free to delete it after you are all set up!" If that line doesn't exist then the Zapier hook was not created correctly and your want to go back to those steps. Also, make sure to remove the row so you don't have an empty row of data.
- Test your form by submitting it at this url
/abq-financial-wellness-wizard/?formkeep=
+ your Formkeep ID - Check the google spreadsheet to make sure your data came in
- Submit form a couple of times to create example data
- Demo the report by going to this url
/abq-financial-wellness-wizard/manage/?b=
add the name of your tab in Google Sheet. If the tab name is 'two-hours' then the url would be/abq-financial-wellness-wizard/?b=two-hours
Prerequisites: Ruby is installed.
- Install dependencies:
bundle
- Run Jekyll:
jekyll serve --watch
For further documentation on using Jekyll you can go to Jekyllrb.com.
For more information you can contact us at [email protected]