StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19867654
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-11-08T20:05:50.200
FavoriteCount
0
LastActivityDate
2018-02-17T20:35:23.233
LastEditDate
2018-02-17T20:35:23.233
LastEditorUserId
947370
OwnerUserId
947370
ParentId
5831877
PostTypeId
2
Score
43
ViewCount
0
LastEditorDisplayName
text
Body
The links in Dave's post are great. Just to put a few technical details about the google links into an answer here on SO: Google Calendar Link <code><a href="http://www.google.com/calendar/event?action=TEMPLATE&text=Example%20Event&dates=20131124T010000Z/20131124T020000Z&details=Event%20Details%20Here&location=123%20Main%20St%2C%20Example%2C%20NY">Add to gCal</a></code> the parameters being: <ul> <li>action=TEMPLATE (required)</li> <li>text (url encoded name of the event)</li> <li>dates (ISO date format, startdate/enddate - must have both start and end time - the button generator will let you leave the endtime blank, but you must have one or it won't work.) <ul> <li>to use the user's timezone: 20131208T160000/20131208T180000 </li> <li>to use global time, convert to UTC, then use 20131208T160000Z/20131208T180000Z</li> <li>all day events, you can use 20131208/20131209 - note that the button generator gets it wrong. You must use the following date as the end date for a one day all day event, or +1 day to whatever you want the end date to be.</li> </ul></li> <li>details (url encoded event description/details)</li> <li>location (url encoded location of the event - make sure it's an address google maps can read easily)</li> </ul> <hr> <h2>Update Feb 2018:</h2> Here's a new link structure that seems to support the new google version of google calendar w/o requiring API interaction: <code>https://calendar.google.com/calendar/r/eventedit?text=My+Custom+Event&dates=20180512T230000Z/20180513T030000Z&details=For+details,+link+here:+https://example.com/tickets-43251101208&location=Garage+Boston+-+20+Linden+Street+-+Allston,+MA+02134</code> New base url: <code>https://calendar.google.com/calendar/r/eventedit</code> New parameters: <ul> <li>text (name of the event)</li> <li>dates (ISO date format, startdate/enddate - must have both start and end time) <ul> <li>an event w/ start/end times: 20131208T160000/20131208T180000 </li> <li>all day events, you can use 20131208/20131209 - end date must be +1 day to whatever you want the end date to be.</li> </ul></li> <li>ctz (<a href="https://en.wikipedia.org/wiki/List_of_tz_database_time_zones" rel="noreferrer">timezone</a> such as America/New_York - leave blank to use the user's default timezone. Highly recommended to include this in almost all situations. For example, a reminder for a video conference: if three people in different timezones clicked this link and set a reminder for their "own" Tuesday at 10:00am, this would not work out well.)</li> <li>details (url encoded event description/details)</li> <li>location (url encoded location of the event - make sure it's an address google maps can read easily)</li> </ul> Notes: <ul> <li>the old url structure above now redirects here</li> <li>supports https</li> <li>deals w/ timezones better</li> <li>accepts <code>+</code> for space in addition to <code>%20</code> (<code>urlencode</code> vs <code>rawurlencode</code> in php - both work)</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do I create a link to add an entry to a calendar?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USsquarecandy
UserOwnerUserId
1. USsquarecandy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.