How to get details out of the last Whatever

Описание: A core technique to know when working with AppSheet, is how to get details from the "last" [Related Whatever] record.
Maybe you want to know the "last date" something happened
Or maybe "who was the last person to clock in on site"

There's a ton of scenarios where you need/want to know the last whatever for something - and then from that, you want to know further derivative information:
What was the DATE of the last timelog
What is the STATUS of the last service record

-----------------------------------------------------------------------------------------------------------------------
THE KEY

You need to extract out of the [Related Whatevers] the last item;
From this you can then get any derivative details you need

Sample App |--------------------------------------------------------------------------------------------------
https://www.appsheet.com/templates/Ho...

-----------------------------------------------------------------------------------------------------------------------

Help support the channel, donate through the link below!
https://streamlabs.com/multitechvisions


Table of Contents |----------------------------------------------------------------------------------------
0:00 Intro
0:54 Scenario Breakdown
1:41 How to get the "last" [Related Whatever]
2:39 Building: [User_Last_Timelog]
3:48 Why put the TRUE element in your OrderBy?
5:23 Why make the [Last_Whatever] column a soft-reference?
6:40 How to get specific details from the last record?
8:18 Checking that things work
8:54 Ending

-----------------------------------------------------------------------------------------------------------------------

/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Schedule a 1-on-1
// https://calendly.com/multitechvisions...
//
// Patreon
//   / multitech  
//
// Merch
// https://multitech-merch.creator-sprin...
//
/////////////////////////////////////////////////////////////////////////

For more information about MultiTech Visions, visit
www.MultiTechVisions.com

#CitizenDeveloper #AppSheet