Skip to main content
Question

trying to summarise rows in the same table

  • August 11, 2025
  • 3 replies
  • 46 views
M
Forum|alt.badge.img+5

trying to store latest revision on a HEADER record from multiple rows (each with an ascending revision) in the same table. The first row far right on HDR should be the max of 4 shown below. currently says 0.

Have two views - HEADERS ONLY and REVS ONLY - so created a link to another record to use rollup.

When there is a new revision in the REVS ONLY VIEW - I try to fire an automation that detects the new rev, and automatically copies the ME35 number into the field I use for the link….

 
argghh

argghh…..does not want to work !!!! Ideas ???

 

Many Thanks    Mike

 

    3 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hm, could you create a simplified example base as well as step by step examples of input and output?  Would love to help but don’t understand the workflow well enough, sorry!

    Adam, Airtable Consultant - thetimesaving.company
    M
    Forum|alt.badge.img+5
    • MikeMitch
    • Author
    • Participating Frequently
    • 9 replies
    • August 12, 2025

     

    Hi Adam….here is the problem ...what I want to do is get the max of REV on rows 2-6 and maintain the highest automatically in either REV on row 1 (HDR) - or - in LATEST CHANGE ORDER on row 1.

    I did a link back to this table itself in BUY on a VIEW called HEADERS ONLY.

    here is the rollup on LATEST CHANGE ORDER

     

    it does not work….and if it did….then I have to build an automation to place a copy of ID into BUY every time someone adds a new REV (the users will not do it) using a when record enters a view (CHANGE ORDERS)….and that does not work either….HMMM…..

     

    ANY HELP GRATEFULLY RECEIVED !!!!   MIKE

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hmm..how do records get created in this table?  Are all the records that get created going to be REV records?

    Wondering whether you might be better served with a table for ‘Header’ type records and another table with ‘Rev’ type, and then linking the two together and getting the latest revision via a Count field and instead

    Adam, Airtable Consultant - thetimesaving.company


    Terms & ConditionsAccessibility statement