Skip to main content

Lab 5 - Service technician app

Goal​

Service technicians that perform service on the FM2 Electric Bike require an app to view their service appointments as well as a service manual they can refer to. The following image shows the technician app that is used to review the customer details, access the FM2 Electric Bike manual, via a chat interface + Retool Vectors. The following architectural image provides an overview:

Technician app
Technician app

Build​

The technician needs an app to capture service appointment details, mark the work complete, and add service notes.

Base App Prompt​

The initial prompt you will start with is:

I want to build a service technician app that merges data from retool_db flash_customer and flash_service table. This will allow the technician to provide notes/updates. I would like to update the flash_service table to have a new column called notes for text input by the technician.

The application that is generated will look similar to the following:

Generated app view
Generated app view

Verify that the content display matches what is in Retool Database and that a service note area is available for the technician.

Service note area verification
Service note area verification

Update work status​

Next we will add the ability to update whether the work is complete using the following prompt.

Please update the app to allow the complete column in the flash_service table to be changed from False to True.

Test the completed app​

Let's update the work from pending to complete and add a service note that is then saved.

Work complete test
Work complete test

Check Retool Database that the update was made to the flash_service table.

Flash service table database confirmation
Flash service table database confirmation