I have a Parent Phonenumber table and a child Callhistory table. I would like to get the latest comment for the phone number from Callhistory table. Is it possible to get the max of record id for the phonenumber key using formula.
Question
Max of Record Id using Formula Query
+6
+22I suggest making a summary field on the left side of the relationship to summarize the Maximum of the [Record ID#] field. The look that up down to the Call History table.
The make a new Combined text summary field of the [Comments] field in subject to the filter that the [Record ID#]. Now you have the most recent comment up on the parent phone number table, but it is going to have a strange bubble appearance. If you want that to appear more normally then create a new formula field like this.
ToText([Combined text comments])
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.