Messages - David1904 [ switch to compact view ]

Pages: prev1 2 3 4 5 6 [7] 8 9next
31
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 30, 2008, 05:01 PM »
I got "Dancing Alone" with a date of 28/11/2007 appearing as a sub item under the first individual in the first family. I found that item is in the Music Libray grid - and can't see how it got connected


going by my previous post,
you could try removing all items from tag list (again, in context menu its in with "add items to tag list" entry) and then try again

tried a couple of test items here -
when I clear the tag list, it works as expected

Yes, when I cleared tags and then began fresh it worked.
However, when put in an attendance date for an individual (for the first week) and then entered one again for the same individual (or family) on the second week - it modified the first entry to contain the same value. I created an attendance checkbox in another column, and the same thing happens. Any alteration made on any one of the attendance rows changes the value on all other rows for that individual/family.

Can anyone help? Pierre - maybe I could use that kind offer of an example from you - I just can't figure out how all these "bits" hang together.

Thanks,

David

32
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 29, 2008, 04:28 AM »
There are a number of ways to do this, each with advantages and disadvantages. The first way that comes to mind is to:
1- In the "AddressBook" grid, create families and members as sub-items. Add pertinent information (age group, etc)
2- In an "Events" grid, create events with all pertinent information (date, location, etc)
3- To link the two, select participants (families or individual persons) and add them as sub-items of the event (tag the items and add tagged items as subs). More details if desired.
Visually, it will work quite well.
As for the pivot table analysis, a proposed modification (by superboyac) will allow the pivot table to compile statistics for such a grid (the current pivot cannot since the source is not well defined).

I can build such a solution if you wish. Approx time: 10-15 min.

I think I tried what you suggested - but when right clicking an item to tag it, I got "Dancing Alone" with a date of 28/11/2007 appearing as a sub item under the first individual in the first family. I found that item is in the Music Libray grid - and can't see how it got connected
Probably I need a few more details and a bit of help on this one! - I'm not really a database person.

Thanks,
David

33
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 28, 2008, 06:09 PM »
Is it possible to have hierachies/sub items within dates AND within some text grouping at the same time (ie thinking of the basketball scoring - can there be groups of players as well as groups of dates)
Could you provide an example ?

Yes, where you have a situation of families attending a regular event and you want to be able to record both the presence of family units at one or more events and also individual presence at one or more events (when sometimes only some family members are present). It would be be good to be able to produce a pivot table/chart showing attendance by family and/or individual on a per week/month/year basis. A further refinement is where individuals might also belong to one of three or four age brackets and you want to analyse attendance by either family representation, or perhaps individual participation, within those age brackets.

Thanks,

David


34
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 28, 2008, 02:30 AM »
Sorry Pierre,

When I put the original Date field back I realised I had not deleted all the dates out of that column.
Closing and then re opening seemed to allow the Attendance date to show in the field pick list this time (didn't seem to on earlier attempts)
Is it possible to have hierachies/sub items within dates AND within some text grouping at the same time (ie thinking of the basketball scoring - can there be groups of players as well as groups of dates)
Thanks,

David

35
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: January 28, 2008, 02:06 AM »
Pierre,

I created a new field called attendance date and put yesterdays date in it - about a dozen entries. Previously I had created a grid with a Date field in it with two entries having a date about 2 weeks earlier.
I deleted that column from showing in the grid, so the only field/column showing with a date in it is Attendance date.
However, when I try and create a pivottable, it insists on finding the old deleted dates (as well as the new ones) whenever I put Date into the pivot table - there is no Attendance date field showing in the field pick list.
Can you help me out here - I can't seem to find anything addressing this in the wiki etc.

Thanks,

David 8)

Pages: prev1 2 3 4 5 6 [7] 8 9next
Go to full version