Showing inside the form the Enum list based on user selection

Hi everyone. I'm facing an issue with my app, let me explain :

Basically, i have a form :

GFormMLH_0-1660485801428.png

I'm trying to show the user the list of entries of others rows based on his selection, like this: 

GFormMLH_5-1660486337623.png

 

My only criteria is this one. 

This is the table i use for the form :

GFormMLH_1-1660485890966.png

GFormMLH_2-1660485922417.png

As you can see, I want to show the list of entries with the virtual column "Report_OutputDisplay" which is a list of ref referenced to my "Report_OutputList" column.

This is the formula I use to select the values :

 

select(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :],


  in(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :] , [_THISROW].[Report_CODE CHANTIER (voir sur le plan de contrôle) :]),true

)

 

 And that's my table where the values are located :

GFormMLH_4-1660486221789.png

GFormMLH_3-1660486201361.png

Any suggestion is welcomed ! 

Solved Solved
0 1 142
1 ACCEPTED SOLUTION

Finally managed to fix it 😭

I added "if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), " in my formula.

Final :

select(QUAL FORM 02[ControleID],

if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), 
  in(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :] , [_THISROW].[Report_CODE CHANTIER (voir sur le plan de contrôle) :]),true

))

 

View solution in original post

1 REPLY 1

Finally managed to fix it 😭

I added "if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), " in my formula.

Final :

select(QUAL FORM 02[ControleID],

if(isnotblank([Report_CODE CHANTIER (voir sur le plan de contrôle) :]), 
  in(QUAL FORM 02[CODE CHANTIER (voir sur le plan de contrôle) :] , [_THISROW].[Report_CODE CHANTIER (voir sur le plan de contrôle) :]),true

))

 

Top Labels in this Space