Rollup Array Concatenation

[Brian_Schuster]

I’m setting up a rollup field to concatenate record IDs for general items that match a set of filters. There is a form input box to accept plain text, but it does not accept column names or cells as inputs. Is there a way to make it do that similar to a formula?

[Brian_Schuster]

I’m not making an API-driven tool. FilterByFormula is not working with multiple inputs. That’s why I’m trying to get rollup filters to work with dynamic field inputs.

[Justin_Barrett]

Brian_Schuster:

I’m not making an API-driven tool.

In your other thread, you opened with:

I am working on an app that uses the Airtable API to upload and download data

That to me is an API-driven tool. You’re writing code that uses the Airtable API to access Airtable’s data.

[Brian_Schuster]

It’s a different company called Adalo. They handle the API coding and I insert the filterByFormula formulas.

[Justin_Barrett]

Ahhh. Okay. That would have been helpful to know earlier in this discussion. I’m not familiar with Adalo, so I can’t offer any specific advice on how to approach things from their end, but Adalo has come up in a few other discussions in the forum. You might search for those threads and connect with other Adalo-Airtable users to see if they’ve got any ideas that will help.

[Brian_Schuster]

Yeah, I’m definitely talking to the Adalo team and users in their forum, but this relates exclusively to Airtable for now.

It never hurts to have data filtering, especially for a software as promising as Airtable.

Dynamic Rollup Filters Development and integrations

I understand. It’s just that it is an essential feature for the data behind modern web and mobile apps. Here’s what I shared via the support ticket system: “Hi, I posted in the forum about a couple issues. The filterByFormula function is not accepting filters that use AND() for multiple fields. I thought I could work around it with a rollup within Airtable, but that currently only accepts static inputs with those data filters. If I could enter something in the format of {field name here} for t…

[Justin_Barrett]

Brian_Schuster:

It never hurts to have data filtering, especially for a software as promising as Airtable.

I agree 100%. There are lots of ways that Airtable can improve on that front. It’s just difficult to say how quickly those improvements will come along.

[Brian_Schuster]

Soon, I hope! I really want to use Airtable to get my app off the ground.