Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Steps to generate a Course sign-in sheet

Table of Contents
minLevel1
maxLevel2
style


Related Helpguide Pages

Panel
panelIconIdatlassian-note
panelIcon:note:
panelIconText:note:
bgColor#DEEBFF

Learn how to generate a sign-in sheet for a Course

As your Course approaches, you can quickly generate a list of the Delegates registered for the Course. You can then supply to your trainers or your reception, to streamline the sign-in process!

previewing the sign in sheet for the three delegates

Follow this page to learn the steps to generate a sign-in sheet for your Course.


✍️ Optional: Create your own sign-in sheet

Panel
panelIconIdc64be934-3e6f-431d-8f81-7b6fb0382adf
panelIcon:accessplanit_logo:
panelIconText:accessplanit_logo:
bgColor#DEEBFF

Your accessplanit platform has a standardised sign-in sheet available to use, however if you would like to design your own and have control over what information is included in your sign-in sheet, you can upload sign-in sheet templates, that have been created in Microsoft Word

There are special accessplanit merge fields that you can include in your Word documents, so that the information held in your accessplanit platform is automatically populated in your sign-in sheets when they are generated for a Course.

To create a sign-in sheet, you will follow these steps:

  1. Build your sign-in sheet in MS Word

  2. Create a sign-in sheet Document Template

  3. Test the sign-in sheet

🏗️ Build your sign-in sheet in MS Word

The first step is to open Microsoft Word and create your sign-in sheet template, using accessplanit merge fields

Expand
titleBuild your sign-in sheet in MS Word
Tip

Top tip!

Before you begin building your sign-in sheet, first consider what you would like to include in your sign-in sheet, consider:

  • What information do you want to include? The name and date of the Course, and the names of the Delegates are recommended as a minimum!

  • Your brand - are there certain colours and logos that you need to include?

  1. Open the Microsoft Word application

    Word Application icon

  2. If you have an existing sign-in sheet document, you can open this and use it as your sign-in sheet template

  3. If you do not yet have an existing sign-in sheet document, use Microsoft Word’s tools to build the structure of your sign-in sheet

    sign in sheet structure built in MS Word

  4. Once you have the structure in place, you can add in ‘merge fields' which will pull information from your accessplanit platform into each sign-in sheet that is generated, for example adding in the merge field of ‘course_label’ so that the name of the Course is included on at the top of the document when it is generated

    top of the sign in sheet with two merge fields added

  5. The first step of adding a merge field is to find the label that is needed for the field, to do this, open the Document Template Merge Fields and Glossary and find the merge field that you would like to include, copy the label of the field from this page

  6. Click into your Word document where you would like to place the merge field

    clicked into the top of the sign-in sheet

  7. Open the ‘Insert' menu in Microsoft Word and view the 'Quick Parts’ options

    image-20240213-085321.png

Please note

If you are using a Mac you will go to Insert > Field

  1. Click the ‘field’ option from the drop down to open the ‘Field’ pop-up window

    field pop-over window

  2. From the ‘Field names:' list scroll down and select the 'MergeField’ option

    MergeField option selected

  3. Paste the merge field label into the ‘Field name:’ textbox

    the merge field course_label is being added via the MergeField options

  4. Click the OK button to add your merge field into your sign-in sheet template

    course_label has now been added to the document

  5. Repeat steps 5-11 for each merge field in your sign-in sheet until you are happy with the contents

  6. To include information about multiple Delegates in your sign-in sheet, at the end of the Delegate merge field add a colon and a number to tell your platform which Delegate’s details you would like to display there, i.e. candidate_name:1 , candidate_name:2 , candidate_name:3. There should be no spaces within the MergeField label

    image-20240204-160019.png

Tip

Top Tip!
A quick way to edit multiple Merge Fields is to press ALT+F9 to set the fields to ‘advanced' mode. You can then amend each number within the fields, press ALT+F9 again, right click on the field and update field, this will amend them all quickly for you instead of having to add each one manually.

  1. Save your sign-in sheet file

    Save option in Word

Tip

Top Tip!

You can apply formatting to some merge fields, such as date fields, so if you would prefer that your dates are displayed as 14 Jun 2025 or 06-14-25 instead of 14/06/2025, then please refer to our https://accessplanit.atlassian.net/wiki/spaces/HG/pages/385286154/Document+Template+Merge+Fields+and+Glossary#Managing-Date-Formats-in-Merge-Fields guide to add in your choice of formatting.

🖇️ Create a sign-in sheet Document Template

Once you have created and saved your sign-in sheet in MS Word, you will next upload this into your accessplanit platform as a ‘Document Template’.

Expand
titleCreate a sign-in sheet Document Template
  1. Open the ‘Administration’ menu from the Profile options at the top-right of your platform

    administration option

  2. Open the ‘Document Templates’ menu option to access the page where you can add and edit Document Templates such as certificates and sign-in sheets

    Document Templates menu option

  3. Click the ‘Add Document Template’ button to open the pop-up window where you can create a new Document Template

    Add Document Template button

  4. From the 'Add Document Template' window, complete the form to upload your sign-in sheet template

    1. Select your Training Provider from the ‘Account’ select option

    2. Provide a name for your Document Template, such as ‘Course Sign-In Sheet’

    3. Optional: Provide a description for your document to inform your team what it is for

    4. Make sure the ‘Active’ checkbox is checked

    5. Leave the ‘Keep original document type when emailed’ option unchecked, this will mean that if you email your sign-in sheet it will be sent in a PDF format so your Trainers cannot edit it easily, if you check the ‘Keep original document type when emailed’ option then the sign-in sheet will be sent in a Word format, which means your Trainers will be able to edit this

    6. Upload your file

    7. Leave the ‘Applies to’ option selected as ‘Course’ and the ‘Details Used’ option selected as ‘Delegate’

      image-20240204-155059.png
  5. Click ‘Save & Close’ to finish creating your Document Template

    image-20240213-085514.png

🧪 Test the sign-in sheet

Before you move onto generating the sign-in sheet for any of your Courses, first test that the sign-in sheet generates as you are expecting

Expand
titleTest the sign-in sheet
  1. From the Document Templates DataGrid, right-click your sign-in sheet Document Template to view the context menu options

    Course sign in sheet document template selected

  2. Click the ‘Edit’ option to view to the Document Template’s Details

    Edit option highlighted

  3. Click the ‘Preview’ button at the bottom of the form to open the Document Generator window

    preview button

  4. From the Document Generator window, use the ‘Delegate IDs’ selector to select one or more Delegates that are registered onto the same Course

    3 Delegates selected to generate a sign in sheet

  5. Click the ‘Generate' button to download a copy of the sign-in sheet for these Delegates. This will download a copy of the Sign-In sheet and save it to your 'Downloads’ file within File Explorer

    generate button


  6. Review the generated sign-in sheet to check that the correct information is included, no information is missing, and everything is formatted as you expect

    previewing the sign in sheet for the three delegates

  7. If you need to make any changes to your sign-in sheet, you can make these on your Microsoft Word document and save your changes, then update the file that is linked to your Document Template by using the ‘Upload New File’ option when editing your Document Template

    upload new file option when editing a Document Template

🖇️ Optional: Assign your sign-in sheet to your Course Templates

Panel
panelIconIdc64be934-3e6f-431d-8f81-7b6fb0382adf
panelIcon:accessplanit_logo:
panelIconText:accessplanit_logo:
bgColor#DEEBFF

If you have created your own sign-in sheet in the last step, to prevent the standard accessplanit sign-in sheet being used, you will need to link your sign-in sheet Document Template to the relevant Course Templates.

Expand
titleAssign your sign-in sheet to your Course Templates
  1. Open your ‘Course Templates’ DataGrid from your main menu on the left

    Course Templates main menu option

  2. Find the Course Template that you would like to assign your sign-in sheet to by applying filters and/or searching the Course Templates DataGrid

    using the search in the Course Templates DataGrid

  3. Right-click on this Course Template in the DataGrid, this will show you the context menu options for this Course Template and click on the 'Edit' option

    edit option selected on the context menu options

  4. Scroll down to the ‘Document Templates’ section on the page

    Document Template options when editing a Course Template

  5. Use the ‘Select’ button on the ‘Sign in Form’ option to assign your sign-in sheet to your Course Template

    course sign in sheet assigned to the Course Template

  6. Click ‘Save’ at the top of the page to apply your changes

    save button

Tip

Top Tip!

To save time, a member of the accessplanit team will be able to arrange for all of your Course Templates to have the same sign-in sheet Document Template assigned (in bulk). Please get in touch with us if this would be helpful for you.


🔄 Generate a sign-in sheet

Panel
panelIconId17657261-765d-4027-b044-d86a9501c52f
panelIcon:accessplaniticon:
panelIconText:accessplaniticon:
bgColor#DEEBFF

This step will take you through the steps to generate a sign-in sheet for a Course

Expand
titleGenerate a sign-in sheet
  1. From the Main Navigation menu go to Courses>Class or Course>Web

    Main Navigation Menu - Course class or web
  2. Find your Course by applying filters and/or searching for the Course ID you wish to generate the sign-in sheet for

    Course Datagrid
  3. Right-click the Course and select ‘Generate Sign-In Sheet’ from the context menu.

    Context menu - Generate Sign in sheet option
  4. This will automatically download the Sign In Sheet within your browser and will be available within your ‘Downloads’ file within the File Explorer

    Document download within web browser

  5. Review the generated sign-in sheet to check that the correct information is included, no information is missing, and everything is formatted as you expect

    Sign in sheet generated

    Your sign-in sheet is ready to go