Struggling to see a concise formula for this, but you could use a script. Something like this:
with script:
let table = base.getTable('Table')
let query = await table.selectRecordsAsync()
for(let record of query.records) {
let array = []
if(record.getCellValue('Tag1')) {
array.push(record.getCellValue('Tag1'))
}
if(record.getCellValue('Tag2')) {
array.push(record.getCellValue('Tag2'))
}
if(record.getCellValue('Tag3')) {
array.push(record.getCellValue('Tag3'))
}
let result = array.join()
await table.updateRecordAsync(record, {
'Result': result
})
}
The script is a bit rough, could do with some polishing, but you can see where it is going. Running the script won’t be a real time thing of course, so this could be a problem for your use case. Also possible that you could run this script in an automation when the record is updated (so running it on one record at a time).
