Temporary fields in form

HCL Domino Domino Forum
1

Is there any way to create a temporary field on a Notes document (aside from a computed field that isn’t editable)?Maybe some kind of work-around or something?

I’m trying to recreate an Excel document in Notes. The excel doc has all kinds of drop-downs etc that then hide other rows, cells etc.

There are literally hundreds of these “fields” and I don’t want to create new fields for them all in the Notes database.

Thanks,

2

Subject: Temporary fields in form

I’m going to assume you’re reading an Excel file sitting on a drive or network share and converting each row of the Excel file into a Notes document.

If that’s true, why not use OLE to import just the fields you need rather than dealing with all the crap you don’t want? OLE examples are available in this forum, the 4/5 forum, the Sandbox,and probably at OpenNTF.org.

If that’s not true, can you provide more detail about what you’re doing?

3

Subject: RE: Temporary fields in form

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).

4

Subject: RE: Temporary fields in form

If you decide to create a field (to mimic a cell), you can make it computed for display. That is effectively a temporary field, since it will not be saved to disk.

but, it sounds like you are going to have to find an appropriate way to translate the excel functionality to notes…

5

Subject: RE: Temporary fields in form

The user has to be able to select a value in each of the fields but maybe I can find some other means of filling them like a button or something.

Gonna be a lot of extra work though…

Thanks!

6

Subject: Temporary fields in form

How are you doing the import? Have you tried using a col file?