CREATE DYNAMIC FORMS TO SAVE DATA ON EXCEL DATA
Budget
258$
per month
Posted: 5 years ago
Opened
- Description
- 1- CREATE MULTIPLE DYNAMIC FORMS ( 9 FORMS) EACH FORMS WITH MULTIPLE SUBTABS
2- CREATE A SEARCH ENGINE WITH SPECIFIC PARAMETERS TO ENTER NEW ACTIVITY DETERMINING IF A CASE EXIST IN THE DATA ALLOWING THE USERS TO ADD NEW ACTIVITIES ON THE CASE OTHERWISE OPEN NEW CASE ACCORDING TO SPECIFIED PARAMETERS WE ESTABLISHED
3- CREATE USER CONSOLE WITH SECURITY LEVELS ACCESSING VARIOUS SECTIONS OF THE SAME CASE ( MEANING SOME USERS CANT ACCESS SPECIFIC FORMS)
4- CREATE FRONT END DASHBOARD ON ALL DATA IN HOUSE ACCORDING TO SPECIFIC PARAMETERS
5- GENERATE VARIOUS REPORTS WITH SPECIFIC ESTABLISHED PARAMETERS
6- SCHEDULE FOLLOW UP APPOINTMENTS THROUGH EXCEL LINK IT TO OUTLOOK REMINDER
ITS AN ACTIVITIES EXCEL DATA - WE ARE LOOKING TO CREATE FRONT END FORMS TO ENTER VARIOUS ACTIVITES VIA DYNAMIC FORMS. SO 1 CASE COULD HAVE 50 ACTIVITIES WE WOULD NEED TO BE ABLE TO SEARCH THE DATA AND HAVE ALL THOSE ACTIVITIES CONDENSED FOR THE SAME CASE IN A DASHBOARD. ALLOWING USERS TO ADD NEW ACTIVITY OR EDIT EXISTING ONE. ADDING NEW ACTIVITY WILL IMPLY TO OPEN A NEW ACTIVITY FORM THAT HAS 9 FORMS WITH MULTIPLE SUBTABS IF THE CASE LIVE AND EXISTING SPECIFIC DEMOGRAPHICS WILL GET COPIED AUTOMATICALLY TO THE NEW ACTIVITY LINE IN THE BACKEND EXCEL DATA AND ALLOW USERS TO GO THE FORM THEY WANT TO GO TO COMPLETE THE TASK. ITS A COMPLEX EXCEL DATA
UPON NDA SIGNATURE WE WILL DISCLOSE THE EXCEL VIA SKYPE SESSION. TO ENSURE THE VENDOR CAN PERFORM THE DUTY. WE ARE LOOKING TO COMPLETE THIS PROJECT IN A TIMELY MANNER WITHIN 48 TO 72 HOURS MAXIMUM
The forms should be expandable for future references in case we need to add column in the backend so the fields will show automatically on the forms. as well we created the backend data with specifics to each field : mandatory/ hidden/ calculated/ type of field so this will require VBA coding to give us the flexibility to expand the forms and add fields according to our need from the backend excel sheet data
Skills:
editing,back end developer,non disclosure agreement (NDA),search engine,VBA programming language
- Category
Source: peopleperhour.com
Drag