We have promoters in Retail outlets selling our Products. They all have Partner Community license just to capture logout and login time/Customer Information (Address).
We now have a requirement to create a Product Display matrix for them. So that they can directly go and edit the stocks in each outlet. I tried creating a object and relating it with Products.
Since they have Partner community license and I need them to just click the table and edit the Quantity in the table itself. Also, the management needs the table to be scheduled weekly as a report to them.
How can I do this? I am a non coder. Would VF Table be a better option. Can you suggest few coding samples?
Below is the Mock Table I had mentioned above.