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

reddit SideProject · 原文链接 ↗ · 60 分

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 review. Free generator, no signup, no email: https://www.shubhamgautam.in/tools/form-choice-limiter

五维评分

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 触发器里无人可见，表单会继续接收已满时段的预约。他自称验证过结账能收款、价格正确，却没检查买家付款后收到什么——内容文件其实是空的，说明『发布』不等于『文件已附带』。