金山文档轻维表做数据库结合油猴脚本检索

脚本里面新建查询脚本（记录脚本webhook和脚本令牌）

const records = Application.Record.GetRecords({ SheetId: 1 })console.log(records.records)return {data: records.records,}

油猴脚本

// ==UserScript==// @name 油猴辅助器// @namespacehearts// @version版本号// @description描述// @match响应网站// @grantGM_xmlhttpRequest// @connect*// ==/UserScript==(function() {'use strict';//提醒框function notice(txt) {var alertElement = document.createElement('div');alertElement.innerHTML = txt;alertElement.style.position = 'fixed';alertElement.style.top = '50%';alertElement.style.left = '50%';alertElement.style.transform = 'translate(-50%, -50%)';alertElement.style.backgroundColor = '#f9d5e5';alertElement.style.padding = '10px 10px';alertElement.style.borderRadius = '5px';alertElement.style.boxShadow = '0 2px 5px rgba(0, 0, 0, 0.3)';alertElement.style.zIndex = '9999';document.body.appendChild(alertElement);setTimeout(function() {document.body.removeChild(alertElement);}, 1000);}//按钮function createQueryButton(name, hanshu, topOffset, rightOffset) {var button = document.createElement('button');button.innerHTML = name;button.style.position = 'fixed';button.style.top = topOffset + 'px';button.style.right = rightOffset + 'px';button.style.transform = 'translateY(-50%)';button.style.backgroundColor = '#007bff';button.style.color = '#FFF';button.style.border = 'none';button.style.borderRadius = '5px';button.style.padding = '10px 20px';button.style.fontSize = '16px';button.style.fontWeight = 'bold';button.style.boxShadow = '2px 2px 5px rgba(0, 0, 0, 0.2)';button.style.cursor = 'pointer';button.addEventListener('click', hanshu);document.body.appendChild(button);}//金山文档数据库查询（我这个案例是根据姓名查询值）function queryData() {var nameInput = document.querySelector('input[name="fdName"][subject="姓名"]');var name = nameInput.value;if (name.length < 2) {console.log("nameInput为空");notice('请先放卡,点击"读取身份证"后使用此功能，并且确保已经扫码填写了资料')} else {console.log("nameInput不为空，值为：" + name);var data = JSON.stringify({"Context": {"argv": {}}});console.log(data);GM_xmlhttpRequest({method: "POST",url: "这里填写webhook",anonymous:true,headers: {"Content-Type": "application/json","AirScript-Token": "这里填写脚本令牌"},data: data,onload: function(response) {//console.log(response.responseText); //打印所有响应var result = JSON.parse(response.responseText);var data = result.data.result.data;var matchDict = null;for (var i = 0; i < data.length; i++) {var person = data[i];if (person.fields.姓名 === name) {matchDict = person.fields;console.log('找到匹配的姓名');break;}}if (matchDict) {notice(JSON.stringify(matchDict));console.log(matchDict);//取值方法，例如 matchDict.最高学历for (var key in matchDict) { console.log(matchDict[key]);}};window.addEventListener('load', function() {// recover按钮var button = document.createElement('button');button.innerHTML = '修复';button.style.position = 'fixed';button.style.left = '5px';button.style.bottom = '5px';button.style.fontSize = '5px';// 修改字体大小button.style.color = 'lightgray';// 修改字体颜色button.onclick = function() {sessionStorage.removeItem('lastCancelledTime');console.log('已清除记录');}document.body.appendChild(button);//2小时封禁var lastCancelledTime = sessionStorage.getItem('lastCancelledTime');if (lastCancelledTime) {console.log(lastCancelledTime);var currentTime = new Date().getTime();var elapsedMilliseconds = currentTime - lastCancelledTime;var elapsedHours = Math.floor(elapsedMilliseconds / (1000 * 60 * 60));console.log(elapsedHours);if (elapsedHours < 2) {return;}}var confirmLoad = confirm("\n是否需要加载辅助脚本？");if (confirmLoad) {notice("辅助脚本已经开启");createQueryButton("检索数据库", queryData, 105, 10);} else {sessionStorage.setItem('lastCancelledTime', new Date().getTime());}});})();