Remove values from ENUMLIST previously added in a record

[Eduardo_Alvarez]

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!

[Steve]

Use list subtraction.

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

[Eduardo_Alvarez]

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

[Eduardo_Alvarez]

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