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โฆ
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! Go to 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] )
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |