2017년 6월 16일 금요일

activate a link from a google spreadsheet


Dear all, i have an spreadsheet some some links there. I want to get these links from my app and activate the link. So i f the link is a link to a google photo album, i want to open this photo album from the app. and the addres must be taken from a google spreadsheet cell.

--
Does the spreadsheet have to remain private?

Could you create another sheet and use importrange() to bring the links across?  (make public and protect the importranges cells)

If so just open up that sheet in a webviewer, and click the links. You could format this sheet to work well in the webviewer

The alternatives will mostly require you to sort out authentication, following the requirements for using Google Sheets as a database (search the forum for this).

Once you have the data (links) in your app, just create a list and listpicker to recall a link and use the activitystarter to open in the on board app

-- 

댓글 없음:

댓글 쓰기