Answered

Make DataCard required/visible based on inputs of another DataCard

(1) Share

Report

Posted on by max.030

Hello, I am currently trying to create an Form that needs to make an DataField appear if specific values are being choosen (see Screenshot 1).

To be precise, 3 out of 11 Values (Screenshot 2) need to trigger the DataField "Alternative Supplier" as visible. The catch is that a multiple selection must be possible within the DataField "Material Category".

This means that as soon as one of the three relevant material categories is being choosen, the "Alternative Supplier" field must be triggered.

I only used

If(DataCardValue113.Selected.Value="Yes";true;false)

so far. This worked out for me since all of the fields only used a "yes" or "no". I never needed to include more than one condition.*

I need something like:

If("Material Category".Selected.Value="A201 or A314 or D506";true;false)

Can you support me somehow?

Thanks in advance. 

*edit: The example I showed has been added to the "visibility" field of the respective DataCard I want to make in/visibile.

Categories:

General Questions

Screenshot1.png

Screenshot2.png

All responses (7)

Answers (1)

AmínAA 1,084 Super User 2025 Season 1 on at

Like (1)

Report

Make DataCard required/visible based on inputs of another DataCard

You're welcome max.030!

Every step forward, no matter small or huge, is progress. Keep it up!
max.030 10 on at

Like (2)

Report

Make DataCard required/visible based on inputs of another DataCard

This worked for me! It may be a small step for you, but a huge one for me. Thank you!
Verified answer

AmínAA 1,084 Super User 2025 Season 1 on at

Like (1)

Report
Make DataCard required/visible based on inputs of another DataCard

Sure thing, something like this should be able to accomplish that without any problems!

If( CountIf( DataCardValue113.SelectedItems; Or( Value = "A201"; Value = "A314"; Value = "D506" ) ) > 0; true; false )
max.030 10 on at

Like (1)

Report
Make DataCard required/visible based on inputs of another DataCard

It now makes the field visible whenever at least one of the 3 Numbers is being choosen.

The problem is, whenever you choose a different number than one of the three, the field is unvisible again. I get the logic why this happens, but no chance to translate it into code. Any idea how this could be approached?

If( Or( DataCardValue113.Selected.Value = "A201"; DataCardValue113.Selected.Value = "A314"; DataCardValue113.Selected.Value = "D506" ); true; false )
AmínAA 1,084 Super User 2025 Season 1 on at

Like (1)

Report

Make DataCard required/visible based on inputs of another DataCard

Hi there Max.030!

The error is pretty simple I forgot to change the commas for semicolons just switch the "," of your code with ";". That should do the trick!
max.030 10 on at

Like (2)

Report

Make DataCard required/visible based on inputs of another DataCard

Hey @AmínAA,

damn, you are quick! Thank you! It is indeed very basic, unfortunately I am not an expert and need to work mostly with youtube tutorials and this forum that already helped me a lot.

That being said, I tried to implement what you just posted by it tells me that seemingly somewhere is a mistake.

Any idea what the issue could be?
Suggested answer

AmínAA 1,084 Super User 2025 Season 1 on at

Like (2)

Report
Make DataCard required/visible based on inputs of another DataCard

Greetings!

Well, you can certainly try something like the following!

If( Or( DataCardValue113.Selected.Value = "A201", DataCardValue113.Selected.Value = "A314", DataCardValue113.Selected.Value = "D506" ); true; false )

It's pretty much basic, but that should suffice for you . . .

Hopefully that's enough to solve your problem, if so, feel free to mark this reply as an answer, otherwise feel free to reply!