Skip to main content

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

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

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

Reply


Terms & Conditions