Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Midnight_Mushro
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Midnight_Mushro - profile
Midnight_Mushro
4 - Data Explorer
since
Sep 05, 2019
Nov 29, 2022
User Statistics
2
Posts
0
Solutions
2
Kudos given
1
Kudos received
User Activity
Posts
Replies
If value changes insert timestamp in another field when it was changed
Sep 06, 2019
I’m trying to insert a timestamp into a field when a value on a record changes. I’ve got this but it’s not really updating like I was expecting. IF(Stage=“3. Fruiting”, NOW(),0) It seems to be updating randomly. Any ideas?
Re: If value changes insert timestamp in another field when it was changed
Sep 06, 2019
AlliAlosa: IF(Stage = “3. Fruiting”, LAST_MODIFIED_TIME(Stage)) That seems to be working! Thanks!
Kudos from
User
Count
AlliAlosa
1
View all
Kudos given to
User
Count
AlliAlosa
1
Airtable_Ops
1
View all
