i was asked to build a custom form app with sharepoint as the database. My issue is that their is over 150 datacards and the app is unusable with delays. My plan is to remove all the lookup & choice column datacards and replace them with "text" (prefilled items etc) and a few other tricks to make usable.
But how do you guys go about building large forms with loads of custom datacards?
This form im building is replicating a excel file with say 40rows and 8 columns each with a different value (its a invoice spreadsheet) so i can reproduce this with powerbi and i can extrapolate every "cell" in powerbi etc and ill also have an export to pdf for analog signing (booo, and ewww paper, but thats what the client wants)
Really im looking for advice on how this is done? How did you do it?
I was thinking of replicating xero with the add row in the invoice section..
I have ways to do this and have been using this system since the beginning. however i wish to propose the idea to the client and would love some more ideas and options that may suit them and with powerbi as the selling point for the boss. Ive done this sort of thing before but with lots more data coming from a myriad of sources and not all of it coming from a single app..


Report
All responses (
Answers (