People usually do still offer in-depth instructions, nothing has changed. Kuovonne gave a pretty exact description on how to solve the issue manually; I understand you couldn’t get it to work, but you didn’t say where in the process you’re having trouble. There’s only so much we can help with if we don’t know what the issue is.
In my case, there seemed to be a misunderstanding of how Airtable is supposed to work which is why I didn’t explain the steps to the Automation-based solution i suggested until the basics were understood. There are multiple ways you could set up an Automation to accomplish this, the following two will result in creating a new record with the date prefilled:
Method 1
Trigger: When a record in “Pressure Fills” table meets the conditions: “{End Date} is not empty and {Fill Amount} is not empty”
^ the example trigger assumes that you only want to run the automation when the “previous” record has been filled out completely
Action Steps:
- Create a record:
- Table = “Pressure Fills”
- Field Values =
- {Begin Date} = Trigger record’s field value for {End date}
^ to insert the value from the trigger record, click the blue plus button to the right
Method 2
This Automation setup will assist in the setup described by Kuovonne where you are linking a log record to the ‘previous’ record with a field assumed to be named {Previous Record}
Trigger: same as Method 1
Action Steps:
- Create a record:
- Table = “Pressure Fills”
- Field Values =
- {Previous Record} = Trigger record’s record id
As Kuovonne mentioned, in this scenario the {Begin Date} field would be a Rollup-type field that pulls in the {Previous Record}'s {End Date} field
You didn’t clarify if you’re only logging records for one bike or for many bikes. If you are logging records for multiple bikes the above instructions will vary.
It already often does, depending on the use case (the use case is usually “I need a database, not a spreadsheet”)
