RE: Temporary fields in form Martin Girouard 14.Jan.09 12:04 PM a Web browser Domino Administrator 6.5.6All Platforms
Maybe I wasn't clear enough.. I am not trying to import the excel, I'm trying to recreate it.
We have a Notes database used for HR-related tasks.. performance reviews etc.
One client decided under certain conditions (when the employee performs certain tasks relating to them), they want us to use something based on what they use internally. So they gave me an excel document, which I am trying to recreate in Notes (so that certain critical pieces of data are saved in the Notes database).
However, the Excel document has many, many column, row and cells that are hidden based on values in other cells.
I can mimic that functionality in Notes but only based on field values, and I don't want to save (or create) all these fields in the Notes database. They are unneccessary and there are a large number of them (probably a hundred or so, in addition to the ones that actually do want to save).