Warm tip: This article is reproduced from serverfault.com, please click
alert google-apps-script google-sheets user-interface

GAS create alert in server-side validation PropertiesService.getScriptProperties() Spreadsheet ID

发布于 2020-11-30 16:44:57

I have a spreadsheet which launches a modal dialog form to get information. Some client side validation for required fields but also server side validation: does the input data already exist. Logger.log has not worked for 4 days now so I am using alert. In the server side validation someone wrote you cannot use getActive as you are not in the spreadsheet but in the dialog form. So:

function onLoad() {
  
  const ui = SpreadsheetApp.getUi();
  const ssId = SpreadsheetApp.getActive().getId();
  PropertiesService.getScriptProperties().setProperty('ssId', ssId);

and in the server side validation - this does not allow me to get to UI in order to send an alert

function addMbrCode(myAddForm)  {
  const ssId = PropertiesService.getScriptProperties().getProperty('ssId');
  var ssQ = SpreadsheetApp.openById("[ssId]");
  var ss = SpreadsheetApp.setActiveSpreadsheet(ssQ);
  
  ss.alert("Beginning addMbrCode" );

The spreadsheet UI can't be accessed in this context. "open" does not mean "show in browser", it means "open for read and write"... – @Serge insas

So is it possible to issue an alert in this situation?

Questioner
aNewb
Viewed
0
分享
aNewb 2020-12-01 22:00:18

Partial answer - I wrote my 'logging' to a Google doc on MyDrive.

/**
 *  this code is run from the javascript in the html dialog
 */
function addMbrCode(myAddForm)  {
//  cannot access UI to issue alerts on Spreadsheet in this context
  var formattedDate = Utilities.formatDate(new Date(), "GMT", "MM-dd-yyyy HH:mm:ss");
  var myLog = DocumentApp.create('addMbrCode ' +  formattedDate );
  var logId = myLog.getId();
  var body = DocumentApp.openById(logId).getBody();
  var paragraph;
  console.log("Beginning addMbrCode" );
  paragraph = body.appendParagraph('Beginning addMbrCode.');
. . .
      paragraph = body.appendParagraph('end addMbrCode returning: ' + retCd );
      myLog.saveAndClose();
      return retCd;
      
    }

However running this server side validation from the javascript in the browser appears to not allow meaningful interaction with my spreadsheet despite @Serge insas comment that "it means "open for read and write". This is probably a new question. I will post separately.

热门帖子

1
我发布了一个自认为很厉害的 Java 参数校验组件，它几乎可以满足所有的参数校验场景，请各位 V 友发表一些看法
2
求推荐好用的记账 app
3
肝了五一假期： iOS 平台的假期调休闹钟「休息日」，限时免费，没有内购
4
家用上行还有什么好玩的使用方法
5
​MES管理系统的生产模块与ERP有何差异
6
一个运维应该用什么方式去请教后台管理订单的同事关于他们部门的事情
7
尝试收个 iPhone 13 Pro Max
8
程序员 15w 接了一个公寓系统+小程序
9
Gigapixel AI: 简单易用的图片放大器
10
Face to Many: AI肖像滤镜 (可以转换成20多种风格，PS2风、黏土风...)

热门github

1
A multi-platform library for OpenGL, OpenGL ES, Vulkan, window and input
2
Dev tool that writes scalable apps from scratch while the developer oversees the implementation
3
shadcn/ui, but for Svelte. ✨
4
The Python Risk Identification Tool for generative AI (PyRIT) is an open access automation framework to empower security professionals and machine learning engineers to proactively find risks in their generative AI systems.
5
Performance-portable, length-agnostic SIMD with runtime dispatch
6
ZK Credo
7
OpenCodeInterpreter: Integrating Code Generation with Execution and Refinement
8
Joplin - the secure note taking and to-do app with synchronisation capabilities for Windows, macOS, Linux, Android and iOS.
9
Mamba is a new state space model architecture showing promising performance on information-dense data such as language modeling, where previous subquadratic models fall short of Transformers. It is based on the line of progress on structured state space models, with an efficient hardware-aware design and implementation in the spirit of FlashAttention.
10
This repository contains System Design resources which are useful while preparing for interviews and learning Distributed Systems
11
Curso para aprender el lenguaje de programación Python desde cero y para principiantes. 75 clases, 37 horas en vídeo, código, proyectos y grupo de chat. Fundamentos, frontend, backend, testing, IA...
12
🎓 Path to a free self-taught education in Computer Science!
13
1️⃣🐝🏎️ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated with Java
14
A collective list of free APIs
15
📚 Freely available programming books