News for hackers. Stuff that matters.
Re:Show HN: I made a form builder that saves data in Google ... by hardtke on Thursday November 11, 2021 @01:55PM (#29191592)
I've been asked to maintain the contact info for a non profit club. Something like this is almost what I need, but I would also need to be able to edit existing entries as well as to run some simple queries (who has not paid their dues?). Does any such cloud based open source software exist? CRM systems are overkill, and there are some downloadable tools, but nothing cloud based AFAIK.
Re:Show HN: I made a form builder that saves data in Google ... by Aakshu on Friday November 12, 2021 @01:57AM (#29196946)
You should give DronaHQ a spin for this. I have used it to build a simple frontend app, connect my sales lead maintained on a google sheet and streamline some activities (assigning leads, edit information,send email, track payment/subscription) They offer ready connectors so you can plug it to your data source of choice. I am pretty satisfied with the tool (https://www.dronahq.com)
Re:Show HN: I made a form builder that saves data in Google ... by a_band on Thursday November 11, 2021 @04:09PM (#29193201)
Yeah, I actually do something similar with some of my projects. I'm able to get good results directly querying sheets: https://www.benlcollins.com/spreadsheets/google-sheets-query...

Pivot tables have a bit of a learning curve but you can also use them to dynamically pull data out of sheets: https://support.google.com/docs/answer/1272900?hl=en&co=GENI...

Re:Show HN: I made a form builder that saves data in Google ... by mgbmtl on Thursday November 11, 2021 @08:38PM (#29195420)
CiviCRM is made for nonprofits. It can be overkill for simple requirements, but you can turn off most of the clutter. There is a low-cost SaaS hosting for $10/month (https://civicrm.org/spark). Full disclosure: I am a dev & hosting provider.
Re:Show HN: I made a form builder that saves data in Google ... by kroltan on Thursday November 11, 2021 @02:57PM (#29192386)
With enough courage and either a lot of formulas or a bit of scripting, you can do simple queries just fine in Google Sheets.
Re:Show HN: I made a form builder that saves data in Google ... by foxbee on Friday November 12, 2021 @03:53AM (#29197422)
I would go with Budibase - it's free, has multi-step forms, you can use an external db, or use Budibase's built-in database. You can also automate notifications when a new contact is added.
Re:Show HN: I made a form builder that saves data in Google ... by RedShift1 on Friday November 12, 2021 @01:11AM (#29196744)
Perhaps appsmith.com or budibase.com is what you're looking for
Re:Show HN: I made a form builder that saves data in Google ... by irskep on Thursday November 11, 2021 @02:04PM (#29191709)
You could probably construct a decent Asana workflow around this using forms, custom fields, and automation rules, but it's not free.
Re:Show HN: I made a form builder that saves data in Google ... by windjammer on Friday November 12, 2021 @01:53AM (#29196929)
Here's a cloud based CRM that might fit the bill. Not open source but certainly doesn't cost the earth.

beaconcrm.org

Re:Show HN: I made a form builder that saves data in Google ... by conductr on Thursday November 11, 2021 @08:02PM (#29195211)
Maybe give Airtable a go. I’d think something with an interface would be better than embedded