Help

I want make an array of linked records, sort them alphabetically, then return one of the fields

Topic Labels: Formulas
184 2
cancel
Showing results for 
Search instead for 
Did you mean: 
alexordanis
4 - Data Explorer
4 - Data Explorer

Here is my base I am developing to track VFX shots for a film.

Table "SHOTS" is the shot in the film. "Submissions" is the version I get from a vendor

https://airtable.com/appfa9Uq0xYTTe5oK/shrH1DETOqdRkJUjT/tbl299qf49ykQMspW/viwjFl7u86veCddkU?blocks=...

 

Ideally I would like to be able to load all the versions in to an array then return the latest comment when I am reviewing the latest version. The array should be sorted alpha numerically. 

I have been trying with little success to use 

ARRAYSLICE(ARRAYCOMPACT(values)), -1)

 Can you do this with the formula, rollup field or do you need to script this?

2 Replies 2

The only way to do natively within Airtable would be to script it. You could also do that externally with Make's array functions, which includes a sort function, but that would probably be overkill to use an external app for that.

Hi,
I thought about script function of sorting links and suddenly realized you can easily sort it by hand.
Suppose Shot code in Shots is unique primary field.
In 'Submissions' table add temporary single text field and copy 'Shot code' field there. Now select 'Shot code' field and clear it pressing del. Sort table by 'Submission Name' and copy all temporary field values into linked field 'Shot code'. Links will be added according to their order during copy-paste, and therefore will be alphabetically ordered. Afterwards, remove temporary table.