How to Hide Fields and Columns

Question

I am working with a SharePoint Online.
I am very new to SharePoint and JS in general (so I am no expert - but willing to learn).

I have created a List that contains the following fields:
A, B, C.

A , B are dropdown choices that let's say contain One, Two, Three with Three as the Default choice in B.

What I need to happen is as follows:
If A="One and B="Two" Then I want C to be visible so that I may write in an answer. Otherwise I want C to remain hidden.

To explain it another way: I have three columns (Fields) and want the third to remain hidden until the first two columns (fields) contain the value necessary to make the third visible.

Answer 1

possible duplicate of this question

You can achieve this via SPUtility.Js as stated in the answer posted in the link.

With that you can write the script as follow

​

<script src="/Shared%20Documents/jquery-1.10.2.min.js"></script>
<script src="/Shared%20Documents/sputility.min.js"></script>

<script>
// wait for the window to load
$(document).ready(function () {
    // Get a single select dropdown field
    var countryField = SPUtility.GetSPField('Country');

    // create a function to show or hide City based on Country's value
    var showOrHideField = function() {
        var countryFieldValue = countryField.GetValue();
        // Hide the City field if the selected value is Other
        if(countryFieldValue === 'Other') {
            SPUtility.HideSPField('City');
        }
        else {
            SPUtility.ShowSPField('City');
        }
    };

    // run at startup (for edit form)
    showOrHideField();

    // make sure if the user changes the value we handle it
    $(countryField.Dropdown).on('change', showOrHideField);
});
</script>

Answer 2

You need some programming skills to achieve this.

SharePoint can not do it out-of-the-box.

The usual approach was to use InfoPath for these type of (more logic) forms.

The future of InfoPath is unsure, current versions will be supported till 2023 (or about)

It is still the best tool for your requirement. Only you can weigh the investment versus the time you need programming your own solution.

The programming route requires SharePoint Designer to edit the Forms and learning jQuery (you can do without and even most SharePoint programmers do not know about SharePoint native mQuery) and SP2013 Client Side Rendering (CSR) Javascript skills.