Filter radio button with another radio button

[RafaelISCTEEP97]

Hi guys 🙂

I need help!!

Can i filter one radio button with another radio button?

Like the image:

"Partes do objeto" set the options on "Tipos de defeito", filtering the radio buttons and showing the options linked with the first variable

thanks guys

[rubin_boer]

hi @RafaelISCTEEP97 yes you can. figure out how to filter your radio buttons first and then apply it.

As an example: 

Radio1 have following items [1,2,3,4]

Radio2 have [10,11,12,13,14]

condition: You want to show all items for Radio2 which is more than 4 times the selected Radio1 value 

Radio2 Items = Filter([10,11,12,13,14], Value > Radio1.Selected.Value * 4)

Result 

filtering all the radio buttons can be done this way. 

Hope it helps,

R

[RafaelISCTEEP97]

Hi @rubin_boer 

Thanks for the answer 🙂

In my Radio2 Itens a have:  Choices('NOTA BAY SALTO / SE BAURU'.'Tipos de defeito')

because in my app i have one list of variables

is there any way make a selection like this?

The option "Sistema de Supervisão e Monitoramento" in Radio1 give me the 3 options in Radio2: "Vazamento","Más condições de operação" and "Operação incorreta".

In this case i set the options with variables

[rubin_boer · Accepted solution]

hi  @RafaelISCTEEP97   do you have a relationship between the two choice sets somewhere, for example how is 'Tipos de defeito' related to 'Partes do objecto' ? Choices('NOTA BAY SALTO / SE BAURU'.'Tipos de defeito') is the table you need to filter.

Consider the following:

• Radio1 Items = Choices('NOTA BAY SALTO / SE BAURU'.'Partes do objeto') //these are yours
• Radio2 Items = Choices('NOTA BAY SALTO / SE BAURU'.'Tipos de defeito') //these are yours

Simulating the Choice columns as tables:

• Radio1 Items = ["Sistema de superisao e Monitoramento","Sistema ...", "Gas ...", "Olea ..."]
• Radio1 OnChange = Set(
  _CheckString,
  Switch(
  Radio1.Selected.Value,
  "Sistema de superisao e Monitoramento",
  ["Vazamento", "Mas condloes ...", "Operacao..."],
  "Gas ...",
  ["Vazamento","Componente ..."],
  ["Vazamento","Componente ...", "Mas condloes ...", "Operacao..."]
  )
  )
• Radio2 Items = Filter(["Vazamento","Componente ...", "Mas condloes ...", "Operacao..."], Value in _CheckString)

Result

will this work for you?

R

[RafaelISCTEEP97]

Thanks @rubin_boer 

This work for me 😄

[rubin_boer]

hi @RafaelISCTEEP97 its a variable being used for the evaluation. 

Consider

Set(_CheckString,
Switch(
Radio1.Selected.Value,
"Sistema de superisao e Monitoramento",
["Vazamento", "Mas condloes ...", "Operacao..."],
"Gas ...",
["Vazamento","Componente ..."],
["Vazamento","Componente ...", "Mas condloes ...", "Operacao..."]
)
)

when the radio1 (Radio1.Selected.Value) changes value it is evaluated, when it is "Sistema de superisao e Monitoramento" the set the value of _CheckString to this table ["Vazamento", "Mas condloes ...", "Operacao..."].

Every time the value changes it gives a new table value to _CheckString which you then use to filter the radio2.

Hope that helps,

R

[RafaelISCTEEP97]

@rubin_boer  Thanks!!

You are the BEST 😁

[RafaelISCTEEP97]

Hi @rubin_boer  , how r u?

I have a new question...

Can i do this same filter but using a text?

The text set the radio button 1 options, and the radio button 1 options set the radio button 2 options??

Like this (using a example with type of movies)

TEXT: MOVIE

RADIO BUTTON 1: DRAMA, ACTION, HORROR, ROMANCE

RADIO BUTTON 2: NAME OF MOVIE 1, NAME OF MOVIE 2, NAME OF MOVIE 3, ...

When a put the name of movie the option set the type of movie and returns the names

[RafaelISCTEEP97]

Forget the question above!!

When a use sharepoint list my variables like "Parte do Objeto" and "Tipo de Avaria" are set with DataCardValue9, which determines the type of equipment...

The problem is: The radio button doesnt appear =/

Can you have the solution? @rubin_boer 

[RafaelISCTEEP97]

fyi

The field "Tipo do Objeto"

have a database, i dont know if this influence in filters