从AppMaker数据库生成电子邮件列表 [英] Generating an email list from AppMaker Database
问题描述
我试图弄清楚如何获取涉及电子邮件列的数据库信息,创建包含所有电子邮件的数组,然后使用按钮"功能填充电子邮件页面的收件人:"部分. /p>
感谢您的帮助.在这方面非常新颖,并向我指出从何处获取信息将是很棒的.谢谢
我建议您运行服务器脚本,该脚本将查询包含电子邮件的数据源.该脚本将如下所示:
function getEmails(){
var query = app.models.<yourmodel>.newQuery();
var results = query.run();
var allEmails = [];
if(results.length > 0){
for(var i = 0; i < results.length; i++){
var uniqueEmail = results[i].<emailfieldname>;
allEmails.push(uniqueEmail);
}
}
return allEmails.join();
}
然后将脚本添加到按钮小部件"onclick"事件中,该脚本将运行服务器脚本并处理返回的数据.与此类似:
function poulateToField(response){
<widget path>.text/value = response;
}
google.script.run.withSuccessHandler(poulateToField).getEmails();
上面的 widget路径将是收件人:"小部件的路径,该小部件可以是文本框,文本区域等.在我的情况下,我使用了文本区域和路径是" widget.parent.descendants.TextArea1.value "
我希望这会有所帮助.如果您还有其他问题,请告诉我! :)
P.D.请不要忘记阅读 官方文档 更好更详细的解释.
I am trying to figure out how I can get database information involving the email column, make an array with all of the emails and then use the "button" feature to populate the "To:" part of an email page.
Any help is appreciated. Very new at this and pointing me on where to get the info would be great. Thanks
I recommend you to run a server script that would query the datasource that has the emails. The script will look something like this:
function getEmails(){
var query = app.models.<yourmodel>.newQuery();
var results = query.run();
var allEmails = [];
if(results.length > 0){
for(var i = 0; i < results.length; i++){
var uniqueEmail = results[i].<emailfieldname>;
allEmails.push(uniqueEmail);
}
}
return allEmails.join();
}
Then add a script to the button widget "onclick" event that will run the server script and manipulate the returned data. Something similar to this:
function poulateToField(response){
<widget path>.text/value = response;
}
google.script.run.withSuccessHandler(poulateToField).getEmails();
The above widget path would be the path to the "To:" widget, which can be a text box, text area, etc. In my case, I used a text area and the path was this "widget.parent.descendants.TextArea1.value"
I hope this helps. If you have more questions, just let me know! :)
P.D. Please don't forget to review the official documentation for a better and more detailed explanation.
这篇关于从AppMaker数据库生成电子邮件列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!