SharePoint User Group UK

Share the knowledge!

Welcome to SharePoint User Group UK Sign in | Join | Help
in
Home Blogs Forums Photos Files Roller

MS Template - room and equipment - RERStatus field

Last post 03-11-2008, 4:38 PM by Pete.Norman. 1 replies.
Sort Posts: Previous Next
  •  01-15-2008, 4:20 PM 7838

    MS Template - room and equipment - RERStatus field

    My first noob question of the year !

    I'm using the Microsoft Template - Room and equipment booking - and i want to have some custom pages based on the Reservations list.  However when you book something out, it creates two records, one for the booking and one for the post free time.  The templates own views make use of a RERStatus field to distinguish between the two - however this is a hidden field and i've not been able to make us of it.

    A google search reveals that maybe some code could reverse this but i have 0 C# or .Net knowledge.

    As ever help is appreciated

    Pete

    Nothing is as it seems, nor is it otherwise.
  •  03-11-2008, 4:38 PM 9009 in reply to 7838

    Re: MS Template - room and equipment - RERStatus field

    I've got around this (for now or until i find how to activate the RERStatus) by adding my own status field  of type Yes/No to the reservations list with default value of false (no).  This field is set not to be displayed by default and when creating a new reservation it sets this value to true (yes) by adding a hidden field to my custom new form.

    So in short the booking gets a value of "yes" and the filler (or free time) reservation record gets a value of "no".  Now you can filter your views to display only the real bookings.

    Not activating the RERStatus field by tweaking your stsadm or a similar hacking method above means that if you display a custom view of the bookings, you'll get both the real and filler bookings and if you have a custom list that links to an edit page, you're soon going to get in a right mess.

    hope this helps someone ?   And if you have a prettier method (non C# coding) then please post here !

    Edit : Step by step  (looking at the above in hindsight it's not very clear)

    Basically...
    - add a new field to the reservations list - called "CustomStatus"  or something better
    - it needs to be a Y/N type field with default of "N"
    - now you need a workflow to be kicked off on create, you might have one already.
    - all it needs to do is (for the current item) set your CustomStatus field to equal "Y"

    So hopefully new bookings will get a Custom Status of Y and the filler bookings will remain as N

    Then in ALL of your custom views you need to filter the list so that CustomStatus = Y.  So the end result is that only real bookings are displayed.



    Nothing is as it seems, nor is it otherwise.
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems