Database and entry form for job tracking / bonus calculation
Budget: $30 – $250 USD
In our small business, we have engineers performing remote jobs in various locations. Currently , in order to track which engineer, when did what job in what location we use excel sheet which gets impractical as the number of accomplished jobs gets larger.
Need to haver a powerup that would
1) Allow convenient data entry for jobs ( about 20 columns for each row)
2) store data in database with user access management, contents of which can be used for Power BI or dumped to excel
3) Calculate bonus for each engineer based on pre-existing formula
4) provide executive summary of approved/pending bonus by engineer, location or manager
5) engineer names should be looked up from company directory when entering data (if possible)
regards
Need to haver a powerup that would
1) Allow convenient data entry for jobs ( about 20 columns for each row)
2) store data in database with user access management, contents of which can be used for Power BI or dumped to excel
3) Calculate bonus for each engineer based on pre-existing formula
4) provide executive summary of approved/pending bonus by engineer, location or manager
5) engineer names should be looked up from company directory when entering data (if possible)
regards