Is it possible to create a list with the features below?

I need to create a list of news items with the following features:
=B7 The author has the option of EITHER typing in an article OR
entering a URL to another document/outside link
=B7 The list has several fields, but to simplify, it has an article
title and a business segment field that the list must be GROUPED BY.
=B7 When the end user opens his screen, he sees a list grouped by
business segment of article titles.
=B7 When he clicks on the article title he is taken either to a view of
the article or to a document / outside link.

This functionality is very similar to the news functionality; but this
list must be grouped.

I have come very close to achieving this by:
=B7 Adding a calculated field called articlelink in addition to a
document/externalLink
=B7 The calculation for articlelink:
=3DIF([Document/External
Link]=3D"","http://portalName/C18/InsideBusiness/Document%20Library/newsdev=
read4.aspx?View=3D%7bD5C43636%2d0FE4%2d4B75%2dA6F6%2d224AD894319F%7d&Filter=
Field1=3DID&FilterValue1=3D"&ID,[Document/External
Link])

The articletitle field is a dynamic hyperlink field containing the
result of the calculation for artclelink. It takes you to a view of the
list containing just the article that was clicked on. The view is
designated by the ID of the list item.

The articlelink field has the above calculation in it. It works
perfectly until we add a new item and due to the timing of the ID field
assignment, the link is not fully updated. I discovered that this is a
known problem.

I am wondering if anyone has discovered a workaround to this problem or
if anyone has any thoughts on how to accomplish my list objective
above?

Dustin
Sun Dec 11 17:53:10 CST 2005

You hit it; it's a known problem because ID isn't available to you until
after the item is saved to the database and the transaction posts.

You could set the hidden form field "NextUsing" to be your own ASP.NET page
in _layouts, and in that page, go back to the database to find the record
you just added and perform any calculations you need (or, if memory serves,
just re-save the record and the calculated field should recalculate). It
wouldn't work that well if two people add a record at the same time, but
if that never happens, it might work just fine for you.

-----
Dustin Miller
SharePoint University (Community) [http://www.sharepointu.com]
SharePoint Bootcamp (Training) [http://www.sharepointbootcamp.com]
SharePoint Blogs (Blogs) [http://www.sharepointblogs.com]
SharePoint Experts (Business) [http://www.sharepointexperts.com]

> I need to create a list of news items with the following features:
> · The author has the option of EITHER typing in an article OR
> entering a URL to another document/outside link
> · The list has several fields, but to simplify, it has an article
> title and a business segment field that the list must be GROUPED BY.
> · When the end user opens his screen, he sees a list grouped by
> business segment of article titles.
> · When he clicks on the article title he is taken either to a view of
> the article or to a document / outside link.
> This functionality is very similar to the news functionality; but this
> list must be grouped.
>
> I have come very close to achieving this by:
> · Adding a calculated field called articlelink in addition to a
> document/externalLink
> · The calculation for articlelink:
> =IF([Document/External
> Link]="","http://portalName/C18/InsideBusiness/Document%20Library/news
> dev
> read4.aspx?View=%7bD5C43636%2d0FE4%2d4B75%2dA6F6%2d224AD894319F%7d&Fil
> ter
> Field1=ID&FilterValue1="&ID,[Document/External
> Link])
> The articletitle field is a dynamic hyperlink field containing the
> result of the calculation for artclelink. It takes you to a view of
> the list containing just the article that was clicked on. The view is
> designated by the ID of the list item.
>
> The articlelink field has the above calculation in it. It works
> perfectly until we add a new item and due to the timing of the ID
> field assignment, the link is not fully updated. I discovered that
> this is a known problem.
>
> I am wondering if anyone has discovered a workaround to this problem
> or if anyone has any thoughts on how to accomplish my list objective
> above?
>