Hi,
I would like to default a choice field based on another choice field.
So question 1 has choice A and B, If A is selected then question 2 should default to C, and if B is selected then question 2 should default to D.
I got around this before by changing the choice field to a text field and using the below code.
If(DataCardValue12.Selected.Value = "A", "C"); If(DataCardValue12.Selected.Value = "B", "D")
But this time around I can't do that.
Can you please help with the code?
Solved! Go to Solution.
@Anonymous
I missed a few commas in my original post. This will work. I've tested the code.
Put this code in the Default property of the Card.
Switch(
DataCardValue11.Selected.Value,
"Regulatory Capital", {Value: "Balance Sheet"},
"Impairments", {Value: "Income Statement"},
"Economic Capital", {Value: "Balance Sheet"},
"Non Financial", {Value: "Non Financial Risk"}
)
Make sure DefaultSelectedItems in the ComboBox has this code.
Parent.Default
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@Anonymous
I will suggest changing from an IF function to the SWITCH function but really you can use either. The reason your ComboBox is not populating is because it expects a record. To ensure we are passing a record we must put { } brackets around the value to create a record.
Put this code in the DefaultSelectedItems property of the 2nd ComboBox.
Switch(
DataCardValue12.Selected.Value,
"A", {Value: "C"}
"B", {Value: "D"}
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @mdevaney, thank you so much for replying
It doesn't seem to work for me. Can you check if I made a mistake somewhere
Switch(
DataCardValue11.Selected.Value
"Regulatory Capital", {Value: "Balance Sheet"}
"Impairments", {Value: "Income Statement"}
"Economic Capital", {Value: "Balance Sheet"}
"Non Financial", {Value: "Non Financial Risk"}
)
DataCardValue11 contains the options Regulatory Capital, etc. and I'm doing this in the Item default which has 3 choices Balance Sheet, Income statement and Non Financial risk.
Thanks for helping @mdevaney !
I added it to DefaultSelectedItems property but still no luck.
My text field does grab the expected value
@Anonymous
I missed a few commas in my original post. This will work. I've tested the code.
Put this code in the Default property of the Card.
Switch(
DataCardValue11.Selected.Value,
"Regulatory Capital", {Value: "Balance Sheet"},
"Impairments", {Value: "Income Statement"},
"Economic Capital", {Value: "Balance Sheet"},
"Non Financial", {Value: "Non Financial Risk"}
)
Make sure DefaultSelectedItems in the ComboBox has this code.
Parent.Default
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
User | Count |
---|---|
230 | |
102 | |
97 | |
57 | |
32 |
User | Count |
---|---|
282 | |
112 | |
106 | |
63 | |
63 |