Submitted by David_H on 2019/09/20 21:19
 If I am looking at an Item in a grid that is also on the calendar I would like to be able to read the description without having to go and find the item in the calendar to open it. Is that possible?
 
Thanks Pierre.

Comments

I'm glad someone else is requesting this feature. It would seem to be pretty simple as the Calendar-specific Fields should be similar to any other Item Field. Maybe they are actually part of the Event instead (an Calendar Item can have multiple events)? 

DragonGem

2019/10/04 07:54

In reply to by DragonGem

Pierre,
How about just a shortcut that just pops up the Calendar Editor for any Item that has ItemInCalendar flag set? That way I could at least sync a couple of Grid Columns via Cut-and-Paste without having to jump around in Calendar Pane.

 

KeithB

2019/11/03 14:27

In reply to by Pierre_Admin

 I believe there's a typo in the new example: AS EventDesc (needs to be AS EventDescr)
 
 

Pierre_Admin

2019/11/03 15:38

In reply to by KeithB

Indeed, it can be anything, but must match the field name !
 
Pierre_Admin
IQ Designer
 

DragonGem

2019/11/04 11:38

In reply to by Pierre_Admin

Hi Pierre,

Thanks for the example showing the procedure for pulling info from Calendar Events into Grids. So "Body" = Event's "Description" field. What are the element IDs for the other Calendar Event fields ("Where", "All-day", "Meeting", "Private", etc.)?

Since these values are Read-Only, editing the values requires popping up the Calendar Event Dialog. This is currently quite cumbersome (click on proper Date Field, press {F2} twice, press {Alt+E}). Any chance of getting a Shortcut key to automatically open the Calendar Event Dialog for the currently selected Grid Item if ItemInCalendar = True?

DragonGem

2019/11/06 11:53

In reply to by DragonGem

No reply so I took Pierre's suggestion elsewhere to open a copy of my .SNDB file with MS Access. Looking at the structure to the Event Table reveals the following:
  • "Body" = Description
  • "Location" = Where
  • "IsMeeting" = Meeting
  • "IsPrivate" = Private
  • "IsAllDayEvent" = All-day
  • "IsUnscheduled" = Unscheduled
Unfortunately changes made in the Calendar Event Dialog are NOT immediately reflected in the Grid; even {F5} Refresh doesn't force a Re-Calc of the Option code. Selecting a different Agenda Item and returning to the edited Item clears that up; good enough for now. The Event Dialog ShortCut would be really helpful though.
 
Not sure how effective all this is with Recurring Events but I use separate Child Items for that purpose instead. 

 

LeftEccoForIQ

2019/11/06 14:16

In reply to by DragonGem

[quote=DragonGem]Not sure how effective all this is with Recurring Events but I use separate Child Items for that purpose instead.[/quote]
 
Could you explain briefly explain this method, please? Many thanks.

DragonGem

2019/11/06 16:22

In reply to by LeftEccoForIQ

It might just be my Life but (outside of Birthdays and Anniversaries) NONE of my "Recurring" Events ever seem to occur repeatedly exactly as first planned. So my approach is to setup the Parent Agenda Item with all the required information. I can then copy that Item as many times as reasonable as Child Items to the original Item, setting their Agenda Dates as planned. When the inevitable disruptions occur, I simply adjust the corresponding Child Item appropriately.

The nice feature of Recurring Events is that they all relate back to a single Agenda Item and I can use that Item's Document pane to keep a running summary of Events (i.e. what I got my wife each anniversary). The same effect can be achieved by setting the Document of the Parent Agenda Item as an external HTML file. Simply copy that ItemHTMLFile value into the Child Items and that single HTML File will display for each Item.

As previously stated, my preference is to maintain a detailed Agenda Grid and have IQ's Calendar simply reflect those Grid Items. Ideally, I would like to have a separate Calendar Pane that could be attached to a specified Grid that would reflect only the filtered Items in the attached Grid.

Pierre_Admin

2019/11/06 16:41

In reply to by DragonGem

Interesting indeed !!
 
A calendar sub-view is on the road map, but how about using the currently available TimeLine sub-view ?
 
Pierre_Admin
IQ Designer
 

DragonGem

2019/11/06 19:30

In reply to by Pierre_Admin

