![]() Use the Group menu to group by the “Year” field (order from Z -> A if you want the most recent reads at the top): Rename that one table to “Books” or something like that - it does not need to be a year-dependent table, because now all of your records are year-dependent records. Transfer all your records from the other “Year” tables into that first table (ie, combine all your records in one table). You can hide this field later if you want. This will pull just the year out of your date you enter. Is there a way I can see that breakdown from the databaseĬreate a field in your first “year” table that is a formula field called “Year”, and has this formula - YEAR( if I did not get the name right) I just want to replicate seeing what gets read the most, and maybe even analyze if a certain genre gets an average higher rating than others. Is there a way I can see that breakdown from the database without doing a formula? Sorry I hope that was clear. So I think what you’re saying with this being a database won’t be able to apply quite like that here. If I wanted to create a table that combines the data and gives me a count of how many of each genre per year for example on Google I was calling that column (spacial) and equaling each time the cell in that column matched the genre value count as one, then adding them all up for that sheet. I also set up a different table for each year. I have setup the database with a single select for genre, a multiple choice for trope, the date finished reading is a date field, the number of pages or hours of audiobook are also separate columns with the number or time field type. I think what I’m trying to accomplish won’t work with formulas, maybe you can tell me? Thanks Jeremy! I think what you are saying makes sense in terms of not thinking of it as cells. There are a lot of people here willing to help out. If you have further, more specific questions, feel free to ask. Using Airtable will take a little adjusting in the way you think about capturing your data, but once you get your mind around it, I would argue that Airtable will serve you far better for what you are trying to accomplish than your Google Sheets were. And thus, the kinds of formulas you use, and the ways you use them, correspond far more to databases than to spreadsheets. An Airtable base is a database, and behaves far more like a database than it does a spreadsheet. ![]() ![]() In Airtable, what look like cells/rows/columns (in AT they are called cells/records/fields, respectively) DO NOT have any spatial relationship to each other - they do not exist in a position relative to other cells/rows/columns. The kinds of formulas you use in Google Sheets are formulas that reference particular cells/rows/columns by reference to where those cells/rows/columns exist relative to other cells/rows/columns. While Airtable’s advertising may be a little misleading, a base in Airtable is not a spreadsheet, and it does not behave like a spreadsheet either. And, importantly, it will be helpful for you if you don’t think of Airtable in the same way you think of Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |