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