Jun 12, 2019 11:39 AM
We are trying to find the easiest way to setup a date time stamp field, that is, either when creating a new record or triggered by filling in one of the others cells in a new record. that time/date stamp field is populated with the current date and time and it would be static, that is, would not update to tomorrows date if it is accidentally clicked again.
What is the easiest way to do this?
Jun 12, 2019 11:49 AM
We are looking for a way to auto-populate the date field for our Interactions table. Our sales team needs to take notes of every call and each manual step that gets in the way is one more block to completing the data entry. Is there some non-zapier way of doing this? Forms? Default input values for formulas? We’d like the sales rep to be able to change a date after the fact if they are logging calls from prior days.
Jun 12, 2019 12:20 PM
@Bill_Sewell, @syd_Levy - I think you should be able to use the “created time” field type for both of these scenarios. It is automatically created when a record is created and is static:
If you use a form to populate your table it doesn’t even appear as a field in the form (no need as it is autopopulating).
Jun 13, 2019 08:13 AM
is that in the regular field drop down list?
Jun 13, 2019 08:45 AM
Yes, although it isn’t available as an option in the primary field of the table, just the other fields.
Jun 14, 2019 11:28 AM
Thank you - makes sense. I appreciate the help.
Jun 07, 2020 10:44 AM
Hi Jonathan, if you are still there.
In this posting you mentioned that records created with a form are automagically time-stamped. That is handy to know. Can you tell me how one would be able to search for a range of records between any two dates through the use of these automatic time-stamps?
All help much appreciated.
Jun 07, 2020 01:29 PM
Hi @Teacher_Lin - you can filter a view where the created date is greater than X and less than Y, as long as you have added a field with created date/time. If you don’t want to see this field in your views you can hide it (but it will still be available in the filters).
Jun 07, 2020 07:20 PM
Thank you Jonathan.
That is precisely what I need.
May 08, 2022 08:52 AM
thanks so much for that great tip!