Google App maker multiple files drive upload

Question

We are going to use drive picker as attachement field, so whenever an user uploads a file or multiples files to drive we have to get the links of the files and show it to the user in the form.

Answer 1

Here is a code sample with following assumptions:

• you have Master and Attachment models with One-to-Many relation
• datasource of the current page is set to record from the Master model
• datasource is in Auto Save mode

// onDocumentSelect Drive Picker's event handler
var create = widget.root.datasource.relations.Attachments.modes.create;

result.docs.forEach(function(doc) {
  create.item.Url = doc.url;
  create.createItem();
});

This code will make N requests to the server, where N is number of attachments. You can use google.script.run to make a single call and handle creating new attachment records and relations on server, but then you'll need manually reload relation to show changes to user.