I’m wondering if we can have a lookup function where a record will show in Table B if column X is checked or = something.
The use case is managing orders for an ecommerce store. I have created a couple of tables: New order, out for delivery, completed . I send the new orders to the new order table via zapier. When the item is shipped, the warehouse manager marks it as Shipped (checkbox in a column called shipped). It get filtered out of the New order table (using filters) but then I’d like it to show up in the Shipped/Out for Delivery table.
I know I can use views but unfortunately views are not as intuitive and the onsite people simply don’t seem to understand them. This is making it hard for us to operate and scale ! Thank you for the help