How to get related text field from Rollup field

[Kosta_Kondraten]

Hi,

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!

Then it would be a fully awesome CRM!

Thank you!

[Williams_Innova]

Hi @Kosta_Kondratenko,

I believe you can achieve the first method for the notes by using a roll up field with the same condition as the date, meaning get the latest notes.

As for compiling them, it would take a script to do that.

If you would like, I would be happy to discuss this further with you on a call, as I would like to ask about your base structure, if you don’t mind.

If you are up to it, feel free to schedule a call here to discuss further.

Thanks,
Chris

[ScottWorld]

Kosta_Kondratenko:

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.

Yes, this is possible. Check out some of my recent posts on this topic below:

Display Last Comment Automations

Welcome to the community, @David_Short! I’m assuming you’ve already created a linked record field between your two tables, so you can link multiple issues to each individual asset? After that, Airtable makes the rest of the setup process unnecessarily complex: First, you have to create a rollup field in your Assets table that points to the Date field in your Issues table. Use the formula MAX(values) Then you have to go back into your Issues table and create a lookup field that looks up the r…

Calculated field in view from latest linked record? Views

Welcome to the community, @Les_Gray! This is pretty tricky to setup in Airtable. I’m assuming that your “owners” table is linked to the “valuations” table, so each owner can be linked to many different valuations. First, you’ll need to go into the valuations table, and you will need to create some sort of a date field so you can determine which valuation is the latest valuation. Then, go back into your owners table and create a Rollup field which points to that date field in your valuations …

Current record based on a date in a group Formulas

Even though this would be a piece of cake in any other database platform, Airtable doesn’t make this process very easy nor intuitive. It is QUITE the process. Solving this will require creating 3 additional fields: 2 new fields in the Certification table (a lookup field and a formula field), and 1 new field in the Client table (a lookup field). Here’s what you’ll need to do: First, you’ll need to go back into your Certification table, and create a lookup field that looks up the new rollup f…

Select the top record on a specific view Views

This is a little bit tricky to setup in Airtable. First, you’ll need to go to the “Seller Details” table in your Airtable base, and you will need to create a Rollup field which points to your “Created Date” field in your “Artwork Bids” table. Use the rollup formula MAX(values), which will give you the latest bid date for that particular item. Next, go back into your “Artwork Bids” table, where you will want to create a lookup field that looks up that brand new rollup field that you just create…

[kuovonne]

I use a formula field in the Communiques table to summarize the info for the record. Then I rollup that field.

Kosta_Kondratenko:

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:

My Sort Linked Records Automatically automation script is designed to do exactly this.

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.

[Kosta_Kondraten]

Display Last Comment

lready created a linked record field between your two tables, so you can link multiple issues to each individual asset? After that, Airtable makes the rest of the setup process unnecessarily complex

Thank you! I will investigate and it seems like your solutions have given me a potential way forward on this issue. Chrs

[ScottWorld]

I also covered this topic in depth on today’s BuiltOnAir video podcast: