Skip to main content

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)
 

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

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

 

​@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 !!

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

Reply


Terms & Conditions