arrow_back
Project Overview
Download the Demo File
Project Overview
Basic Set-up
Designing the Dashboard Layout
Create Employee Registration Form
Employee ID Generation
Auto Generate Employee Id
Auto Trigger Generate Emp Id Function
Data Source Set-up
Adding Additional Details using Array Function
Create a Data Table using Query Function
Search Panel Set-up
Update Data Validation in Search Box
Filter the Database using Search Box Selection
Reset Emp List on change in Filter
Page Set-up for Employee List Panel
Page Setup in Emp List Panel
Update Emp List using Index Match Function
Move to Next and Previous Page in Emp List Panel
Employee Display Panel
Get Emp Details in Emp Display Using Index Match Function
Get Emp Photo using Image Function
Activate Next and Previous Record Button
Update Selected Emp Details in Emp Display Panel
Emp List Panel Controls
Viewing Emp Details using View Icon
Highlight Selected Emp in Emp List Conditional formatting
Remove Records from the Emp List
Show Removed Records Also in Emp List Panel
Restore Deleted Records back to Emp List Panel
Edit Record Icon Set-up in Emp List Panel
Emp Edit Panel Set-up
Highlight Edited Records in Edit Panel
Apply Data Validation in Edit Panel
Save the Edited Record to Master Database
Edit Emp Photo using Pre Filled Google Form
Retrieve Old Record back to Edit Emp Panel
Final Set-up
Final Set-up