Help

Need help with formula

1438 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Patricio_Suarez
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to be able to filter records and have the record numbers all concatenated into a single, comma-delimited, field. Possible?. I have tried ARRAYJOIN and CONCATENATE. Want to be able to copy all the filtered record numbers as a comma delimited text to be able to paste onto another program.

Screen Shot 2019-08-01 at 2.45.34 PM.jpg

4 Replies 4

Hi @Patricio_Suarez - you can only concatenate fields within a record, not the same field across records. However, there is a way to do this.

Create a new table with a single record:

55

Here I’ve used a dot/period as the ID, but it could be anything.

In your original table, link all records to the new table dot record:

Screenshot 2019-08-02 at 01.48.03.png

Back in the link table, you can see all of the records IDs in a single field:

Screenshot 2019-08-02 at 01.49.17.png

You can transform these into a comma-separated list using the formula:

ARRAYJOIN({Table 3})

JB

Patricio_Suarez
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much for your help. Just tried your method and it works but I cannot only get filtered results to be passed onto the second table.

Want to be able to filter records:

Screen Shot 2019-08-01 at 9.15.11 PM.jpg

and have only the record numbers from the filtered records go to the other table

Screen Shot 2019-08-01 at 9.15.50 PM.png

I am limiting the records to be selected to a single view and I am filtering the content of that view.

Am I doing something wrong?

Incredibly grateful for your help.

You’re not doing anything wrong. Unfortunately rollup fields don’t recognize filters. They operate on all records in a table, filtered or not. That said, you can still get what you want.

Add a formula field named {Sold Records} to your main table, using the following formula (changing the names to match your fields as needed):

IF(Sold, {Record No.})

32%20PM

In the link table, add a rollup field:

Screen Shot 2019-08-01 at 9.11.32 PM.png

The ARRAYCOMPACT(values) aggregation function will strip out the blank records, leaving only those with record numbers present.

49%20PM

Patricio_Suarez
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much. This worked. Very obscure way to do something that, seems to me, should be something easy to do.

I guess I have to use IF(SEARCH PARAMETER, {Record No.}) to get record numbers out of Airtable. I am also experimenting with copying the numbers directly from the Records No. column and reformatting them somehow to display as comma delimited text. They export with a return carriage between numbers.