Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 27, 2019 09:04 AM
Simple version (so you can cut and paste, and put to use)
Link to demo base:TestLab Status
Explore the "TestLab Status" base on Airtable.
Table 1:
Latest Status
LEFT(
RIGHT(status_&"",
LEN(status_&"")
-FIND({Last Updated}&"",status_&"")-23
),
FIND({Last Updated}&"",
RIGHT(status_&"",LEN(status_&"")
-FIND({Last Updated}&"",status_&"")-23)
)-1
)
Last Updated is just pulling the latest date for the linked records in Status Update Records.
TheStatus_ is looking up all of the status-helpers for the linked records so they can be searched through by the Latest Status formula.
Table 2:
Helper-status field is simply
{Status Date}&Status&{Status Date}
Its easy enough to repeat for multiple fields, I recommend using notepadd++ to copy the Latest Status formula to find&replace old field name the new one.
.
.
.
.
Detailed Version
broken down version (forgive the slight differences in naming convnetions)
Scenario: At my work, we have a test lab (think 25 test machines, that test our product). Each morning, the technicians each write an email to the lab manager with status updates for their respective machines and he sorts through and adds status updates into up-time metrics for the lab.
My desired output: A summary table that requires no interaction on the part of the lab manager.
Structure: 2 tables, Summary table with list of the test machines, Status-Updates table with status update records that will get fed up to the summary such that only info from the most recent record is in the Summary table for a given machine.
The work-around steps:
Steps to implement:
in summary table,
I welcome any feedback on how to improve this - as I wrote this I realized (depending on the contents of the status field) there may be a better way to do this with an auto-number field (or formula & auto-number) instead of using the date as the unique value if you have no numbers in the value you are trying to extract.
Obviously, the number of formula fields can be reduced, but its broken out for explanatory purposes.
Feb 05, 2021 01:47 PM
hey there, i “think” this might be able to help me.
but the test lab link is private, any chance you can repost of make public?
thanks
Feb 05, 2021 01:55 PM
I think I get it, but completely confused how to make this work for me.
Ive a really simple need.
Table 1 is members.
Table 2 is a linked to MEMBERS, and is them “checking in” with X number of guests.
I want to pull through the number of guesst they checked in, from the latest record.
I can show ALL the guests they have ever checked in easily…
In the image above, the first time they checked in they had 5 guests,
the second time (on 25th Feb) they had 31.
I just want to show the latest value, and I feel your solution can do that.
Maybe i’ve just been working on this too long and my heads gone,but if you can help that would be epic.
Thanks
Dee
Feb 05, 2021 02:53 PM
SOLVED
So i got my solution :slightly_smiling_face:
On this thread
Thanks