Noticed multiple instances when in some cases Adalo successfully pulls a number from an external AirTable collection as a magic text and in some cases (even though the setup is the same) - it doesn’t.
Investigation Steps & Results:
• Noticed Adalo successfully pulls “Count” or “Number” field values from AirTable but does not pull values of a “Rollup” field
•Tried solving by pushing the Rollup value into a “Formula” field and using this value in Adalo. Didn’t help.
• Then tried processing the value in various ways within formula field (with ROUND(), INT(), to a text value with CONCATENATE() & LEFT() and then back to a numeric value with ABS() etc. etc.). Nothing helps.
Why? What’s happening here? Is this a BUG?
I understand Adalo may not manage to pull number from a Rollup as it’s an array… but I convert that array function result into a value within a formula field. Why this doesn’t help?
Thought that Adalo may also struggle pulling a number from a “Formula” field… but this should not be the case as it successfully pulls numbers from “Formula” fields in other cases.