Bom dia! Estou tentando usar a Função "STARTSWITH([Gaiola],"GAI-"), porém, eu queria combinar outra formula para evitar entrada duplicadas, alguém poderia me dar sugestões?
Solved! Go to Solution.
Generally , you could combine the duplicate detecting expression with STARTSWITH(), something like
AND(STARTSWITH([Cage],"GAI-") ,
ISBLANK(
FILTER(
"Table Name",
([_THIS] = [Cage])
)
- LIST([_THISROW])
)
)
The suggested expression for avoiding duplicates is in the article below at the end.
List expressions - AppSheet Help
Generally , you could combine the duplicate detecting expression with STARTSWITH(), something like
AND(STARTSWITH([Cage],"GAI-") ,
ISBLANK(
FILTER(
"Table Name",
([_THIS] = [Cage])
)
- LIST([_THISROW])
)
)
The suggested expression for avoiding duplicates is in the article below at the end.
List expressions - AppSheet Help
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |