Need suggestions : SPO custom forms dev as replacement for Excel vba macro (no SPFX,PowerApps)

%3CLINGO-SUB%20id%3D%22lingo-sub-821468%22%20slang%3D%22en-US%22%3ENeed%20suggestions%20%3A%20SPO%20custom%20forms%20dev%20as%20replacement%20for%20Excel%20vba%20macro%20(no%20SPFX%2CPowerApps)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821468%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20want%20to%20convert%20very%20complex%20vba%20based%20Excel%20forms%20to%20sharepoint%20.%20These%20Excel%20forms%20have%20formulas%2C%20macro's%20doing%20little%20data%20manipulation%20and%20pulling%20up%20reference%20to%20previously%20submitted%20past%20entries.%20We%20don't%20want%20to%20use%20spfx%26nbsp%3B%20for%20sure%20so%20wondering%20what%20other%20js%20framework%20can%20be%20used.%20I%20know%20angular%20js%20is%20already%20out%20of%20support%20so%20it's%20out%20of%20league%20so%20left%20choice%20are%20jQuery%20forms%2C%20knockout%20or%20some%20other%20on%20sp%20classic.%20Sp%20powerapp%20is%20not%20an%20option%20as%20form%20contains%20large%20number%20of%20questions%20(%20100%20%2B%20questions%20per%20tab%20and%207-8%20tabs%20%2F%20sections)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-821468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821560%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20suggestions%20%3A%20SPO%20custom%20forms%20dev%20as%20replacement%20for%20Excel%20vba%20macro%20(no%20SPFX%2CPowerApps)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821560%22%20slang%3D%22en-US%22%3EWhy%20SPFx%20is%20not%20an%20option%3F%20If%20you%20are%20developing%20on%20top%20of%20SPO%20Modern%20sites%2C%20you%20have%20to%20go%20to%20SPFx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821671%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20suggestions%20%3A%20SPO%20custom%20forms%20dev%20as%20replacement%20for%20Excel%20vba%20macro%20(no%20SPFX%2CPowerApps)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821671%22%20slang%3D%22en-US%22%3ENot%20on%20modern%20yet%20and%20not%20have%20skillsets%20%2F%20resources%20for%20SPFX%20also%20not%20sure%20if%20SPFX%20can%20fulfill%20this%20requirement%2C%20don't%20have%20leisure%20to%20try%20SPFX%20fail%20%2F%20stuck%20and%20then%20go%20to%20other%20approch%20hence%20dropping%20SPFX.%20Not%20considering%20PowerApps%20as%20form%20will%20have%207-8%20tabs%20and%20each%20tab%20will%20have%2060-100%20rows%20(%20also%20need%20to%20pull%20data%20from%20multiple%20lists%20%2F%20query%20lists%20with%20multiple%20criteria%20dynamically%20)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821715%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20suggestions%20%3A%20SPO%20custom%20forms%20dev%20as%20replacement%20for%20Excel%20vba%20macro%20(no%20SPFX%2CPowerApps)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821715%22%20slang%3D%22en-US%22%3EGood%20thing%20of%20SPFx%20is%20there%20are%20tons%20of%20samples%20you%20can%20use%20for%20your%20learning%20and%20building%20your%20solution...as%20an%20example%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-fx-webparts%2Ftree%2Fmaster%2Fsamples%2Freact-list-form%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-fx-webparts%2Ftree%2Fmaster%2Fsamples%2Freact-list-form%3C%2FA%3E.%20However%2C%20one%20thing%20to%20consider%20here%20is%20the%20following%3A%20where%20are%20you%20going%20to%20store%20the%20data%20of%20your%20application%3F%20In%20SPO%20lists%3F%20Depeding%20on%20the%20complexity%20of%20the%20data%20model%20of%20your%20application%20you%20might%20need%20to%20think%20on%20storing%20out%20of%20SharePoint%3C%2FLINGO-BODY%3E
New Contributor

We want to convert very complex vba based Excel forms to sharepoint . These Excel forms have formulas, macro's doing little data manipulation and pulling up reference to previously submitted past entries. We don't want to use spfx  for sure so wondering what other js framework can be used. I know angular js is already out of support so it's out of league so left choice are jQuery forms, knockout or some other on sp classic. Sp powerapp is not an option as form contains large number of questions ( 100 + questions per tab and 7-8 tabs / sections)

3 Replies
Highlighted
Why SPFx is not an option? If you are developing on top of SPO Modern sites, you have to go to SPFx
Highlighted
Not on modern yet and not have skillsets / resources for SPFX also not sure if SPFX can fulfill this requirement, don't have leisure to try SPFX fail / stuck and then go to other approch hence dropping SPFX. Not considering PowerApps as form will have 7-8 tabs and each tab will have 60-100 rows ( also need to pull data from multiple lists / query lists with multiple criteria dynamically )
Highlighted
Good thing of SPFx is there are tons of samples you can use for your learning and building your solution...as an example: https://github.com/SharePoint/sp-dev-fx-webparts/tree/master/samples/react-list-form. However, one thing to consider here is the following: where are you going to store the data of your application? In SPO lists? Depeding on the complexity of the data model of your application you might need to think on storing out of SharePoint