[HN Gopher] Show HN: I made a form builder that saves data in Go...
___________________________________________________________________
Show HN: I made a form builder that saves data in Google Sheets
Author : a_band
Score : 71 points
Date : 2021-11-11 15:03 UTC (7 hours ago)
(HTM) web link (sheetmonkey.io)
(TXT) w3m dump (sheetmonkey.io)
| eatonphil wrote:
| That is what Google Forms does, but it looks like you've added
| the benefit of more custom styling which Google Forms is not very
| flexible about.
|
| I run my blog's subscription system off of Google Forms -> Google
| Sheets. It's free and very simple but I definitely don't like how
| ugly Google Forms is.
| a_band wrote:
| You got it 100%. Google Forms is great until you have to
| integrate it with a website. This is meant to work just like
| Google Forms but with the ability to be embedded right into any
| layout.
| eatonphil wrote:
| Nice, I liked the blog post you've got too [0]. I forgot my
| other gripe with Google Forms is that there's probably lost
| conversions to subscribers because it leaves my own site.
|
| I keep meaning to follow one of these guides to embedding a
| form and posting to Google Sheets but the Google Sheets API
| is confusing and everyone's guide for doing this has a
| different method.
|
| I just need to spend the time on it...
|
| [0] https://sheetmonkey.io/articles/how-to-submit-a-html-
| form-to...
| a_band wrote:
| Thanks! Glad you found that post helpful. Yeah, the Google
| APIs are very powerful but _not_ user-friendly at all for
| developers looking for a quick way to save data into a
| sheet.
| Biologist123 wrote:
| This is great. Two questions:
|
| 1. Could I have "code" in subsequent sheets to manipulate data
| coming in through the form and output results.
|
| 2. Could you embed questions in an android app? If you could I
| would immediately have a lot of use for this.
|
| Thanks and well done!
| a_band wrote:
| Thanks!
|
| 1. I'm not sure I 100% understand what you're asking here but
| it seems that what you're looking for is very possible by
| triggering workflows off of sheets.
| https://solutions.appsheet.com/workspace or https://zapier.com
| are a couple of great ways to do this.
|
| 2. If you can embed HTML in an Android then you should be able
| to embed one of the forms. I haven't done it before. Let me
| know if you try it and how it goes.
| livatlantis wrote:
| Although I'm not in the target audience (because Google), I think
| some of my less nerdy friends would find this extremely useful.
| I've had quite a few ask me for an easy way to create a quick
| form to gather responses when organising an event or to run a
| little survey. Thanks for creating it, bookmarked. Will
| recommend.
| a_band wrote:
| Thank you! Hope they find it useful. :-)
| advisedwang wrote:
| Neat project. Are you worried that SurveyMonkey will attack you
| for having a similar name to their trademark?
| spiderice wrote:
| This was my first thought as well
| qrybam wrote:
| Same here.
| a_band wrote:
| Yikes. Hadn't considered that. Hopefully not.
| NonEUCitizen wrote:
| I'd change the name now while it's still early, so people
| won't have to go hunting for the new name later.
| I_complete_me wrote:
| If it's any consolation I did not have this thought.
| petepete wrote:
| Really unfortunate, love the artwork!
| mritchie712 wrote:
| This is the last thing you should be worried about
| usaphp wrote:
| Videos on your homepage don't work on iPhone, show black screen
| a_band wrote:
| Ah dang. Thanks for the heads up. I'll take a look.
|
| EDIT: I was missing the `playsinline` attribute. Fixed now.
| hardtke wrote:
| 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.
| irskep wrote:
| You could probably construct a decent Asana workflow around
| this using forms, custom fields, and automation rules, but it's
| not free.
| kroltan wrote:
| With enough courage and either a lot of formulas or a bit of
| scripting, you can do simple queries just fine in Google
| Sheets.
| a_band wrote:
| 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...
___________________________________________________________________
(page generated 2021-11-11 23:01 UTC)