Forum Discussion
Multiple Spreadsheets - Return based on user
One thing I can think of is putting a wrapper on that excel. Powershell script grab users info open excel copy from remote sheets populate local form. On exit move data back to source. If exit inproperly edits will be (cashed locally) if reopen cash destroyed... Contact admin to repair.
How many users and how much trouble.
Another method I would think about populating the user info using sql and MySQL or an Xbase table run query from within excel and update tables from sheets have master query and update on a cycle. Then there is that other method.... How deep you want to go?
- DaithiGMar 29, 2019Steel Contributor
Thank Robert_Golobek
I've been trying to get them to move to an actual database for this for a while but just wanted to play with PowerApps and see what was possible.
- Robert_GolobekMar 29, 2019Copper Contributor
Whew was worried about that one. I see so many people using excel as a data source rather than was the tool was made for. I agree I can take fly's out of the house with a shotgun however. Use the proper tool for the proper job. Access is not that hard (but it costs) MySQL, Xbase both free tools (yes I am that cheep). Odbc is your friend learn how to run a query. Excel is great for reports and populating from querys, and it works great from powershell and other scripts.