Attachment Button in Google Sheet

[David Cromer]

I am completely new to scripting in Google Apps (all of my background has been in VBA). I have a sheet where orders are entered. Works great. I would like to add a button and script to do the following:

1. Open a system file picker (like a browse button for uploads) to be
   able to select a file stored on a drive (local or LAN).
2. Copy the file to Google Drive and insert a link to the Google
   Drive file into the select/active cell on the sheet.

While not total unfamiliar with programming, this is the first time I have tried working with Google Sheets. My JavaScript experience does not go much past "Hello World". Any assistance would be greatly appreciated

[Arthur M. Futoryan]

You will have an issue when it comes to the file picker. That goes from a simple idea into an almost full stack project. Because the file picker will need HTML....gets harry. 

Buttons are available via inserting of a drawing and then assigning a script to it when its clicked. This may also not work on all systems *i.e. Apple users*. 

You could however have a loop that runs in your sheet, searching for a particular file in your Google Drive, and then inserting a link to that file in your sheet. 

This all requires a bit of work and thought. 

Let me know if you need any further assistance, unless someone here can offer you something better. 

Arthur M. Futoryan

Progressive Paralegal Service, Inc.

Text or Call: (646) 744-5587

Progressive...@gmail.com

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/cb50bc0f-723a-48e7-b0fd-3c258109de8dn%40googlegroups.com.

[David Cromer]

Thanks. I found a solution.

[Arthur M. Futoryan]

Thats usually what happens :) Good luck 

Arthur M. Futoryan

Progressive Paralegal Service, Inc.

Text or Call: (646) 744-5587

Progressive...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/54a8c5d4-cfcf-403f-905e-1a2e98e0820cn%40googlegroups.com.

[Chad Howard]

Hello David,
Proper etiquette when apart of a community is that if you find a solution yourself you should comment what that solution is.
Others will have the same issue and come across your question, only to see that you found a solution and didn't share it. 
Communities are all about helping others. Can you please post what that solution is for the rest of the community? Thanks David!

Thanks!