I have a table setup where one of the columns has a filter formula. In the Honeycode UI, each cell in this column has a filter icon and the number of results returned by the filter formula. Clicking on the cell opens a 'filtered view" where I can see the rows associated with the filter. So far, so good.
When I access this table via the Honeycode API, cells within the column with the filter formula only have the number of filtered records. This is true for both the formattedValue and the rawValue.
My question is twofold:
- Is there a way to do what I am describing above? Am I just missing something obvious?
- How can a cell of format ROWSET be created in the Honeycode UI?