I have a table where I’m recording goods sold off from our inventory with a checkbox and status change. When I change the dropdown to `Sold` or `Donated` - I want to be able to :
Is that at all possible in Airtable?
+31Copy certain columns from one table to another (in the same base)
Yeap, we’d use an automation to do this and I’ve set it up here for you to check out
Generally the advice is to not do this though. Instead you’d use views where you filtered data the way you wanted it. For example, here’s a ‘Sold’ view in the base above that only shows records with the Status ‘Sold’
Totally understand that there are some business flows where you need to do this though!
---
Request certain fields to be completed (sale receipt upload, sale price added, etc)
Hm, what have you got in mind? We could have an automation that emails someone and asks them to fill it in if you’d like?
You could also use an Interface or a Form to make sure that whoever’s setting that ‘Status’ to Sold in the first place also fills in all those required fields too instead
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.