Solution : Zero fields not available in External Collection

When you connect an External Collection like Airtable, you get the first rows of the table back with the data in to be able to create the fields on the collection. The fields that are brought back are only available in Magic Text if they are not zero or blank.


So here, I can’t get at any of these fields, as the first one in my table is all zero.

And annoyingly, I have another set of fields that are also often zero. So I can’t use a sort to bring back rows that I want into the sample.

Finally hit on a solution. Create a new field, for sorting.


Now I can get any row I want into the top row of the sample, and make sure there are values in the fields.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.