Hello!
I’m working on an AppSheet application and I’m facing a challenge related to an EnumList field called “Resultado esperado” (Expected Result). This field should allow the selection of multiple evaluation criteria from a list of criteria registered in the “IND_criteriosEvaluación” table.
The difficulty lies in the fact that some evaluation criteria contain commas in their text, which affects the functionality of the field. When using a formula to filter valid criteria based on specific conditions, the dropdown list breaks apart and displays elements separately instead of showing them as a single criterion (See image bellow).
Key requirements:
- The “Resultado esperado” field should allow the multiple selection of criteria.
- The list of criteria should be based on specific conditions, including the exclusion of criteria present in the “Resultado alcanzado” (Achieved Result) field of the “IND_LogrosMetasPeriodo_Cuali” table for a particular category and level.
- Some evaluation criteria have commas in their text, causing issues when displaying them in the dropdown list.
Currently used this expression:
IF(
AND(
[ID Categoría].[¿Evaluación cualitativa?] = "Si",
[ID Categoría].[¿Dependiente o nivel?] = "Si"
),
SELECT(
IND_criteriosEvaluación[Criterio],
AND(
[ID Categoría] = [_THISROW].[ID Categoría],
NOT(
IN(
[Criterio],
SELECT(
IND_LogrosMetasPeriodo_Cuali[Resultado alcanzado],
AND(
[ID Categoría] = [_THISROW].[ID Categoría],
[_THISROW].[ID Nivel] = [ID Nivel]
)
)
)
)
)
),
{}
)
Request for assistance:
I’m seeking a solution that allows me to filter and display a list of valid criteria in the “Resultado esperado” field in AppSheet, considering the conditions mentioned above. It’s important that the solution prevents criteria with commas in their text from being separated in the dropdown list, especially when editing a previously saved “Resultado esperado.”
Is there any specific formula, function, or approach I can use in AppSheet to address this problem and ensure an intact list of criteria in the EnumList field?
I greatly appreciate any guidance or suggestions.
Thank you in advance for your assistance!
