Airtable Rollup Fields in Make

Features
1

I just wanted to post this here in case people have problems with this in the future.

Make has a bug when it comes to interpreting Airtable’s rollup fields.

I opened up support ticket #1575629 about this, but it seems like this will not be an easy one for Make to resolve, because it has to do with how Make’s underlying programming code works.

To summarize the problem, Airtable’s rollup fields are sort of like “chameleon fields”. They can change their field type, meaning that Airtable’s rollup fields can result in any of these field types:

  1. String
  2. Array
  3. Number
  4. Date

However, Make ONLY sees Airtable’s rollup fields as arrays, instead of properly recognizing what their ACTUAL type is.

So, for example, if your Airtable rollup field results in a string (in Airtable), Make will still think it as an array. But because it’s actually a string, if you try to use any of Make’s array functions on your string, those array functions will fail. You can use string functions, though, because it’s a string.

Similar problem with any of the other field types. As another example, if your Airtable rollup field results in a date field (in Airtable), Make will still see it as an array. You can use Date functions on it, but you can’t use Array functions on it.

I wanted to post this information here, because it took me hours to figure out what was going on! Hopefully, this will help somebody else in the future! :slight_smile:

  • ScottWorld