Using Forms as a front end for a database

%3CLINGO-SUB%20id%3D%22lingo-sub-1267181%22%20slang%3D%22en-US%22%3EUsing%20Forms%20as%20a%20front%20end%20for%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267181%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20posting%20so%20I%20hope%20this%20makes%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20piece%20of%20work%20to%20do%20where%20I%20need%20to%20get%20various%20departments%20to%20check%20a%20spreadsheet%20of%20course%20start%20and%20end%20dates%20and%20a%20few%20other%20things%20and%20amend%20them.%26nbsp%3B%20In%20the%20past%20I've%20just%20emailed%20the%20spreadsheets%20out%20which%20has%20always%20been%20a%20disaster%20because%20to%20be%20honest%20the%20people%20needing%20to%20look%20at%20them%20aren't%20very%20tech%20savvy%20and%20sending%20a%20humongous%20spreadsheet%20usually%20results%20in%20at%20best%20getting%20ignored%20and%20at%20worst%20a%20scan%20of%20a%20printed%20spreadsheet%20with%20hand%20written%20notes%20all%20over%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20was%20hoping%20to%20do%20was%20build%20a%20form%20online%20that%20bases%20data%20off%20of%20a%20master%20spreadsheet%20where%20they%20could%20search%20for%20their%20course%20and%20just%20have%20a%20few%20boxes%20to%20complete%2C%20so%20for%20example%20they%20type%20the%20course%20code%20in%20and%20it'll%20show%20%22When%20does%20this%20course%20start%22%20with%20a%20date%20picker%20next%20to%20it%2C%20then%20a%20save%20button%20which%20overwrites%20the%20spreadsheet%20so%20I%20can%20then%20re-import%20it%20neatly%20into%20our%20back%20end%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20Forms%20the%20best%20tool%20for%20this%20and%20if%20so%2C%20can%20anyone%20point%20me%20in%20the%20direction%20of%20a%20how%20to%20guide%20as%20I'm%20struggling%20to%20know%20what%20to%20Google.%26nbsp%3B%20I've%20tried%20building%20something%20in%20Access%20but%20distributing%20that%20would%20be%20a%20nightmare%20so%20I'd%20like%20to%20avoid%20that%20route%20if%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1267181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1268407%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Forms%20as%20a%20front%20end%20for%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F602314%22%20target%3D%22_blank%22%3E%40badongism%3C%2FA%3E%26nbsp%3BForms%20is%20not%20the%20best%20tool%20for%20this%3A%20unless%20you%20are%20using%20Forms%20Pro%20and%20CDS%20you%20can't%20pre-populate%20the%20form.%20And%20Forms%20doesn't%20have%20a%20feature%20to%20select%20course%20code%20and%20it%20then%20shows%20the%20course%20start%20date%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20need%20to%20build%20an%20app%20in%20Power%20Apps%20to%20connect%20to%20the%20SharePoint%20list%20of%20courses%20for%20the%20user%20to%20amend%20as%20necessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all,

 

First time posting so I hope this makes sense.

 

I have a piece of work to do where I need to get various departments to check a spreadsheet of course start and end dates and a few other things and amend them.  In the past I've just emailed the spreadsheets out which has always been a disaster because to be honest the people needing to look at them aren't very tech savvy and sending a humongous spreadsheet usually results in at best getting ignored and at worst a scan of a printed spreadsheet with hand written notes all over it.

 

What I was hoping to do was build a form online that bases data off of a master spreadsheet where they could search for their course and just have a few boxes to complete, so for example they type the course code in and it'll show "When does this course start" with a date picker next to it, then a save button which overwrites the spreadsheet so I can then re-import it neatly into our back end system.

 

Is Forms the best tool for this and if so, can anyone point me in the direction of a how to guide as I'm struggling to know what to Google.  I've tried building something in Access but distributing that would be a nightmare so I'd like to avoid that route if possible.

1 Reply
Highlighted

@badongism Forms is not the best tool for this: unless you are using Forms Pro and CDS you can't pre-populate the form. And Forms doesn't have a feature to select course code and it then shows the course start date etc.

 

You would need to build an app in Power Apps to connect to the SharePoint list of courses for the user to amend as necessary.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User