Re: Can I do this with a SharePoint list?
From: Ian Morrish (Ian_Morrish_at_HotMail_dot_com)
Date: 05/10/04
- Next message: abajo: "DVWP connection to SQL Server"
- Previous message: Ian Morrish: "Re: why should i go for Sharepoint Portal Server?"
- In reply to: Edward Lee: "Re: Can I do this with a SharePoint list?"
- Next in thread: Edward Lee: "Re: Can I do this with a SharePoint list?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 11:45:54 +1200
You might have to resort to going into the XSL and find the displayed field
name and change it.
I have seen sometimes that there is no option to create a hyperlink but
haven't determined what the condition is. Probably something to do with the
type of field it is.
Regards,
Ian
"Edward Lee" <elee@ulgm.org> wrote in message
news:uxaMgcxMEHA.3292@TK2MSFTNGP11.phx.gbl...
> Hi Ian. I did do as you suggested. Still, when I get to the last step, the
> 'create hyperlink on' dropdown box is empty and I can't get to the next
> step.
>
> Any additional thoughts?
>
> Thanks,
> Ed Lee
>
>
> "Ian Morrish" <ian_morrish@hotmaildotcom> wrote in message
> news:uBbr1NZMEHA.3572@tk2msftngp13.phx.gbl...
>> Right click on each Web Part and select "Convert to XSLT Data View". Now
> try
>> the connection.
>> You should get something similar to this
>> http://www.wssdemo.com/Pages/connections.aspx
>> In my demo the Title field in the Link Category list is used as a lookup
>> field in the Links list
>>
>> Regards,
>> Ian
>> "Edward Lee" <elee@ulgm.org> wrote in message
>> news:%232%23B4tYMEHA.2676@TK2MSFTNGP12.phx.gbl...
>> > Ian,
>> >
>> > Can you tell me what I might be doing wrong?
>> >
>> > First, I created two lists. List 1 has a field called 'Name' and List 2
>> has
>> > a field called 'Date', 'Hours Volunteered', and 'Name'. The 'Name'
>> > field
>> in
>> > List 2 is a lookup column that draws its values from the Name field in
>> List
>> > 1.
>> >
>> > Next, I added the webpart view of each of these lists to the page using
>> > FrontPage. I ran the webpart connection wizard, using List 1 as the
> source
>> > webpart and provide data values as the source action. I then chose List
> 2
>> as
>> > the target webpart and filter view as the target action. I chose Name
>> > as
>> the
>> > column that contains matching data. When I get to the last step, the
>> 'create
>> > hyperlink on' dropdown box is empty and I can't get to the next step.
>> >
>> > What am I doing wrong?
>> >
>> > Thanks,
>> > Ed Lee
>> >
>> >
>> > "Ian Morrish" <ian_morrish@hotmaildotcom> wrote in message
>> > news:e72LKh%23LEHA.3596@tk2msftngp13.phx.gbl...
>> > > You can do it if you change you Web Parts to Data View Web Parts
> (DVWP)
>> > > See a demo here
>> > > http://www.wssdemo.com/Pages/connections.aspx
>> > > Regards,
>> > > Ian
>> > > "Edward Lee" <elee@ulgm.org> wrote in message
>> > > news:Ogv4G15LEHA.3472@TK2MSFTNGP09.phx.gbl...
>> > > > Mike, Steven,
>> > > >
>> > > > Thanks for your feedback. I was thinking maybe I was missing
> something
>> > > > simple. I guess not.
>> > > >
>> > > > Ed Lee
>> > > >
>> > > >
>> > > > "Steven Collier [MVP]" <steven.collier@mvps.org> wrote in message
>> > > > news:ezRVEMuLEHA.1388@TK2MSFTNGP09.phx.gbl...
>> > > > > You can nearly do it, there's just one link missing that breaks
> the
>> > > whole
>> > > > > thing :-
>> > > > >
>> > > > > 1. You can add a column of type lookup which is a link between
>> tables
>> > > (it
>> > > > > stores a row number but displays the value from the column in the
>> > second
>> > > > > list you select)
>> > > > >
>> > > > > 2. You can use webpart collection so when you select a row in
>> > > > > list
>> > one,
>> > > > list
>> > > > > 2 filters to show rows that match.
>> > > > >
>> > > > > But what's missing is that it currently prevents you from using
>> these
>> > > > lookup
>> > > > > columns in connections, so the who lot is useless.
>> > > > >
>> > > > > It's quite possible to create what you wanted by building some
>> custom
>> > > > > webparts etc. but it would be much nicer if it could be done with
>> > > features
>> > > > > in the box
>> > > > >
>> > > > > --
>> > > > > Steven Collier
>> > > > >
>> > > > > SharePoint Portal Server MVP
>> > > > > "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>> > > > > news:u3BXNTtLEHA.624@TK2MSFTNGP11.phx.gbl...
>> > > > > > Pity it's you who is asking Ed otherwise it would be a simple
>> > > > > > "I
>> > > > wouldn't
>> > > > > > start here" I.e. I wouldn't use WSS for this.
>> > > > > >
>> > > > > > But with your skills you are bound to be able to get it to
> work -
>> > it's
>> > > > > > really as I see it a question of whether the ease of creating
> the
>> > web
>> > > > site
>> > > > > > and the demographic info outweighs the messing around to get
>> > > > > > the
>> > rest.
>> > > > > >
>> > > > > > I'd say no, but that's a gut feeling only.
>> > > > > >
>> > > > > > Mike Walsh, Helsinki, Finland
>> > > > > > WSS FAQ at wss.collutions.com
>> > > > > > Please post questions to the newsgroup only.
>> > > > > >
>> > > > > >
>> > > > > > "Edward Lee" <elee@ulgm.org> wrote in message
>> > > > > > news:#9OKBDtLEHA.1052@TK2MSFTNGP12.phx.gbl...
>> > > > > > > I'm wondering if I can easily accomplish the following with a
>> > > > SharePoint
>> > > > > > > list, or whether I should be considering an Access database
>> > > > > > > or
>> > some
>> > > > > other
>> > > > > > > solution...
>> > > > > > >
>> > > > > > > We need to keep track of about 300 volunteers. Along with
>> > > demographic
>> > > > > > > information, we need to keep track of their site assignments,
>> each
>> > > of
>> > > > > > their
>> > > > > > > volunteer sessions, and the amount of time volunteered during
>> each
>> > > > > > session.
>> > > > > > > I would then need reports on total number of hours
>> > > > > > > volunteered
>> > > across
>> > > > > the
>> > > > > > > entire project and by site for various periods of time.
>> > > > > > >
>> > > > > > > I guess the big question that I have is whether I can create,
>> what
>> > > in
>> > > > > > > database terms would be, a one-to-many relationship. That is,
>> each
>> > > > > > > individual volunteer record is associated with many volunteer
>> > > session
>> > > > > > > records.
>> > > > > > >
>> > > > > > > Thanks for any advice,
>> > > > > > > Ed Lee
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>
- Next message: abajo: "DVWP connection to SQL Server"
- Previous message: Ian Morrish: "Re: why should i go for Sharepoint Portal Server?"
- In reply to: Edward Lee: "Re: Can I do this with a SharePoint list?"
- Next in thread: Edward Lee: "Re: Can I do this with a SharePoint list?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
