I would like to write a short script/block/module that could present me with an arbitrarily generated string from my data. Namely I want to combine all names in the current’s view Name column into a single string separated by some booleans so that it can be copied.
RICE and SALT and PEPPER and WATER
I can currently do it no problem via copying the whole column to Excel but it would be more elegant/clean and a bit faster to be able to export it right from the table. Is this kind of scripting even possible with Airtable (preferably without third party tools)?
There is no scripting in Airtable at the moment (let’s hope that changes soon!!!) but there are possibilities either using the API - or my favourite option, using Integromat.
This is a tool with which you can interface stuff (like Zapier) but has more logic capabilities including the ability to loop through records and do things like aggregate text from them. I used this technique as part of the following blog post:
This uses looping through records to build up rows in a table which will become a PDF - but the principle is the same.
Also note this uses a different database - again the workings with Airtable would be nearly identical.