工具連結 | Tool Link: https://script.google.com/macros/s/AKfycbwhxuWAOrCc36cLnAmr4VnEvgue0cXF1R-cOCii2uwOUViptrsrLk5osbf5i_AKnbRy/exec
這是一個整合預填網址產生和欄位 ID 查詢的工具。當您需要透過程式自動填寫或處理 Google 表單時,這個工具可以幫助您:
快速獲取所需的 entry ID、欄位標題與必填狀態資訊
直接產生預填答案的網址
⚠️ 本工具有以下限制:
無法讀取需要登入的 Google 表單(例如:含有檔案上傳功能的表單)
無法預先填寫日期、時間欄位
🔍 快速查詢表單欄位的名稱、欄位 entry ID(例如:entry.1234567890)
✏️ 自動產生預填答案的網址
📋 點擊即可複製欄位資訊或預填網址
✨ 清楚顯示必填欄位標記
🎯 簡潔直觀的操作介面
💡 複製成功即時提示
開啟工具網頁
貼上 Google 表單網址(例如:https://docs.google.com/forms/d/e/...)
點擊「查詢欄位資訊」按鈕
點擊任何欄位ID即可複製
在查詢結果中的「使用者答案」欄位輸入測試答案
系統會自動生成包含預填答案的網址
使用「複製預填網址」按鈕複製完整網址
可直接使用該網址測試預填效果
Google Apps Script 後端
HTML5 + CSS3 前端介面
JavaScript 互動功能
Google Forms API 整合
A comprehensive tool that combines Google Forms pre-fill URL generation and field ID lookup capabilities. This tool helps developers and users to:
Quickly retrieve entry IDs, field titles, and required status information
Generate pre-filled URLs for Google Forms
⚠️ Please note the following limitations:
Cannot process Google Forms that require login (e.g., forms with file upload)
Cannot pre-fill date and time fields
🔍 Quick lookup of form field names and entry IDs (e.g., entry.1234567890)
✏️ Automatic generation of pre-filled URLs
📋 One-click copy of field information and pre-filled URLs
✨ Clear indication of required fields
🎯 Intuitive user interface
💡 Instant copy confirmation
Open the tool webpage
Paste your Google Form URL (e.g., https://docs.google.com/forms/d/e/...)
Click "Search Fields"
Click any field ID to copy
Enter test answers in the "User Answer" column of the query results
The system will automatically generate a URL with prefilled answers
Use the "Copy Prefilled URL" button to copy the complete URL
Test the prefill effect directly using the generated URL
Google Apps Script Backend
HTML5 + CSS3 Frontend
JavaScript Interactions
Google Forms API Integration
... [中文完整內容]
├── code.gs # Google Apps Script 後端程式碼
└── web.html # 前端介面
建立新專案
複製 Code.gs 內容到專案["指令碼"]中
按+建立"HTML"將 web.html 檔案並複製內容
"部署"為網頁應用程式
設定適當的存取權限
作者:blues32767
GitHub:blues32767
版本:1.0.0
更新日期:Taiwan 2025/02/19
MIT License
初始版本發布
實現基本查詢功能
加入複製提示功能
優化使用者介面
歡迎提交 Issue 或 Pull Request 來改善這個工具!
Fork 這個專案
建立您的特性分支 (git checkout -b feature/AmazingFeature)
提交您的更改 (git commit -m 'Add some AmazingFeature')
推送到分支 (git push origin feature/AmazingFeature)
開啟一個 Pull Request
... [English full content]
Open Google Apps Script
Create a new project
Copy Code.gs content into the project
Create web.html file and copy the content
Deploy as a web application
Configure appropriate access permissions
Author: blues32767
GitHub: blues32767
Version: 1.0.0
Last Updated: Taiwan 2025/02/19
MIT License
Initial release
Implemented basic query functionality
Added copy notification feature
Enhanced user interface
Contributions are welcome! Feel free to submit Issues or Pull Requests to improve this tool.
Fork the project
Create your feature branch (git checkout -b feature/AmazingFeature)
Commit your changes (git commit -m 'Add some AmazingFeature')
Push to the branch (git push origin feature/AmazingFeature)
Open a Pull Request
MIT License
Developer | 開發者:blues32767
GitHub:blues32767