Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 30, 2020 09:38 AM
Currently we have a tasks table with Currently Pending Tasks view and a view for Previously Completed tasks. These tasks are linked under a record in another table, but we only need the Currently Pending tasks to appear in the linked column. After the tasks are flipped to Completed, they are removed from the Currently Pending view and pop up in the Previously Completed View. Does anyone know how to get these tasks to auto remove after they’ve been removed from the Currently Pending view?
Sep 30, 2020 11:46 AM
Welcome to the community, @Courtney_Smith!
It sounds like you don’t need to delete any records, but you just want to clear out your “linked record” field after the task changes its status.
That would be possible with Airtable’s automations feature.
Set your trigger however you would like. Then, for your “update record” action, add your “linked record” field — but leave the field completely blank. That will clear out the field.