我正在使用谷歌應用程式腳本來構建類似表單的東西,可以幫助我實作自動化。
這是構建我的表單的代碼
<div class="w3-container w3-section">
<div class="form-container">
<div class="spacing">
<input class="input-like" placeholder="Enter video link" id="vid" type="text"/>
</div>
<div class="spacing">
<select class="input-like" id="vcategory">
<option value='' disabled selected hidden>Select video category</option>
<option value='Film & Animation'>Film & Animation</option>
<option value='Autos & Vehicles'>Autos & Vehicles</option>
<option value='Pets & Animals'>Pets & Animals</option>
<option value='Sports'>Sports</option>
<option value='Travel & Events'>Travel & Events</option>
<option value='Gaming'>Gaming</option>
<option value='People & Blogs'>People & Blogs</option>
<option value='Comedy'>Comedy</option>
<option value='Entertainment'>Entertainment</option>
<option value='News & Politics'>News & Politics</option>
<option value='How to & Style'>How to & Style</option>
<option value='Education'>Education</option>
<option value='Science & Technology'>Science & Technology</option>
<option value='Nonprofits & Activism'>Nonprofits & Activism</option>
</select>
</div>
</div>
<div class="button-wrapper">
<button class="w3-blue" onclick="addRow()">Add</button>
</div>
<div class="button-wrapper">
<div class="alert alert-success" id="ok" style="display:none">
<h3>Thanks</h3>
<p>This is a new one</p>
</div>
<div class="alert alert-danger" id="warn" style="display:none">
<h3>Duplicate!</h3>
<p>The video ID or Name is already on the list</p>
</div>
<div class="alert alert-warning" id="missing" style="display:none">
<h3>Input missing!</h3>
<p>Viedo link or Category is missing</p>
</div>
</div>
</div>
此時一切正常,我可以在部署時看到我的表單。
我通過將這些值發送到 doGet() 函式的函式獲取表單值,并將它們添加到電子表格單元格中。
我想要做的是,當我運行此腳本時..它會將我發送到包含創建的表單的新選項卡,因為此表單不是作為電子表格中的子選單創建的,它完全在另一個頁面/選項卡中..我想要獲取此頁面/標簽網址,因為我需要在將來訪問它的引數。
我嘗試在檔案中使用google.script.url但它給我發送了空物件,
I tried to use window.location.href, it sent me a weird URL that I couldn't recognize and it's not the one for the created tab.
Any help would be appreciated :)
uj5u.com熱心網友回復:
ScriptApp.getService().getUrl()
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/434113.html
標籤:google-apps-script url google-sheets
上一篇:獲取當前背景關系錯誤格式化函式
