Cascading dropdown from non-editable parent field?

[aam82]

Hi, it seems that the only way to make a field available as a PARENT FIELD for a cascading dropdown, is to make that field editable; otherwise, that field is not an option.

I need to filter a dropdown according to a field that I can't allow to be edited. This is what I need on a Bulk Edit on a report:

• field type: cascading dropdown
• filter by: parent field
• parent field type: display only

Has anyone run into this before? Any ideas? Thanks

[JEllington]

I have experienced this problem before. The field (as you pointed out) needs to be editable for CB to be able to work with the field. The work around I used was to make the field editable, then hide it from displaying.

Put the parent field you would like to be hidden between two HTML Blocks.
Then in the first HTML Block insert <table style="display:none;">
then close the HTML table tag in the following HTML block </table>.
This allows CB to perform operations on the parent field and hides it from displaying on the datapage.

[aam82]

Thanks, I can probably live with that!

[MayMusic]

If you want to show the parent value you can add HTML Block or virtual field and select the field there

[aam82]

Thanks!

[KlisaN137]

On 7/26/2016 at 4:04 PM, JEllington said:

I have experienced this problem before. The field (as you pointed out) needs to be editable for CB to be able to work with the field. The work around I used was to make the field editable, then hide it from displaying.

Put the parent field you would like to be hidden between two HTML Blocks.
Then in the first HTML Block insert <table style="display:none;">
then close the HTML table tag in the following HTML block </table>.
This allows CB to perform operations on the parent field and hides it from displaying on the datapage.

 

Alternately, if you want to show the parent field as "Display Only",  but the DataPage doesn't permit using the Virtual Field element (Bulk Edit configuration, etc), set the field to "Text Field" and add the following code to the Footer of the Page (Bulk Edit Configuration):

<script>

if(typeof parentDisplayOnlyElement  === "undefined"){
     let parentDisplayOnlyElement = document.querySelector('input[name="BulkEditProductCategory"]'); // Select the input in the element you want to be just displayed
     parentDisplayOnlyElement.disabled = true;
     parentDisplayOnlyElement.style.border = 'none';
}

</script>

 

[ianGPT]

Hello you may also use the script to make the parent field uneditable

<script>
var textField = document.querySelector("FieldNameHere");
        if (textField) {
            textField.readOnly = true; // Make the field read-only
        }
</script>