Don’t see a feature request for this although mentioned in community so just adding here to so I can get feedback.
At the moment I’m currently building out my Softr Database structure and have everything in one database because most items in my database (invoices, actions, contracts, risks, purchase orders etc) need linked to a project ID or a client etc which I have a tables for in the database.
It’s starting to get a bit messy with all the tables I now have and with the 200,000 limit on records in the database for business plan, it won’t be long before I reach this limit if I carry on building everything in one database.
It would be cleaner and easier to manage if we could have multiple databases that could be linked across. So I could create a database for Resources (Users, Clients, Projects etc) and then create related records from other databases
Alternatively having an option to sync certain tables across databases would work too.
1 Like
Hi @sarah_h Totally agree! I’ve brought this up in the past, and if I recall correctly, I believe Softr will be implementing linking across databases, although there is no timeframe that I am aware. The 200,000 records per database is very limiting, and to your point makes it necessary to contain everything in one database which can get messy quickly. Fingers crossed Softr rolls out an update for this. They allow 1,000,000 records across all databases, I think they should get rid of the 200,000 cap per database and let us utilize the 1,000,000 across our Workspace - whether it’s in one database or multiple.
3 Likes
Yes I originally started moving to Softr DB because the limit on my account was 1,000,000 records across the databases but only recently realised the 200,000 limit per database which has put a hold on things for now until I get a clearer picture of how this will be managed going forward. Either remove the per DB limit or allow cross database linking. Hoping this is something that is looked at soon. I’m kind of in limbo at the moment between 2 systems with no clear path of where to go 
@artur @Jjenglert can you provide any input on this please?
So I’ve been playing around with Make.com as I have a subscription already in place (I’m not a very advanced user of it) but I think I can look to create Project ID and Client tables in multiple Softr databases then every time a new record is added in one database it updates it in another through the automation. Not sure if this is good practice or not but might be a workaround for now. The automations in Make for Softr only seem to work on a schedule rather than watching the table and triggering as ‘immediately as data arrives’ which is an option I have for my other Scenarios which use SmartSuite as the trigger. Anyone doing something similar? Any feedback on this method?
for instant triggers on make the provider have to use webhooks which the scenario catches. hope they update it with softr workflow, that you can trigger on specific changes like airtable automations. @sarah_h
Ah ok, so it’s not something I’m doing wrong, it’s just not available functionality with the way it’s connected in Make. I’m patiently waiting for Softr Workflows and hoping this will help with some of the issues I’m facing. In the meantime I’m just trying to find ways to make things work so we can properly start using the apps I’m building
1 Like