Countall issue

Bika.ai discussions
1

When I retrieve data connected via a link using lookup and apply the arrayunique function, it does not execute.

2026-03-06_09-57-17
2026-03-06_09-57-17393×656 28.3 KB

2026-03-06_09-57-31
2026-03-06_09-57-31561×480 24.2 KB

So I call that field separately with another function and then apply arrayunique, but when I use the countall function, it does not return the correct value.

2026-03-06_09-58-02
2026-03-06_09-58-02580×518 29.7 KB

Instead of counting the number of values separated by “,”, it recognizes the entire field value as one item.

The same result occurs even when using count, counta, and countall.

Please check this issue.

Additionally, please also check the newly added details regarding the error: “Field ‘{name}’ is required.”

2

@Headchef.Yang Thank you for bringing this to our attention! After testing, we confirmed that this is a parsing bug with the formula engine when handling text-based Lookup fields. The system is misinterpreting the comma-separated array as a single text value, which breaks ARRAYUNIQUE and forces the counting functions to return 1.

I have submitted an internal ticket for our developers to resolve this type conversion issue. We are on it, and I will keep you updated on the progress!