Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Get the Field Name that was modified from Last_Modified_Time() instead of time output?

Topic Labels: Formulas
155 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam_Kramer
6 - Interface Innovator
6 - Interface Innovator

Hi all! 

I am trying to find a method to tell me the Field Name of the last modified field, using a Formula. Is this possible without external scripting? I'd also settle for Field ID, although not most ideal ðŸ™ƒ

Was hoping for a function like LAST_MODIFIED_TIME( FIELDNAME() ) or something.

Basically, I have logs coming into a Logs table with 100(ish) columns, and I want to know at a glance what type of logs that particular one is 🙂

Thanks in advance!
Adam

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

No, it is not possible for an Airtable formula to tell you WHICH field was modified, but you can setup multiple different formula fields (or multiple different "last modified time" fields), and have each one of those fields monitoring a different field.

Also, you may want to explore Airtable's webhooks, which can tell you which field triggered the webhook, but that is significantly more advanced and would likely require scripting.

- ScottWorld, Expert Airtable Consultant

Using webhooks isn't a bad solution, just not the one I was hoping for ðŸ˜… I'll go this route, thanks @ScottWorld !!!