We have a planning/forecasting Excel spreadsheet for sales. However it’s impractical and always out of date and no more than 1 user at a time can update it. Basically they need it to be on a shared architecture. Naturally Domino is great platform for this.
However, we build all our domino applications for the web. Now I know the Notes Client supports this feature, but I would like to apply it to a web page.
The reason is that if they have prices and costs to adjust for 50 sku’s the overhead for opening each one up, navigating to the appropriate place then saving then exiting … is basically deterrent enough that they will not use the pplication and keep on hacking away at their spreadsheets thus leaving those that do consult the application out in the cold because the data will never be updated.
I searched LDD and a few others for a hint on how to proceed, but I don,t quite get how to build my HTML content view to allow for in-view editing.
If we remove the fluff of the HTML to control the table headings and columns, what would the HTML in the column for an editable field look like?
My assumption so far is that the user needs to click once on a number. When he does this, the number is replaced by an editable field containing the original number and it displays a little OK button next to it. hen the user clicks OK an agent is run.
The agent url needs to contain a parameter that instructs it as to which field was changed and what is its new value. In order to proces the request I need to build a Notes only form that has the actual fields on it, then when the user runs the agent, the backend gets updated with the new values.
I can probably build the input switching, but my problem is how do I position it on the page with the OK button? If I run an agent by calling the URL and appending &fldnam=field1 etc can I retrieve those parametered values or do I have to call a placeholder form instead that contains a query_string field and has a WebQueryOpen agent and a SaveOptions=0 field?
I know this is complex and long to read. If anyone has a web page or site they know which has info about this, please let me know.
In one of the threads here they pointed to Codestore.net but didn’t provide a direct link and none of the articles actually discuss this topic. I also searched Notestips.com but their site is so slow it’s unusable.
Thanks for reading, and I appreciate any assistance that can be provided.
Luc Millette