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

[crysman]

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:

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]

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]

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]

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]

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.