📡 Idea Radar 每天 8:00 / 18:00 推送 · 18:00 生成精选
reddit · SideProject · 60 分 ← 返回列表

My checkout was verified, took payment, and delivered an empty file. Published does not mean the file is attached.

Short post, because the useful part is the mistake. The thing. Google Forms has no way to cap how many people can pick each option — time slots, equipment sign-out, shift rotas, potluck dishes. The usual answer is a marketplace add-on, which means granting a third party access to your form and every response in it. For a school or an HR team that is usually where it stops. So I wrote an Apps Script you paste into your own form's script editor. Nothing leaves your account, no add-on, no re

五维评分

付费意愿
55
需求真实度
60
个人可落地
92
竞争空间
28
新鲜度
45

AI 分析

痛点:Google Forms 原生无法限制每个选项的报名人数(时间段、设备借出、排班、聚餐菜品),而市面插件要求第三方访问表单和全部回复,学校/HR 因此不敢用。

目标用户:用 Google Forms 做报名/排班/预约的学校老师、HR 与行政团队、小型活动组织者。

证据:Google Forms has no way to cap how many people can pick each option — time slots, equipment sign-out, shift rotas, potluck dishes. The usual answer is a marketplace add-on, which means granting a third party access to your form and every response in it. For a school or an HR team that is usually where it stops. ... there is a $9 version on the same page that does several questions at once, checkboxes and dropdowns, and auto-closes the form.

变现:一次性买断 $9 的 Apps Script 授权(免费单问题版引流),或按月 $5–15 的托管/自动更新订阅,后续可加多语言与 Quickstart 模板包。

MVP:两周内做一个纯前端 Script 生成器:用户粘贴表单问题标题(或填表单 ID + 问题 ID),生成一段可粘贴进自己 Apps Script 编辑器的代码,实现单/多问题选项上限、已满选项自动重命名为『已满』、达到上限自动关闭表单;免费版限 1 个问题,付费 $9 解锁多问题、复选框/下拉、自动关闭。数据完全留在用户账号内,无需 OAuth 第三方授权。

竞品:Form Limiter、Choice Eliminator 2、Form Ranger、Google Workspace Marketplace 各类表单名额插件

摘要:作者用 Apps Script 做了一个 Google Forms 选项名额限制器,免费生成器+同页 $9 付费版,卖点是数据不出用户账号、不需要装第三方插件。技术坑是选项过滤为空后 setChoiceValues([]) 会抛错且发生在 onFormSubmit 触发器里无人可见,表单会继续接收已满时段的预约。他自称验证过结账能收款、价格正确,却没检查买家付款后收到什么——内容文件其实是空的,说明『发布』不等于『文件已附带』。