I would like to request the ability to create if this then that like rules in a base. I like formulas but they can be hard to work with if your not a formula person and I would like to be able to change the state of one field based on the change of another.
So I would like to change a records fields based on other fields in the same record, but also be able to change a record in a table based on the change of different record(s) in another table.
Examples:
- When a task changes to โNeed Reviewsโ THEN change the collaborator field to โJohnโ
- When a new record is added to the view โFor evaluationโ THEN remove the linked record โImplementationโ AND add the linked record โFor Evaluationโ.
- When a record is marked with โproblematicโ THEN notify Hannah
- When a deadline is within 7 days AND the record hasnโt been updated for that last 7 days THEN change the field โNeeds your attentionโ to checked AND notify me.
- When the field A, B, and C is empty THEN change the status to โIncompleteโ
This would make sense for Airtable with their โbuild your own applicationโ approach and mean that you could build great workflows.