Skip to main content
Question

change-formula

  • July 4, 2025
  • 4 replies
  • 96 views
W
Forum|alt.badge.img+2

In one of my first projects, I have a table with a multiselect field "names".
Can I add a new column with some formula that shows the name that was last added or removed in the "names"-field ? (with automatic update for every change in that names-field)
 

    4 replies

    Mike_AutomaticN
    Forum|alt.badge.img+28

    Hey ​@WimDC,

    I believe this is what you are looking for. Right?
     

     
     

    TRIM(
      REGEX_EXTRACT(
        ARRAYJOIN({Names}, ", "),
        "[^,]+$"
      )
    )


    Please make sure that your names do not include “,” (commas) within them as that would cause an issue!

    Mike, Consultant @ Automatic Nation

    ScottWorld
    TheTimeSavingCo
    Forum|alt.badge.img+31

    Does this look right?  If so, I think you’ll need a script action (a paid feature, I’m afraid) and I’ve set it up here for you to check out

     

    Adam, Airtable Consultant - thetimesaving.company
    W
    Forum|alt.badge.img+2
    • WimDC
    • Author
    • New Participant
    • July 7, 2025

    ​@Mike_AutomaticN this formula seems to work only for the latest ADDED item (because it’s added at the end of the array).  But I would like to have a formula (*) that also works for the latest DELETED item.  I think I will need a script action as ​@TheTimeSavingCo suggested, but that seems to be a paid feature 😟.  

     

    (*) if necessary, it may be split in 2 new fields, one with your suggested formula for the latest ADDED item and second field with another formula for the latest DELETED item.

    Thanks both for helping !!

    TheTimeSavingCo
    Mike_AutomaticN
    Forum|alt.badge.img+28

    Sure ​@WimDC, feel free to reach out as needed! 

    Terms & ConditionsAccessibility statement