"TimeLine Sub-Vew"? That's a new term to me. Can you point me to some Documentation? I see some tangential references with regards to the Gantt View but that is substantially different from the Calendar View.

I would like to visualize my whole week and then selectively activate/deactivate various combinations. I can "fake" it currently by saving a copy of the ItemInCalendar flags in a separate Grid Column, clearing all the existing ItemInCalendar flags (dangerous?), filtering the Grid appropriately and resetting the ItemInCalendar flags based on the copied value. Of course things get a little dicey if I get distracted and forget to reset all the ItemInCalendar flags back before making other changes!

Good to hear that the Calendar Sub-View is on the Road Map. Your track record is certainly excellent in that regard (although the time-lines and priorities tend to be a little bit "fluid" shall we say  ).

Pierre_Admin

2019/11/06 20:07

In reply to by DragonGem

re TimeLine
 
Yeah, that page still needs to be written 
 
So in Grid Properties, you'd just set the Gantt start date field to your date field
In your Agenda grid, do View > TimeLine
That sub-view can then be detached and docked on the main UI or in a dashboard type grid
 
re: "Fluid" priorities
 
Well, one thing that is hard as hell, is to always provide a reliable app for you, IQ Users !!
 
Pierre_Admin
IQ Designer
 

DragonGem

2019/11/06 21:07

In reply to by Pierre_Admin

Pierre, thanks for the info. I'll keep exploring but I've got something workable now so I can wait for Calendar Sub-Views.

I've been trying to implement my vision of Time Tracking / Scheduling / Task Lists / Project Management for literally DECADES now. InfoQube is the closest that I have ever come! Combine that with your FIRST-RATE Information Collection / Tagging / Composition facilities and IQ has become a truly indispensable tool for me.

I hope that you didn't take my comment on "fluid" priorities the wrong way. I'm constantly amazed at the facilities that you are able to implement in a matter of days (Related Items is just the latest "tangent"). I don't begrudge you for shifting focus to ideas that intrigue you as that's where true innovation takes place. Some of those things may not be my immediate priorities but they will probably be useful to me at some point (usually in ways I haven't even thought of yet).

Keep up the excellent work!

Are you aware that when the item is selected and you have the properties pane open and you can click on the dropdown button for the date field connected with the calendar, in the ensuing popup date selection dialog, there is an 'Edit' button? Clicking on it will bring up the Event details dialog showing the description. No need to go through the calendar.

DragonGem

2019/11/06 15:30

In reply to by LeftEccoForIQ

Believe me, I've experimented with virtually every permutation in trying to optimize syncing IQ's Calendar with an Agenda Grid. I currently have 6 separate Date Fields (each with a distinctive Color) connected to the Calendar plus a separate Agenda Date and a Date Type field that together control moving Values back and forth between the Agenda Date and the individual Calendar Date Fields. 

The ONLY date field that I want to see in my Agenda Grid is the Agenda Date but it is the one field that is not synced to IQ's Calendar so its Date pop-up doesn't have the [Edit] button. Currently, I've added the individual Date Fields as right-most columns (out of sight for the most part) and setup separate Keyboard Macros with {End}{Left (0 or more times)}{F2}{F2}{Alt+E} in order to focus the proper Date Field and initiate the Event Dialog. Workable but clumsy and prone to error if any of the Date Fields get re-arranged.

The Property Pane is not really any better as it depends upon which Groupings are left open and requires using the mouse to select the proper Date Field plus it still requires multiple keystrokes and/or clicks. A Shortcut Key that simply relies on the ItemInCalendar flag to initiate the Event Dialog (which appears to be directly attached to the ItemID as well as the Date Field) makes more sense IMHO.

Shift+F2 on a date cell brings you directly to the Event dialog
 
HTH !
 
Pierre_Admin
IQ Designer
 

DragonGem

2019/11/06 20:25

In reply to by Pierre_Admin

Good to know about {Shift+F2} but this still requires focusing the Linked Calendar Date field beforehand. Focusing ANY other Date Field automatically sets up an additional Event associated with the currently focused Field. I understand why this would be useful but it does open up another potential conflict with my methodology. I'm beginning to see how complicated the connection between Items and Events can become.

I also withdraw my assertion that the Grid {F5} Refresh doesn't Re-Calc values based on Options code. I suspect that I had accidentally created an additional Event so I wasn't seeing what I thought I was changing. Recent tests seem to work as expected.