I've been looking into making some improvement to our airtable and one of the aspects I've been looking to improve is a form of order management. So in essence, we would be looking to move an item from a table to meet a condition such as ordered to some form of projects table, then once the project has been delivered we could move this invoicing
Any assistance in this matter would be greatly appreciate, I'm keen to learn on all things airtable as it's a really good tool!
Hi, use automation 'When record matches condition', then add Create record action. Use data from record. automation has no remove action, you can think about some status like 'Inactive', or add script step with one line base.getTable('your table name').deleteRecordAsync(input.config().recordID) recordID - you should pass it as input data.