{"id":246825,"date":"2023-11-21T15:53:00","date_gmt":"2023-11-21T14:53:00","guid":{"rendered":"https:\/\/www.devoteam.com\/success-story\/training-for-talents-appsheet-application-randstad-a-real-life-appsheet-solution-showcase\/"},"modified":"2025-09-09T13:48:19","modified_gmt":"2025-09-09T11:48:19","slug":"training-for-talents-appsheet-application-randstad-a-real-life-appsheet-solution-showcase","status":"publish","type":"success-story","link":"https:\/\/devoteam.info\/be\/success-story\/training-for-talents-appsheet-application-randstad-a-real-life-appsheet-solution-showcase\/","title":{"rendered":"“Training for Talents” – AppSheet application @Randstad: a real-life AppSheet solution showcase"},"content":{"rendered":"\n

About the client<\/strong><\/h2>\n\n\n\n

Randstad is an international employment agency. The request for the following project came from the national Belgian entity. From within the regional Randstad offices (= units) on average 20-30 training courses are planned daily for attendees who are temporary workers. The training packages are short, recurrent, and ready-made training courses (driving licence, safety, forklift, etc.) required by the employer and\/or valuable for the profile of a worker. \u00b1100 training courses from external suppliers can be requested immediately. <\/p>\n\n\n\n

Each unit (700) could decide where to order training courses, invoices were paid blindly without an official approval flow, and no budget or framework was available. In addition, there was no checkup on the quality of the training. They needed a funnel through which everyone would have to request training from a limited list of selected and validated training providers.<\/p>\n\n\n\n

They created an in-house solution based on spreadsheets, which worked very slowly and was not stable (people from the field started clicking and updating the spreadsheet without structure). They needed a more efficient solution, so Appsheet was considered a solution.<\/p>\n\n\n\n

The Challenge <\/strong><\/h2>\n\n\n\n

Streamline the process of booking training for temporary workers: There was no process flow to organise training sessions, every department applied its own rules for training, requesting training with different levels of quality, etc.<\/p>\n\n\n\n

There was a first attempt to centralise\/structure the process using Google Sheets, Forms and some Apps Scripts. It turned out that this solution was not performing as expected and was very sensitive to user errors and mistakes: the interface (a spreadsheet) needed to be more flexible. Given the above: user adoption was poor and they turned back to the old (bad) behaviour.<\/p>\n\n\n\n

Before:<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

After:<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

The goal was to create a stable and performing solution to support the process in a user-friendly way. So they could easily be managed by the non-tech-savvy Administration Department without lots of development work and low infrastructure costs.<\/p>\n\n\n\n

\n
\"\"<\/figure>\n\n\n\n

Because of the appsheet solution, we are now able to report on the training as well, eg we see all cancellations and can anticipate upfront.<\/p>\n\n\n\n

\n\n\n\n
\n
\n

Christian Duparcq
Advisor Training For Talents<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n

The Solution<\/strong><\/h2>\n\n\n\n

After reviewing the Sheet\/Forms\/Apps Script solution, they decided to go for an AppSheet app to ensure a more stable and user-friendly UI for the users in the field.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the back-end, the data is stored in Google Sheets to allow easy access for reporting. Some existing Apps Script functions could be re-used and optimised for sending emails.<\/p>\n\n\n\n

The Methodology<\/h2>\n\n\n\n