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