Status Update
Comments
gk...@google.com <gk...@google.com> #2
clearNote()
getNote()
getNotes()
setNote(note)
setNotes(notes)
gk...@google.com <gk...@google.com> #3
ko...@gmail.com <ko...@gmail.com>
ps...@gmail.com <ps...@gmail.com> #5
sw...@gmail.com <sw...@gmail.com> #7
da...@cloudreach.com <da...@cloudreach.com> #8
ap...@gmail.com <ap...@gmail.com> #9
ap...@gmail.com <ap...@gmail.com> #10
range.getComments()
Thanks
dr...@insight-online.dk <dr...@insight-online.dk> #11
ko...@gmail.com <ko...@gmail.com> #12
j....@opsolder.nl <j....@opsolder.nl> #13
var comments = Drive.Comments.list(fileId);
var anchor = comments.items[0].anchor;
var anchorjson = JSON.parse(anchor);
It gives me a workbook-range, uid and a number string. Is there a way to decrypt that number-string value to a readable format like A1Notation? Love to hear!
ab...@gmail.com <ab...@gmail.com> #15
[Deleted User] <[Deleted User]> #16
I arrived at the same point of #13.
[Deleted User] <[Deleted User]> #17
Thanks
bh...@gmail.com <bh...@gmail.com> #18
It gives me a workbook-range, uid and a number string. Is there a way to decrypt that number-string value to a readable format like A1Notation?
[Deleted User] <[Deleted User]> #19
[Deleted User] <[Deleted User]> #20
ed...@gmail.com <ed...@gmail.com> #21
lo...@gmail.com <lo...@gmail.com> #22
sh...@gmail.com <sh...@gmail.com> #23
er...@nisd.net <er...@nisd.net> #24
[Deleted User] <[Deleted User]> #25
*ETIENNE RIVEST*
*Intégrateur logiciel - Formateur*
T 418 956 5922 / 514 266 9774
<
<
​- 99 ue Arago Est, Québec, QC G1K 3T6
- 2901-1, place Ville Marie, Montréal, QC H3B 0E9
- 140-235, rue Heriot, Drummondville, QC J2C 6X6
Le mar. 15 mai 2018, à 10 h 48, <buganizer-system@google.com> a écrit :
[Deleted User] <[Deleted User]> #26
pa...@vincere.io <pa...@vincere.io> #27
[Deleted User] <[Deleted User]> #28
da...@gmail.com <da...@gmail.com> #29
jo...@gmail.com <jo...@gmail.com> #30
st...@gmail.com <st...@gmail.com> #31
[Deleted User] <[Deleted User]> #32
dm...@gmail.com <dm...@gmail.com> #33
[Deleted User] <[Deleted User]> #34
no...@noaa.gov <no...@noaa.gov> #35
11...@gmail.com <11...@gmail.com> #36
le...@gmail.com <le...@gmail.com> #37
em...@schd.org <em...@schd.org> #38
oh...@gmail.com <oh...@gmail.com> #39
mo...@gmail.com <mo...@gmail.com> #40
[Deleted User] <[Deleted User]> #41
Is it possible to get a word on this? Please?
ek...@google.com <ek...@google.com> #42
[Deleted User] <[Deleted User]> #43
Ideally, they would provide that feedback as a comment on a cell, assign it to the data feedback agent, and the feedback agent would pull the feedback and the context for it directly from the sheet.
[Deleted User] <[Deleted User]> #44
[Deleted User] <[Deleted User]> #45
[Deleted User] <[Deleted User]> #46
ga...@gmail.com <ga...@gmail.com> #47
li...@gmail.com <li...@gmail.com> #48
hr...@gmail.com <hr...@gmail.com> #49
ro...@gmail.com <ro...@gmail.com> #50
fe...@gmail.com <fe...@gmail.com> #51
ja...@wvsupply.com <ja...@wvsupply.com> #52
hd...@gmail.com <hd...@gmail.com> #53
ma...@gmail.com <ma...@gmail.com> #54
le...@randallreilly.com <le...@randallreilly.com> #55
er...@lexington1.net <er...@lexington1.net> #56
Following the project management tips from google:
Created a sheet with list of tasks
Shared sheet with users with Can Comment access
Users can comment but I cannot collect those comments without the getcomments() feature.
[Deleted User] <[Deleted User]> #57
de...@lafurniturestore.com <de...@lafurniturestore.com> #58
bo...@gmail.com <bo...@gmail.com> #59
ek...@google.com <ek...@google.com> #60
I'd also note that Apps Script continues to evolve, and you can follow what's launched in the release notes:
ma...@gmail.com <ma...@gmail.com> #61
You can already tag a cell in a Sheet to show that it has a comment, so there must be a Cell <-> Comment link.
Just expose that?
You're freaking Google... There is no way that this is that difficult.
ne...@gmail.com <ne...@gmail.com> #62
sa...@gmail.com <sa...@gmail.com> #63
an...@gmail.com <an...@gmail.com> #64
ke...@capitalone.com <ke...@capitalone.com> #65
lo...@gmail.com <lo...@gmail.com> #66
ek...@google.com <ek...@google.com> #67
sl...@gmail.com <sl...@gmail.com> #68
of...@swimkidsutah.com <of...@swimkidsutah.com> #69
[Deleted User] <[Deleted User]> #70
My co-workers use comments to communicate with our clients and we've reached a point where we will be re-structuring our sheets as we open/close patient accounts (medical billing). If I clear everything and reset the sheet, the comments for a certain cell will not follow with everything else. I was hoping for a .getComments [][] two dimensional array like everything else is. The two dimensional array concept was genius and has opened the door for some very advanced and elegant data manipulation within the sheets. Can we mimic that concept for cell comments? It seems as if a certain aspect of comments are fundamentally different than notes or any other type of formatting. Understandable if this isn't a top priority and it isn't something easy to do. I face those exact same two issues every day when my team and clients need me to develop things. I've seen that you guys have acknowledged this and have an understanding to some degree of what you need to do to make this happen. We appreciate that and we will wait patiently :). Let us know if there is anything we can do to help!
Warm Regards,
Matt
vi...@gmail.com <vi...@gmail.com> #71
we...@gmail.com <we...@gmail.com> #72
ma...@gmail.com <ma...@gmail.com> #73
All kidding aside, I think the general use case is worth considering. Many businesses run on spreadsheets, all the time. They use a lot of them, and they use them in workflows. Comments on the cell are metadata, and metadata is always an important feature in those sorts of use cases.
Please consider moving this upward in your roadmap. Thank you for what you all have done so far.
bl...@gmail.com <bl...@gmail.com> #74
I need reading of comments to process legacy data
su...@gmail.com <su...@gmail.com> #75
ja...@mymedbot.lu <ja...@mymedbot.lu> #76
lu...@gmail.com <lu...@gmail.com> #77
Just in case some people need more information, it would be useful to be able to at least get access to comments. In my case I don't actually need write access.
va...@gmail.com <va...@gmail.com> #78
va...@gmail.com <va...@gmail.com> #79
so we are stuck now in this.
[Deleted User] <[Deleted User]> #80
[Deleted User] <[Deleted User]> #81
ba...@bigassfans.com <ba...@bigassfans.com> #82
Yes, the first user could create that comment, but that requires training the entire user base.
lu...@gmail.com <lu...@gmail.com> #83
it...@gmail.com <it...@gmail.com> #84
he...@gmail.com <he...@gmail.com> #85
[Deleted User] <[Deleted User]> #86
ah...@valeo.com <ah...@valeo.com> #87
It might be helpful to all the users that would like to automatically manage action lists to be able to add comments to a defined range.
In addition, within the new feature when writing a comment from script editor, being able to assign it to a user might also be helpful.
Thanks.
PS: hope Google will assign some resources to answer this 7 years old request !!!
mt...@gmail.com <mt...@gmail.com> #88
sd...@unionerenolavinosamoggia.bo.it <sd...@unionerenolavinosamoggia.bo.it> #89
le...@port.ac.uk <le...@port.ac.uk> #90
Comments would automatically notify the developer of our updates/review.
da...@gmail.com <da...@gmail.com> #91
je...@sistemascc.com.mx <je...@sistemascc.com.mx> #92
jo...@gmail.com <jo...@gmail.com> #93
we...@stanford.edu <we...@stanford.edu> #94
bm...@ext.uber.com <bm...@ext.uber.com> #95
+1 for this feature. It's important
[Deleted User] <[Deleted User]> #96
+1 The lack of this feature just broke our business idea and we have to use Amazon SageMaker, which is way more cumbersome than doing it in gSuite. But when gSuite just cannot do it, it's too bad and we have to either build our own tool from the ground up or repurpose "bigger machine".
an...@chillingmoscow.ru <an...@chillingmoscow.ru> #97
[Deleted User] <[Deleted User]> #98
de...@reliablegaragedoor.com <de...@reliablegaragedoor.com> #99
be...@wilsonart.com <be...@wilsonart.com> #100
mi...@gmail.com <mi...@gmail.com> #101
jo...@gmail.com <jo...@gmail.com> #102
ia...@gsuitetest.fb.com <ia...@gsuitetest.fb.com> #103
ni...@gmail.com <ni...@gmail.com> #104
[Deleted User] <[Deleted User]> #105
an...@gmail.com <an...@gmail.com> #106
jb...@gmail.com <jb...@gmail.com> #107
[Deleted User] <[Deleted User]> #108
jo...@woolworths.com.au <jo...@woolworths.com.au> #109
Only 2 more years and this issue can celebrate its 10th birthday.
ju...@hiviewsolutions.com <ju...@hiviewsolutions.com> #110
ge...@booking.com <ge...@booking.com> #111
yo...@gmail.com <yo...@gmail.com> #112
[Deleted User] <[Deleted User]> #113
ma...@gmail.com <ma...@gmail.com> #114
ba...@gmail.com <ba...@gmail.com> #115
Use case: 1389 comments across 15 sheets were related to a particular department or project. It's now been decided that this department/project will not continue. How could the 1389 comments related to that department/project be identified and deleted in bulk from the spreadsheet(s)/database?
Use case: George entered 471 comments related to his part of a project. But his attempts at solutions just keep ballooning with no resolution in sight. George is replaced with Sarah, who has a new direction for the project. We'd like Sarah to be able to take over that segment free of George's comments, so that she can start from scratch. How can we identify and remove all of George's comments without going through 15 sheets, cell by cell, finding and removing them so Sarah can start fresh?
Use case: George is angry that he's been removed from his position (and the company). He doesn't have access to delete sheets. But he DOES have the ability to leave comments. A couple days before his last day, he peppers spreadsheets with hundreds of "anonymous" comments of all sorts, most involving vulgar language. How could we identify all comments made between a two-day window and delete them in bulk?
Use case: A good project was started three years ago, but the team at that time didn't have the ability to see it through. It was left by the wayside until six months ago when a couple new members came on and began making real headway. But the old comments are a nuisance, unrelated (and unhelpful) to the new staff. How could we identify and delete in bulk all comments made prior to X date while leaving those made in the last six months?
jo...@agorasource.com <jo...@agorasource.com> #116
an...@gmail.com <an...@gmail.com> #117
[Deleted User] <[Deleted User]> #118
Appscript has been written, but copying of comments couldn't be done, and we have lots of valuable comments to keep track of for every page.
[Deleted User] <[Deleted User]> #119
wa...@gmail.com <wa...@gmail.com> #120
dr...@gmail.com <dr...@gmail.com> #121
I would hate to be forced to switch back to excel due to the negletance of this malfunction.
mi...@viesure.io <mi...@viesure.io> #122
Hey there, would be great if you could raise the priority of this. Seems like a very useful feature.
Our use case: We have done a project evaluation and recorded comments for ratings as comments on the cells. Now to create a final report for management, all those comments must be collected in a Docs file for documenting the decision process. Lacking this functionality, we have to do that manually, which will take several hours of point and click, copy, paste.
Could have been 5 minutes of work with range.getComments()
So any situation where transparency is required for a report, extracting comments for documentation purposes is a use case.
Also an answer on a workaround for the issue described in
an...@pwc.com <an...@pwc.com> #123
gi...@gmail.com <gi...@gmail.com> #124
gi...@rideonlille.com <gi...@rideonlille.com> #125
[Deleted User] <[Deleted User]> #126
[Deleted User] <[Deleted User]> #127
I have a doc with 100's of comments, i just dont want to see them. I can clone the doc and resolve the comments but really dont want to resolve each comment by hand. would love a script API to allow me to do this
se...@gmail.com <se...@gmail.com> #128
ra...@gmail.com <ra...@gmail.com> #129
[Deleted User] <[Deleted User]> #130
pi...@gmail.com <pi...@gmail.com> #131
Beeing able to track action items in comments thru range.getComments() would be great. That would avoid going down thu 100's of comments on a sheet to find MY action items or having to reopen my sheet via drive or sheets to unkown action item to find out that this isn't yet the item i can solve at the moment, and repeat the process every time.
mi...@mar-ol.pl <mi...@mar-ol.pl> #132
an...@gmail.com <an...@gmail.com> #133
[Deleted User] <[Deleted User]> #134
ph...@airbus.com <ph...@airbus.com> #135
le...@paloaltonetworks.com <le...@paloaltonetworks.com> #136
ab...@gmail.com <ab...@gmail.com> #137
kh...@securitypalhq.com <kh...@securitypalhq.com> #138
ga...@gmail.com <ga...@gmail.com> #139
er...@gmail.com <er...@gmail.com> #140
gs...@gmail.com <gs...@gmail.com> #141
[Deleted User] <[Deleted User]> #142
rz...@gmail.com <rz...@gmail.com> #143
fi...@softwoodtextiles.com <fi...@softwoodtextiles.com> #144
tg...@bgindy.com <tg...@bgindy.com> #145
tr...@dashlx.com <tr...@dashlx.com> #146
ma...@gmail.com <ma...@gmail.com> #147
ty...@avgidea.io <ty...@avgidea.io> #148
yu...@gmail.com <yu...@gmail.com> #149
vo...@gmail.com <vo...@gmail.com> #150
ya...@rafflesian.net <ya...@rafflesian.net> #151
s....@gmail.com <s....@gmail.com> #152
da...@drpbanerji.com <da...@drpbanerji.com> #153
pa...@caasf.org <pa...@caasf.org> #154
in...@gmail.com <in...@gmail.com> #155
gr...@gmail.com <gr...@gmail.com> #156
ja...@groupm.tech <ja...@groupm.tech> #157
ro...@gmail.com <ro...@gmail.com> #158
mc...@bitwiseindustries.com <mc...@bitwiseindustries.com> #159
ca...@pwc.com <ca...@pwc.com> #160
in...@gmail.com <in...@gmail.com> #161
ch...@gmail.com <ch...@gmail.com> #162
That's goona be a decade in september next year for this request being unresolved!
ra...@gmail.com <ra...@gmail.com> #163
st...@gmail.com <st...@gmail.com> #164
tz...@scylladb.com <tz...@scylladb.com> #165
al...@google.com <al...@google.com> #166
Any word on this? So many workflows depend on assigning work to colleagues via comments...
Also, happy nearly 10 year anniversary to this thread!
Description
Please add methods create, edit, delete, reply for new comments (discussions).
Notes:
Provide any additional information which might be useful here.
range.getDiscussion()
range.setDiscussion(text)
range.replyDiscussion(text)
range.deleteDiscussion()