Remove values from ENUMLIST previously added in a record

how to avoid to have duplicates, I have a ENUMLIST getting values from a reference table column:

SELECT(CONCEPTOS_REF[CONCEPTO], [TIPO] = [_THISROW].[TIPO])

is possible to remove from the list the values previously assigned to a record?

I have this formula where I get list of values already recorded for specific POSTE_ID:
SELECT(CONCEPTOS[CONCEPTO],[POSTE_ID]=[_THISROW].[POSTE_ID])

I only need to remove values returned by this list to the previous list and avoid user select values on this last list

rgds!

Use list subtraction.

3 Likes

thanks Steve, but how i do when record is edited?

think I solve by adding formula on suggested values instead of valid_if

SELECT(CONCEPTOS_REF[CONCEPTO], [TIPO] = [_THISROW].[TIPO]) - SPLIT(SELECT(CONCEPTOS[CONCEPTO],[POSTE_ID]=[_THISROW].[POSTE_ID]),",")

also I added the SPLIT before SELECT because this is a multiselect field

1 Like