I have a rollup field for ‘Last Contact Date’ to fetch the most recent Communiques (which is my unique name for Contact Points) date and display it in my Contacts table.
So far so good.
Now - here is the challenge.
For the sake of convenience I just thought it’d be cool to display the related text for that particular field in another field - like “Last Contact Notes” - this would give me a quick refresher on that contact if I was going to call them again.
Just an idea.
And wondering if it’s possible?
I made a video to clarify:
And… something that will make me absolutely jump for the moon is if it were possible to have a field that would pull the notes from my Communiques table and arrange them by date as so:
14/7/21 - CALL
Spoke to Bob - he said he’ll get Amy to call me back.
18/6/21 - CALL
Spoke to Bob - he said Michael will have to approve.
1/6/21 - CALL
Spoke to Bob - he said Cartright will have to review.
Does that make sense? Because right now I have to open up every related field to see what’s inside it - and having that text field populated so I can just scroll from top to bottom would be a godsend - I’m guessing it would perhaps require some kind of script - but I’m game to try!
Note that the automation script will only sort linked records going forward. To sort existing linked records, my Sort Linked Records app is currently in review for the Airtable marketplace and currently available only with a custom install.