Explore

Bagkok RI - Customer Details App
Bagkok RI - Customer Details App

This document provides details required to understand/use the App

This document provides details required to understand/use the App

Arjit Saraswat

⁠

📋 WHAT IS IT?

A simple m-Site which lets users check the Customer Details like Booking Count, Last Booking Source etc. by inputting his Mobile Number into the App.

⁠

🔧 HOW DOES IT WORK?

Go to the

mSite⁠

, Input the Mobile No. and press the “Get Details” Button

Note: The Country Code “+66” is already prefixed

⁠

Screenshot 2021-05-20 at 10.24.24 AM.png

⁠

When Details are fetched successfully

⁠

Screenshot 2021-05-20 at 10.21.21 AM.png

⁠

When the Data does not exist for the given Mobile No.

⁠

⌨️ The Backend Process

Daily at 11 AM, the App fetches data from the
Google Sheet⁠
containing the customers’ Booking Data and stores it in internal Bubble Database.

If the Mobile No. is already present in the internal database, the record is updated.

If the Mobile No. does not exist in the internal database, a new record is created.

Whenever a user inputs a Mobile No. from the App, we query the Internal Database and return the required data.

⁠

🚧 POTENTIAL SCOPE OF ERROR

If the Google Sheet contains duplicate values, there can be data mismatch. Currently in case of duplicate records, the topmost record is considered

If there is non-uniform format for identity (Mobile No.), the data will not be fetched.

⁠

📣 CALLOUTS

The name for Google Sheet Tab (”Sheet1”) should not be changed, and the order of columns must remain the same.

The Format for identity (Mobile No.) should not be changed

If there are any changes being made in the App at any time, user will not be able to properly use the App as it will keep showing the message that the App has been updated. This is because we are using a development version of existing App that we are already paying Subscription for. We will have to take a new Subscription to deploy this on production with a new domain.

📋 WHAT IS IT?

🔧 HOW DOES IT WORK?

⌨️ The Backend Process

🚧 POTENTIAL SCOPE OF ERROR

📣 CALLOUTS

Gallery

Want to print your doc?
This is not the way.