I am wondering if I can implement the following use case with Couch.
We are a sports club, and twice per year our members can register for matches of their choice, and per match for certain performance types. Right now, we are distributing an Excel to all members, showing all matches on the lines and performances in the columns, the members have to tick those and send it back. It's a lot of work to collect everything (especially, collect in a timely fashion). We cannot use Google Forms for this because it violates with our privacy policy (no member data stored outside of the EU). And we're too small to go for a Europe-based paid forms solution. So we have to implement a solution of our own.
I would like to use Couch, in a combination of users, csv importer, and data bound forms. Another solution is to implement LimeSurvey on our side and send them the list as a kind of survey. I already experimented with that.
But my preference is a solution that is integrated into our website.
I tried some things, but cannot figure out the proper solution in Couch. This is what I have in my mind:
- Have a CSV file with all matches on the lines, performances in the columns.
- Present this file to logged in users, in a form.
- Users will see the matches listed one after the other on the lines
- Behind each match, on the line, they will see the performance as checkboxes: they simply check the boxes of the performances for which they want to register.
- When they click 'submit', it's either saved in the database with their name tied to it, or it's saved back into a copy of the csv with their name appended to it. The first solution seems most elegant and has my preference.
Is this feasible in Couch? I would like to stay as close as possible to standard Couch, and not have to code all in PHP from scratch.
All help and tips/tricks appreciated !
We are a sports club, and twice per year our members can register for matches of their choice, and per match for certain performance types. Right now, we are distributing an Excel to all members, showing all matches on the lines and performances in the columns, the members have to tick those and send it back. It's a lot of work to collect everything (especially, collect in a timely fashion). We cannot use Google Forms for this because it violates with our privacy policy (no member data stored outside of the EU). And we're too small to go for a Europe-based paid forms solution. So we have to implement a solution of our own.
I would like to use Couch, in a combination of users, csv importer, and data bound forms. Another solution is to implement LimeSurvey on our side and send them the list as a kind of survey. I already experimented with that.
But my preference is a solution that is integrated into our website.
I tried some things, but cannot figure out the proper solution in Couch. This is what I have in my mind:
- Have a CSV file with all matches on the lines, performances in the columns.
- Present this file to logged in users, in a form.
- Users will see the matches listed one after the other on the lines
- Behind each match, on the line, they will see the performance as checkboxes: they simply check the boxes of the performances for which they want to register.
- When they click 'submit', it's either saved in the database with their name tied to it, or it's saved back into a copy of the csv with their name appended to it. The first solution seems most elegant and has my preference.
Is this feasible in Couch? I would like to stay as close as possible to standard Couch, and not have to code all in PHP from scratch.
All help and tips/tricks appreciated !