FInd Max Date for When Field Value is the same but record # is different

Question

Hello,I have a table that represents the same logic as below:
Record ID |&nbsp; Name | Date
1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Fred&nbsp; &nbsp; | 12/1/20
2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Fred&nbsp; &nbsp; | 12/2/21
3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Joe&nbsp; &nbsp; &nbsp; | 6/7/19
4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Joe&nbsp; &nbsp; &nbsp; | 8/16/21
5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Sam&nbsp; &nbsp; |&nbsp; 2/7/20
I need some way to summarize the Maximum date when the name field is the same. I want another column that would populate a field in all columns containing "Fred" with 12/2/21, Freds Max date. So it would look like below:
Record ID |&nbsp; Name | Date&nbsp; &nbsp; &nbsp; &nbsp; | Max Date
1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Fred&nbsp; &nbsp; | 12/1/20&nbsp; | 12/2/21
2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Fred&nbsp; &nbsp; | 12/2/21&nbsp; |&nbsp; 12/2/21
3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Joe&nbsp; &nbsp; &nbsp; | 6/7/19&nbsp; &nbsp; | 8/16/21
4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Joe&nbsp; &nbsp; &nbsp; | 8/16/21&nbsp; | 8/16/21
5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Sam&nbsp; &nbsp; |&nbsp; 2/7/20&nbsp; &nbsp; | 2/7/20

------------------------------Mackenzie Phillips------------------------------

markshnier__you · Answer

The only way to do that negatively is to have a table of names where there is a relationship where one name has many detail records. Then you would be able to summarize the maximum date.

You can make a table of the unique value for names using a summary report and then copying those records to another table, but the question will be how will you maintain the table of unique names going forward. There are different automated approaches to this------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

FInd Max Date for When Field Value is the same but record # is different

Related Content

Same reference field, different selections within the form

Using Grid Edit to Edit Multiple Records at Once

Record Details

Consolidate Field Types

Button to Add Record via Pipeline, and refresh Record