Forum Discussion
Sharepoint List - Add an Hours of Operations field
- Jun 30, 2023
Hi RSeepersad,
To add a column for the hours of operation in SharePoint list, you can follow these steps:
1. Go to your SharePoint site and navigate to the list where you want to add the column.
2. Click on the "Settings" (gear) icon and select "List settings" from the dropdown menu.
3. Under the "Columns" section, click on "Create column."
4. Choose a column type that suits your requirements. In this case, you can use the "Choice" column type.
5. Provide a name for the column, such as "Hours of Operation."
6. In the "Type each choice on a separate line" section, enter the available hours of operation options. For example:
- Monday 9:00 AM - 5:00 PM
- Tuesday 9:00 AM - 5:00 PM
- Wednesday 9:00 AM - 5:00 PM
- ...
7. Select the appropriate display format for the column. You can choose either "Dropdown" or "Radio buttons" based on your preference.
8. Specify any other settings for the column, such as whether multiple selections are allowed or if it's a required field.
9. Click on "OK" to save the column.Now, when users add or edit an item in the list, they will be able to select the hours of operation from the choices you provided in the column. The selected value will be stored for each item.
Note that this approach provides a predefined set of options for the hours of operation, and users can select one of them. If you need a more dynamic solution where users can enter custom hours, you might need to consider using other column types or customizations using SharePoint Framework (SPFx) or Power Apps.
Kindest regards
Leon Pavesic
Hi RSeepersad,
To add a column for the hours of operation in SharePoint list, you can follow these steps:
1. Go to your SharePoint site and navigate to the list where you want to add the column.
2. Click on the "Settings" (gear) icon and select "List settings" from the dropdown menu.
3. Under the "Columns" section, click on "Create column."
4. Choose a column type that suits your requirements. In this case, you can use the "Choice" column type.
5. Provide a name for the column, such as "Hours of Operation."
6. In the "Type each choice on a separate line" section, enter the available hours of operation options. For example:
- Monday 9:00 AM - 5:00 PM
- Tuesday 9:00 AM - 5:00 PM
- Wednesday 9:00 AM - 5:00 PM
- ...
7. Select the appropriate display format for the column. You can choose either "Dropdown" or "Radio buttons" based on your preference.
8. Specify any other settings for the column, such as whether multiple selections are allowed or if it's a required field.
9. Click on "OK" to save the column.
Now, when users add or edit an item in the list, they will be able to select the hours of operation from the choices you provided in the column. The selected value will be stored for each item.
Note that this approach provides a predefined set of options for the hours of operation, and users can select one of them. If you need a more dynamic solution where users can enter custom hours, you might need to consider using other column types or customizations using SharePoint Framework (SPFx) or Power Apps.
Kindest regards
Leon Pavesic