I have a Teams plan and recently discovered that you can only have 50 Automations per base (I don't know if this is a plan limitation or not, just providing details). NOT a limitation that I've ever seen displayed anywhere on plan details or comparison pages.
So it's a bit frustrating after investing a lot of time and effort into building out my base (including nearly 5k VERY detailed records), with lots of additional work in the pipeline to expand the base's capabilities, only to find out now that, as is, it will never be able to do what I need it to do. Development has come to a screeching halt because I literally cannot create an additional Automation...
To resolve this, (I'm thinking) it will require a completely different approach to my base design. Instead of keeping everything under one base, I'll need to split tables off into their own bases. I guess I'll have to MANUALLY 😠 re-create all the Automations related to that table into the new base as well. My main concern is making sure there is no data degradation. I don't want field TYPES to change. Obviously don't want the data to change. My main concern is making sure linked records remain in tact. Otherwise that could mean re-linking 5k records across half a dozen different fields....
To give a little more detail on the base structure for context, I have tables for Assets, Employees, Departments, Roles, Locations, Softwares, Makes, Models, Products, Requests, Orders, Projects, Tasks, etc.. I'm sure you can naturally understand how they could be linked together in a business.
I'm thinking the process would look something like this:
- Make a new base
- Sync table from original base to a new base
- Somehow update the linked records on the original base to point to the records on the new base, rather than the records in the table from the same (original) base
- MANUALLY 😠 re-create all the Automations related to that table into the new base
- Delete the migrated table from the original base
- Repeat as needed
However, I'm not sure how step 3 would be possible. I'm assuming it is and I just don't know how, or otherwise there's probably a better way to do this? I really don't want to have to re-link everything 😫
Any input would be greatly appreciated!
I also understand I could probably try to consolidate some of my Automations, and develop my scripting skills to eliminate the need for some of the Automations. I've also learned how to utilize buttons in interface designer to modify records, which could eliminate the need for some Automations. However, I'm thinking this will require more effort and time and will only serve as a temporary measure, as I will surely hit the 50 Automations limit again soon enough and I'll be right back in the same boat.