Hi,
Does anyone now of a possibility to create a scheduler-like view?
Names in a column on the left, days horizontally on the top. View should contain documents which contain of course the name & days.
Any ideas?
B.
Subject: I took an alternative approach
to a somewhat similar requirement
Rather than use a view, I composed a form as a User Interface
(The form had SaveOptions = “0” so that the document being edited was never saved)
This form had a table with fields forming a grid that I populated with data during the PostOpen event.
Obviously the data was taken from those documents with the day/name combination corresponding to the row/column.
[I had lots of field called Data_5_7 computed when composed to “” but set and reset from script]
I used actions/buttons above the grid to do move date forward/back or up down name list (if larger than I chose to show) - all that did was recalculate the grid to the new base point.
I even placed hot spots over the fields to allow them to be clicked to edit the entry.
This was a while ago - done in R5 CLIENT - tricky work but once ‘invented’ most just careful repetition.
If needed for BROWSER Client or possibly even R6/R7 Client
I think you could use HTML to paint the table
etcThat would make it a looped coding issue rather than creating lots of fields and hotspots - much less likely to have an error
I’ve been meaning to try this but not got round to it yet.
Let me know how you get on 
Good luck
Subject: RE: I took an alternative approach
Hello Alan,I have the same issue, but I need more details (I know that your post is very old but it’s urgent for me). If you send me the me an example of the code that would be appretiated.
my e-mail is ulutufal@etq.com
Thanks
Subject: Scheduler-like view
A categorized view by name then by date (however you want to format it) would give the result you want, but it’s going vertically! But if your users are adamant it goes horizontally (mine were)…
As far as I know, an embedded calendar view with “show Single Category”, which could be a good solution, does not work, I have tried.
I presume you want it so when you click on column “15” for Joe Bloggs, it opens a document for just that, some appointment(s) or such for that date. I put together a solution with the following caveat : when you click on column “15” for Joe Bloggs, a document opens which is formatted to show the whole month.
Read on if this is of any interest:
I had a similar request, production widgets down the left, the last 12 months sales in the columns, and 6 months into the future for entering forecast values. The view columns have to always show the correct year\month as time rolls on.
Now I realise my solution may have been better realised by exporting the data to Excel or some other system, but the request was to keep it in Notes. Here is the gist of what I did…
Set up a view e.g. “vwSchedule” which contains documents called e.g. “Schedule”. An nightly scheduled agent then trawls through my sales DB and picks up the monthly figures for each widget for the last 12 months, and places these figures in fields named History_1, History_2,…History_12 on the Schedule documents (there are also fields called Forecast_1,…Forecast_6, editable columns in view). Then, the agent cycles accross the column titles and changes the column containing field “History_1” to the correct date, e.g. 2005 - 08. Use Dim vc As NotesViewColumn and
For i = 1 To 12
Set vc = vw.Columns( i )
vc.Title = {Some column text}
Next
…to set the column titles. If in your case it’s always days, maybe you just need to strip off 30-31 depending which month it is. Of course when you click on Joe Bloggs and column “15” it’s opening the same doc’ for all columns ! If you can achieve satisfactory formatting of a months data, then this could work for you.
Subject: RE: Scheduler-like view
Hello Nick,I have the same issue, but I need more details (I know that your post is very old but it’s urgent for me). If you send me the view example that would be appretiated.
my e-mail is ulutufal@etq.com
Thanks