Collaborate on Create Invoice from Excel Database for Personnel with Ease Using airSlate SignNow

Create invoice from excel database for Personnel

in this series you will learn how to create this employee database management system using google sheets this google sheet is divided into four layers this is the search layer where you can filter the records in various aspects here is the employee information panel where you can view the employee details this is the employee list where you can choose the employee details you need to view you can also add new employee record by clicking this link once you click this link you will be redirected to your google form where you can fill up the new employee details for certain fields we have set up validation list here you can upload the employee passport size photo post filling all the about details you can click on the submit button immediately once you click the submit button all the records will be sent to this google sheet in this employee list you can view 10 records at the time [Music] once you click on this new icon that particular employee record will be visible in the employee info panel [Music] this edit icon will be used to edit the particular employee the card the delete icon can be used to delete the record from the database and this restore icon can be used to restore any remote records back to the database to view the next and previous page you can click on the next and previous button you can also jump to any of the pages i just type the page number here you can see once i click this view button that particular employee record is being highlighted in green color and the employee details was updated in employee planner [Music] when i click this edit button this employee details was been updated in edit recorded layer once i click this delete button that particular employee is being shared in that color with a strikeout [Music] here you have an option to restore even remote records in the employee list if this check box is unticked you will not see the remote records and when i click the restore button immediately the particular record was out from remote list whenever you make any changes in the filter option instantly the employee list layer gets updated with the filter locals [Music] you can also filter the record by employee date of journey as well as the employee birthday [Music] and you can directly search any employee using this employee search option by just type the name or the employee id this data validation will filter the list as per the text which you type in [Music] in the employee information panel you can also move to next to a previous employee record by clicking this next or previous button [Music] now in this case we are into 180th record and when we click this nest button the employee list will also move to the next page [Music] instantly and the last one is the edit record layer where you can edit the existing employee details when you make any change in the employee record it will be highlighted in that color until the editor record gets saved you can also edit the employee photo by clicking this link which will redirect you to your google form where you can upload the new photo and you can notice the employee code is already filled to google from tech [Music] after making the changes click on the save button to save the editor's record now the edited information got updated in employee information panel [Music] you can also get back to the previous information until the edited record is not saved in employee information panel you can view the basic details of each employee in this complete series you will learn step by step how to create this employee database management system using google sheet with the support of google form and google apps script by the end of this video i can assure you that you will be following designing your dashboard layout in google sheets creating new google form and pre-filled google form using data validation conditional formattings if logicals index match and array functions and at once knowledge in using google apps script to automate the repeated task you can create a copy of this dashboard by just paying 99 indian rupees please follow the link given in the description though i am never going to teach you the step-by-step process of creating this dashboard i would suggest you to have a copy of this file for the airlines and better understanding when you apply these techniques in your real-time projects if you feel this video useful for you please share and subscribe to my channel