Metabase Forms Summary Automation

This project aims to make a summary of a Decidim Form, based on models available on this project and the Metabase_API_python wrapper

Requirements

• Poetry
• Having setup the answers' request using the SQL request available on the decidim_cards repo
• Fill the credentials.py with :
  • Metabase credentials
  • ID of the base request
  • ID of the Decidim form
  • ID of the collection in which you want to have the created charts and dashboard

Setup

1. Clone repository
2. Run poetry install
3. Run poetry run make_summary

TODO

• Connect to Metabase
• Retrieve all forms with provided model ID
• Retrieve specific form information
• Retrieve all questions of specified form with their types and IDs
• Create card that gathers answers of the specified question
  • Short answers
  • Long answers
  • Single option
  • Multiple option
  • Sorting (cumulative points)
  • Matrix simple
  • Matrix multiple
  • Files

Improvements

• Retrieve automatically the models which contains the forms information
• Resize box of report dashboardcards to fill all width and a pre-determined height.
• Interactive creation that displays the question title and type to give choice of visualization
• Test cover : red, green, blue
• Give possibility to hide/show labels
• Pin created dashboard
• Message the consultant concerned by the form summary
• Order answers by number of occurences