Hi everyone. I'm facing an issue with my app, let me explain :
Basically, i have a form :
I'm trying to show the user the list of entries of others rows based on his selection, like this:
My only criteria is this one.
This is the table i use for the form :
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 :
Any suggestion is welcomed !
Solved! Go to 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
))
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
))
User | Count |
---|---|
18 | |
13 | |
8 | |
4 | |
2 |