No-code interface between mobile app and databases - spreadsheet display

We have an easy, no-code, secure and low-cost tool for :

• links, interfaces, APIs to existing databases such as ERP: a crucial element for any large-scale mobile application!
• data entry spreadsheet screens on PCs for mobile apps, mobile data hosting.

Every complete mobile app has initial data and collected data: customers love their spreadsheets for this! But the Excel spreadsheet can’t be shared across multiple terminals. And the data must be on their server: we have a “no-code” solution that meets these constraints, on which we have mastered the APIs: NOCODB

Initial data (such as item description tables, prices, orders, settings, parcels, customers), for example, are read-only, but the user can sort them according to criteria expressed directly without support or programs, as in Excel.

The data collected by the terminals is stored in tables that can be modified without coding from a browser, in Excel format.

All in total security!

How do customers manage this secure service linking their ERP and databases to our mobile apps?

Our customers sign up free of charge with this selected hosting provider (NOCODB), at a very reasonable price, free to start with or depending on data volumes, database settings are made without coding according to the write and read rules they define, or according to the needs of the mobile app.

They can start by importing their data into the database via csv files (== Excel), then or immediately build the real-time link without coding to their database in one go, or through our favorite no-code interface with your databases as option. They remain in possession of their data.

They give us read or write rights on each table, modifying it as required: we’re just “guests”.

Then we build them the defined mobile app that accesses this database in total security.

To create spreadsheet-type input screens for their users, internationally

A secure and confidential access is reserved for them by user type that they will have defined beforehand.

The interface is translated into 30 foreign languages.

Our customers can also create statistics and reports according to their own preferences, without complex SQL queries, just like in Excel.

Large-scale multi-site and international applications can thus be realized.

The advantages of the NOCODB hosted solution in table format:

• data belongs to the customer,
• our applications can read or write to databases according to defined rights and requirements,
• data can be shared across the company,
• data in table format similar to Excel, so easy to understand and update, and to create statistics, reports and graphs yourself,
• import, save and export data in Excel-compatible formats
• linking data from several tables to each other using the solution or our mobile application, depending on the processing involved

The advantages of a shared, hosted database interfaced with our APIs: more ambitious multi-site projects and rapid, secure access:

• database hosted in the country of the customer’s choice, including France: place databases with OVH and set API parameters with NOCODB
• payable by the month directly to the host, and therefore owned by the customer,
• secured by the host,
• both we and the customer can access it securely and according to our respective rights,
• the customer can put in MySQL or PostGreSQL databases,
• the customer can have his own API on his databases for other uses.

In short, it’s a neutral exchange ground where the customer is at home and the Productivix editor can access without breaking anything on the customer’s premises.

Possible mobile applications :

all!

From production and logistics applications, to simplified inventory management, transport and parcel tracking, and manufacturing tracking with serial numbers for medical and security applications, an international app,

anything is possible, made to measure.

Do you have a similar need?

Don’t hesitate to tell us what you need: a copy of a pencil drawing of an interface, examples of interface files, a video of an obsolete software program in action will be enough.