CREATE DYNAMIC FORMS TO SAVE DATA ON EXCEL DATA
- or -
Post a project like this$200
- Posted:
- Proposals: 22
- Remote
- #2565524
- Expired
169487328998273276915323485132214213218905320368531982833196519316980231520392956711
Description
Experience Level: Entry
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
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
Richard A.
100% (11)Projects Completed
11
Freelancers worked with
9
Projects awarded
44%
Last project
7 May 2020
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies