• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking for an Google form kind of application based on excel

V

vinu

Member
Hello Team,

we are looking to build a kind of 'google form' based on excel or any other tool (I do not have much technical knowledge). to collect certain data from internal employees and all the inputs should be recorded in any database.

Can you please suggest, which is the right tool to use. we have these tools with us.
- Office 365(we do not have the excel form), share point, excel, access.

Requirements:
1. 5-6 questions, with file upload option and submit. After building this form, we will share it with the group of employees spread across different countries. It's is not one time activity, it's ongoing task.
2. Leadership team should be have access to end result with these input details and to analyse in excel sheet.

Please suggest if we have any post similar to this / article.

Regards
Vin
 
Just use SharePoint list, either custom list or survey. Do a google search and you'll find plenty of tutorials. No coding needed for your need. It's pre-packaged app in SharePoint.

VBA won't help you much here, as you can't run VBA on hosted file. Unless you go the route of local file for each user, and some logic to push info updated on local file to hosted file. But then, it's not recommended as it will be tricky to ensure there's no conflict etc.

Edit: You could have managers access list/survey on SharePoint team site. Or use Get & Transform to connect to SharePoint list and load data to Excel for reporting.
 
You must log in or register to reply here.
Back
Top