Skip to main content

Can minutes since update formula only watch one specific field?

  • October 13, 2022
  • 4 replies
  • 38 views
G

Hello -
I’m trying to set up an automation that runs whenever my editor inputs a note into a field. When I had the automation set to trigger when field is updated, I would get 7+ notifications as she typed her message. I adapted the trigger to be ‘when a record enters a view’ and the view only shows records with notes in the notes field, and a formula I added:

IF({MINS SINCE UPDATE} > 5, “Automate”, “Wait”)

To only show records that say ‘Automate’ to give her 5 min to type her message. However, this now sends a notification any time any record with notes is modified in any way.

My question is: Is there a way to have the minutes since update formula only watch my notes field?

    4 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hi Gabbi, I assume you’re using the Last Modified Time field in some form for your formula?

    If so, you should be set it to only watch the notes field which should solve your problem

    If my assumption is wrong, could you provide a screenshot of your data as well as your formula so I could help troubleshoot?

    Adam, Airtable Consultant - thetimesaving.company
    G
    • Gabbi_Lindgren
    • Author
    • New Participant
    • 2 replies
    • October 13, 2022

    Hi Gabbi, I assume you’re using the Last Modified Time field in some form for your formula?

    If so, you should be set it to only watch the notes field which should solve your problem

    If my assumption is wrong, could you provide a screenshot of your data as well as your formula so I could help troubleshoot?


    Thanks Adam! I am not using the last modified time field - but that may solve my problem! Including screenshots of the formulas I was using. However, based on what you are saying I may be able to use the last modified time field to only watch my notes field for modifications, Then my automate/wait formula can be tied to the last modified time.

    I am going to try that but if you have suggestions I am all ears!

    G
    • Gabbi_Lindgren
    • Author
    • New Participant
    • 2 replies
    • October 13, 2022

    Thanks Adam! I am not using the last modified time field - but that may solve my problem! Including screenshots of the formulas I was using. However, based on what you are saying I may be able to use the last modified time field to only watch my notes field for modifications, Then my automate/wait formula can be tied to the last modified time.

    I am going to try that but if you have suggestions I am all ears!


    Alright - the last modified field did not solve my problem, but it may have partially.

    My new question is if there is a way to modify my “calculation” field formula to “automate” 5 minutes after the Last Modified time and date.

    The formula I currently have is: IF({MINS SINCE UPDATE} > 5, “Automate”, “Wait”)

    If I adjust the formula to IF({Last Modified} > 5, “Automate”, “Wait”)

    I do not know how the formula will recognize the “5” as minutes - is there a way to do this or a better way to work this whole thing?

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Alright - the last modified field did not solve my problem, but it may have partially.

    My new question is if there is a way to modify my “calculation” field formula to “automate” 5 minutes after the Last Modified time and date.

    The formula I currently have is: IF({MINS SINCE UPDATE} > 5, “Automate”, “Wait”)

    If I adjust the formula to IF({Last Modified} > 5, “Automate”, “Wait”)

    I do not know how the formula will recognize the “5” as minutes - is there a way to do this or a better way to work this whole thing?


    Hm, I’d use DATETIME_DIFF() with the last modified time against NOW() to see how long it’s been

    I’ve put a base together here for you to check out as I think it might help?

    Adam, Airtable Consultant - thetimesaving.company


    Terms & ConditionsAccessibility statement