How to create a calendar form with multiple column formatting?

Question

I am a beginner of SharePoint. I want to create a calendar form to use it as a team members out of office info, a meeting request to a manager, etc.

The form includes; Name, Title, Start/End Time and Category. Under Category, there are options such as "Out of office", "Meeting Request", "Holiday" etc.

If a member selects "Meeting Request", I want to show 4 additional columns in the form.

These 4 should be hidden until "Meeting Request" is selected from drop down list.

1. Meeting Type
2. Document Prepared By
3. Document Reported By
4. Purpose of the Meeting

Could someone please help me with column formatting code and where to add these codes?

Answer 1

This is way late, but one thing you might consider is to have two different content types for your list by adding a custom content type (intro to content types: https://support.microsoft.com/en-us/office/introduction-to-content-types-and-content-type-publishing-e1277a2e-a1e8-4473-9126-91a0647766e5).

You could have two content types, one which has the regular information and a second which has that information plus the additional four fields.

This doesn't require any programming, but you do have to design level permission for the list to add a content type (https://support.microsoft.com/en-us/office/add-a-content-type-to-a-list-or-library-917366ae-f7a2-47ad-87a5-9689a1884e60).

The downside is that there will be some training involved to have people pick the right content type when creating the original list item or when switching between content types.

Answer 2

If you are using SharePoint online modern experience, you can achieve this using conditional formulas.

You can use formula like:

=if([$Category] == 'Meeting Request', 'true', 'false')

Steps to add conditional formulas:

1. Go to the list where you want to show or hide columns in the form.

2. Open an item to view the item details in the display form OR open the new list item form.

   

3. Click on Edit form icon at the top, then select Edit columns.

   

4. Navigate to the desired column for which you want to set a conditional formula (your 4 additional columns)

5. Select the far right hand edge of the column name to display the options menu (...)

6. In the more options, select Edit conditional formula.

7. In the Edit conditional formula dialog, specify a conditional formula like above

8. When you are finished, select Save.

   

9. Repeat the same steps for all 4 columns.

Important Points:

1. Do not make 4 additional columns as required
2. In conditional formulas, you have to use internal name of your columns. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Documentation: Show or hide columns in a list or library form