Filter previously selected articles from a REF list

Today I am faced with this challenge: I am building a form to audit different sectors within a company, the objective is that the person who loads the form, gives a score to the different areas of a business premises, the inconvenience or challenge What I find is that I cannot filter the sectors that were previously selected from the REF list, thus achieving that the person cannot load the same sector twice in the same form load, I have used this formula:

NOT(
IN(
[_THIS],
SELECT(
DETALLE AUDITORIAS[SECCION AUDITORIA],
AND(
[ID AUDITORIA] = [_THISROW].[ID AUDITORIA],
[SECCION AUDITORIA] = [_THISROW].[SECCION AUDITORIA]
)
)
)
)

Processing: screen-capture.webmโ€ฆ

3X_4_7_47919017548da29c05a576743f835cc10439270e.gif

but this only invalidates the sectors that have already been loaded, I want them to STOP appearing in that list, so the list is cleaner of excluded values

Solved Solved
0 4 259
1 ACCEPTED SOLUTION

Maybe something like below in the Valid_if of the [SECCION AUDITORIA] column of the DETALLE AUDITORIAS table

SECCIONES AUDITORIA[Key Column of SECCIONES AUDITORIA] -

SELECT( DETALLE AUDITORIAS[SECCION AUDITORIA], [ID AUDITORIA] = [_THISROW].[ID AUDITORIA] )

View solution in original post

4 REPLIES 4
Top Labels in this Space