Accepted Solutions
The easiest way to see what I’ve done is to load that base and click ‘Copy base’ in the upper right-hand corner. That will create a duplicate of the base in your own workspace. When you open the duplicated base, you can then right-click on each field and edit its configuration.
----but that base in particular was written a while back, before I became lazy :winking_face: , so each field has a defined description. If you hover over the ⓘ in the header for {latestNoteDate} in the [Companies] table, you’ll see the following description:
(Note: The ‘Note’ no longer applies. Presumably there was a change/fix/modification to Airtable — let me go check the release notes :winking_face: — that corrected this behavior. When you copy the base, it will continue not to display a time field – but if you disable the time field in the formatting tab and then re-enable it, the time field magically appears.)
That description is my way of saying the field should be configured as follows:
In the [Notes] table, {latestNoteDate} is simply a lookup field that retrieves the value of the field of the same name from [Companies]. It’s used by the formula in `{Notes::latestNote}’ to identify which note is the most recent.
I am unable to accomplish what seems like a simple request for a database. I’ve put a sample book here and would appreciate any assistance that can be offered. this is quite simple in excel and in other applications like fieldbook, but baffling me in airtable.
Basically, i want a vlookup to find a value contained on a related table where another value on the related table is the maximum. The scenario is quite simple- inventory may be owned by many investors over time, each delineated by an increasing integer (eg, owner 1, owner 2, owner 3, etc), and i want to look up the last (or max ownership number) investor’s price.
the book is here:
Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
The easiest way to see what I’ve done is to load that base and click ‘Copy base’ in the upper right-hand corner. That will create a duplicate of the base in your own workspace. When you open the duplicated base, you can then right-click on each field and edit its configuration.
----but that base in particular was written a while back, before I became lazy :winking_face: , so each field has a defined description. If you hover over the ⓘ in the header for {latestNoteDate} in the [Companies] table, you’ll see the following description:
(Note: The ‘Note’ no longer applies. Presumably there was a change/fix/modification to Airtable — let me go check the release notes :winking_face: — that corrected this behavior. When you copy the base, it will continue not to display a time field – but if you disable the time field in the formatting tab and then re-enable it, the time field magically appears.)
That description is my way of saying the field should be configured as follows:
In the [Notes] table, {latestNoteDate} is simply a lookup field that retrieves the value of the field of the same name from [Companies]. It’s used by the formula in `{Notes::latestNote}’ to identify which note is the most recent.
