Skip to main content

When you have multiple independent instances of the same database schema (Base) along with their corresponding user interfaces (UIs) and separate data records, you might be looking for efficient methods to implement changes to the database schema or UI across all these instances. What strategies or solutions are available for applying updates or modifications to the database schema or the UI consistently and effectively to all instances?

To provide some illustrative context. I would like to add a Field 3 to the Master-BASE and rollout this change to all instances.

MASTER-BASE

  • Table A
    • Field 1 (Single Line)
    • Field 2 (Number)
  • Table B
    • Field 1 (Email)

MASTER-UI

  • View 1

 

Instance1-BASE

  • Table A
    • Field 1 (Single Line)
    • Field 2 (Number)
  • Table B
    • Field 1 (Email)

Instance1-UI

  • View 1

 

Instance2-BASE

  • Table A
    • Field 1 (Single Line)
    • Field 2 (Number)
  • Table B
    • Field 1 (Email)

Instance2-UI

  • View 1

 

Thank you

I’ve built something to do this automatically so that you can view all of your schema changes or get notified on them across all of your bases (table, field, record changes)

Airdiff: https://airdiff.modernstack.io/


@NICKNAME 

This is not how Airtable is designed to be setup, because you are unnecessarily duplicating your efforts over & over again.

Ideally, you should only create ONE BASE ONLY that contains every customers’ records, but create a filtered interface that automatically shows each customer only their own records — but doesn’t show them anybody else’s records.

You can accomplish this using Airtable’s interfaces, Airtable’s portals, or by using a 3rd-party Airtable portal.

Some popular 3rd-party Airtable portals include:
NolocoJetAdminSoftrPory, MiniExtensions, and Glide.

I gave an entire one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld