Yeah. Use views. :grinning_face_with_big_eyes:
Seriously, though, for what you want, views in Airtable are a far easier way to do the job than a new table, mainly because you already have all of the necessary data in place. Pulling all of that data into a different table simply to show a smaller subset of that data is actually going to be more work than it’s worth. A new view, though, would operate on your existing data, giving you a way to control how that data is displayed without changing any of it.
Not-that-long story short: make a new view (Kanban if you prefer, though Grid might be worth exploring) and add a filter that only shows records where {Status} is “Completed.” Boom. Done.
To see only pending tasks, make another view with a similar filter, where {Status} is not “Completed.”
That’s pretty much all you need to achieve those two things. Doing that same thing by pulling the data into a second table would be a LOT more work.
When you want to simply get a different view of your existing data, then views are the ticket.
Yeah. Use views. :grinning_face_with_big_eyes:
Seriously, though, for what you want, views in Airtable are a far easier way to do the job than a new table, mainly because you already have all of the necessary data in place. Pulling all of that data into a different table simply to show a smaller subset of that data is actually going to be more work than it’s worth. A new view, though, would operate on your existing data, giving you a way to control how that data is displayed without changing any of it.
Not-that-long story short: make a new view (Kanban if you prefer, though Grid might be worth exploring) and add a filter that only shows records where {Status} is “Completed.” Boom. Done.
To see only pending tasks, make another view with a similar filter, where {Status} is not “Completed.”
That’s pretty much all you need to achieve those two things. Doing that same thing by pulling the data into a second table would be a LOT more work.
When you want to simply get a different view of your existing data, then views are the ticket.
haha just as I thought. I tried views and it works great. Hopefully the request for the secondary table will be dropped, fingers crossed. thanks Justin
