I am interested in creating a product aimed at early stage startups, where in Airtable, I build a template for helping them keep track of their equity, convertibles and stock options etc. I am specifically interested in a way, where it is possible to centrally to updates to the template which are then automatically deployed to the copies. E.g. if 100 startups use the template, and then I need to update something in the Airtable, it would be great to be able to deploy the changes at once.
My understanding is that this is not currently supported by way of making a template (i.e. updates to the template cannot be deployed to the copies of the template in use), but a way of achieving this could be to have all the different users in the same base, and then governing by way of permissions and views that they can’t see or edit each others’ templates. This seems, however, also as a sub-optimal solution at least in the case of 100+ users.
I am writing to get the community’s take on whether my assumptions are right, and whether there are any other tools (ideally compatible with Airtable) that may be more suited for the task. I am of course happy to provide greater detail on the specific features needed and use case for anyone interested in engaging further.
I dont think so, even if you used say, Node.js, you still wouldn’t be able to update other bases and their overall structure because the API doesnt allow for creating new fields or altering formulas, links, etc.
You would probably have to quote your clients for the update, copy the base over and then migrate data via CSV exports and imports.
Its a good idea, however. The best next thing I can think of is offering the public URL of the base to your clients and password protect it. They would be responsible for copying it over and populating the data, and they can hire you for the update or just do it themselves if they want. You’d probanly want decent documentation that can guide them through that process in that case.