Hi, I want to create a centralized database system using Intuiface, where entries can be added, edited, or deleted seamlessly. This system should synchronize with a single database, such as an Excel sheet or Airtable, ensuring real-time updates. The Intuiface experience should include buttons or an interface to handle these actions, allowing users to add new entries or delete specific ones from the database. Ideally, the process should be automated, ensuring smooth and efficient operations. Is this achievable with Intuiface?
HI @zuhair,
Depending on that “central database” that you decide to use, yes this will be doable with Intuiface.
If you decide to use a simple Excel file (not really a database, but can act as one for simple cases), the idea will be to use 1 of your Players / Experiences as the “Master”: the one that has that Excel file, receives requests from other Players / XPs to update that file, the one that notifies the other Players of what’s happening.
Depending on your architecture (how many Players / XPs are involved), the notification part can be a bit tricky to set up.
Without the Excel part, this is the architecture we used in our Entrance Flow Management sample, with 1 Main XP and N Additional XPs running in the same environment. The “database” was just a simple counter.
If you decide to use a 3rd party “database”, as soon as it has an API than enables to read, create, update, delete records, then you can use this solution with the API Explorer. Airtable is indeed a good and easy example to use.
Once 1 Player / XP makes an update in the base, it’s a bit easier to ask the other Players to just refresh the data they are reading from that base to ensure a good sync, compared to the Excel-based solution.
If you’d like to discuss your project architecture with more (private) details, please don’t hesitate to contact us through our support platform.
Seb