search

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
163 stars 47 forks source link

New feature: automatic hyperlink to cell/row from event's description #71

Open crysman opened 4 years ago

crysman commented 4 years ago

First of all, thanks for this extension! We would like to use it, but one step is required - and I believe it should be doable quite easily - unfortunately, I do not understand Google API code, so I cannot make a PR myself :(

Proposed new feature is an automatically added hyperlink to Google Calendar event's description leading to that particular cell in Google Spreadsheet.

It would look like this: image

You are obviously using API to target particular cells anyways, so all the functionality is already there.

Could be a new option in GCalendarSync -> Options.

Why we need such a thing?

Well, the spreadsheet contains a fistful of other columns which we do not want to synchronize and/or include in event's description. Would be cool if people could open the particular GSheet row task just by clicking onto a link in their calendar event - very useful shortcut.

Do you see this realistic?

Thanks a lot #McZ

crysman commented 4 years ago

I've made a workaround meanwhile: =ArrayFormula( CONCATENATE( G3:K3 & CHAR(10);$C$1;"&range=";address(ROW();column();4) ) ) (C1 contains sheet's URL)

davepar commented 4 years ago

Thanks for the suggestion and comments on the other bugs. This does sound useful. I'll take a look at doing it, but not sure when I'll get to it. Hopefully in the next few weeks.

crysman commented 4 years ago

OK, thanks a lot, this one is a bonus feature, unlike the one day off fatal error :/ - If I understand corectly ("next few weeks"), you gonna have no time to fix that error soon? Or you meant this new feature only and will have time to fix that serious error? I would appreciate realistic answer, we got some due dates and I would potentially have to find other solution... Thank you!

brianfigg commented 2 years ago

Can this script be run from google sheets while on an iPhone?

Sent from my iPhone

On Sep 2, 2020, at 11:37 PM, Martin crysman Zahradník @.***> wrote:

 OK, thanks a lot, this one is a bonus feature, unlike the one day off fatal error :/ - If I understand corectly ("next few weeks"), you gonna have no time to fix that error soon? Or you meant this new feature only and will have time to fix that serious error? I would appreciate realistic answer, we got some due dates and I would potentially have to find other solution... Thank you!

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.