Select a checkbox based on dropdown value - caluclated value vs script

[roattw]

Have tried most of the suggested methods (both calculated value and javascript) but none worked, still having issues so it must be something unique to my setup.

New record entry/ Insert Record.

Have text field set as dropdown  = [@field:Role]  (Resident, Faculty, Fellow)

Have a checkbox set as Yes/No = [@field:Alumni]

If Role dropdown = "Resident" I need Alumni to be checked.  If not Resident, left unchecked.

I was getting invalid SQL orf ther Incompatible data type, text but needs to be Yes/No.

The bottom formula worked using the CAST function, however if not Resident it remains as No where I really need a check box because dropdown could = Faculty and need to be ALumni.

Possibly wrong original approach using Yes/No field?

Thanks all.

[GoodBoy]

Hello! Perhaps you can just add new conditions in your CASE statement. For example: 

CASE WHEN [@field:Role] = "Resident" THEN CAST(1 AS BIT) 

WHEN [@field:Role] = "Faculty" THEN CAST(1 AS BIT) 

ELSE CAST(0 AS BIT)

END

 

[roattw]

Thanks for the reply.  That didnt work because someone could be Faculty, but not alumni.  So Faculty could = No (unchecked)

[GoodBoy]

Oh. Please elaborate your whole workflow and also the expected results. 

[futurist]

Hi @roattw,

Are you using a Submission Form? If so, can you try the following:

1. Edit your DataPage and go to Configure Fields

2. Add a HEader and Footer. Select Footer and disable the HTML editor and paste the following:

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    const selectElement = document.querySelector('#InsertRecordRole');

selectElement.addEventListener('change', (event) => {
if(selectElement.value == "Resident"){
document.querySelector("#InsertRecordAlumni").checked = true;
}else{
document.querySelector("#InsertRecordAlumni").checked = false;
}
});

});
</script>

 

If you're using an Update Form or a Details Page, simply replace all instances of "InsertRecord" with "UpdateRecord"

[roattw]

On 10/11/2022 at 5:20 PM, futurist said:

Hi @roattw,

Are you using a Submission Form? If so, can you try the following:

1. Edit your DataPage and go to Configure Fields

2. Add a HEader and Footer. Select Footer and disable the HTML editor and paste the following:

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    const selectElement = document.querySelector('#InsertRecordRole');

selectElement.addEventListener('change', (event) => {
if(selectElement.value == "Resident"){
document.querySelector("#InsertRecordAlumni").checked = true;
}else{
document.querySelector("#InsertRecordAlumni").checked = false;
}
});

});
</script>

 

If you're using an Update Form or a Details Page, simply replace all instances of "InsertRecord" with "UpdateRecord"

This did seem to work and was on a submission page. Thank you.

It did however affect one of my rules, possibly due to how the script is listensing and interpreting a change.  The rule seems to run fine  if I manually check Alumni box, but not if its checked by then script running.  This Rule hides the field "Graduation Year" if Alumni not checked.  So when alumni checked,  Graduation Year field shown.   This Rule works without the script in place. 

No script: Alumni checked = Grad Year shown:

With script: Alumni checked = grad year not shown (Rule not run):

Interestingly, if I manually uncheck the script-applied checknox then recheck it manually the Grad YEar appears (Rulke run).  So rule runs with manual box check, but not with scripted box check.