Home > IT Answers > Lotus Domino > Display Lotus Notes Document field
Bllittle
45 pts.
 Display Lotus Notes Document field
Document Fields, Lotus Notes, Notes
I know this is probably really basic and simple, but have searched through various boards for 2 days and haven't found an answer.

I would like to create a table in a Notes mail document (Stationery) that displays some of the document's field values. I have created hot spot buttons that allow me to choose acceptable values for document fields, but would like to then display those in the table. I've played around with programmable tables but can't seem to get values displayed dynamically.

any pointers to resources or rough examples of how it can be done would be much appreciated.

Thanks!

Bruce



Software/Hardware used:
Lotus Notes
ASKED: October 31, 2011  10:24 PM
UPDATED: November 4, 2011  8:57 PM
RELATED QUESTIONS
Answer Wiki:
Not really clear on what you're trying to do, but try looking at one of the following approaches: 1) use a "computed for display" field to display the value of the field you're interested in - So, you'd have a field called dspFld1 (for example) and the formula for it could be @GetField( "Salary" ) Or, it could be @GetField( VariableThatContainsStringNamingAnotherField ) 2) use "computed text" to do the same thing as above. If things don't seem to update properly (or dynamically enough) for you, you may need to add @Command([ViewRefreshFields]) to the code behind your button(s).
Last Wiki Answer Submitted:  November 1, 2011  1:31 pm  by  Stiletto   2,700 pts.
All Answer Wiki Contributors:  Stiletto   2,700 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

OK, I tried this by the following:

In my table properties, I went to the cell’s Cell Image source, I put:

 @GetField("iAssignee").

In the button, I have: 

Assignees := "Name1" : "Name2"  (etc);
Assignee := @Prompt([OkCancelEditCombo]:[NoSort]; "Analysts" ; "Please choose an analyst for this overall issue (can be different from action item assignee)"; "Name1";  Assignees);
@SetField("iAssignee"; Assignee);
@Command([ViewRefreshFields]);

I realize that cell image is supposed to be for inserting a file but thought I might be able to use its computed value to pull in the field value. Alas, it is still simply a blank cell after update; when I look at the document properties and the fields stored, iAssignee is being properly stored, but the table still does not have any value in the cell I programmed.

I’m basically attempting to recreate functionality available in Outlook of creating a custom form within an email message. I used to design applications in Notes years ago (perhaps release 4 or so in about 1991), but since then I’ve been working for employers who used Outlook. Now I’m back at an employer using Notes and would like to recreate some of the ease of entry for internal clients when they have standard requests that I could provide to clients who used Outlook.

Thanks again for your guidance.

Bllittle
 45 pts.
 

Well, that’s not going to work, because (as you already know) the cell image property is for inserting a graphic. Notes is going to evaluate your @GetField and try to find a graphic file with that name to display. It’s not going to simply display the result of your code. So, unless you’ve got a graphic named “Name1″, this approach is DOA.

Instead, try placing your cursor in the table cell itself and choosing Create –> Computed Text… Put your @GetField there.

Stiletto
 2,700 pts.
 

Unfortunately, that option does not appear under the Create menu in my company’s installation. I’ve looked for it under other menues and sub menues, but it just doesn’t appear to be available to me.

I guess my hope of having this functionality it shot. Yes, the values can be stored, but without some means of providing the client with visual verification they’ve submitted the values they intended, that wouldn’t be acceptable.

I want to thank you, though, for your kind guidance.

Bllittle
 45 pts.
 

You can activate advanced menu (under menu view) to see additional item as “create – computed text”

Edvabnik
 75 pts.
 

thank you for the suggestion about Advanced Menues. I found that and it was already activated (checked). I tried unchecking it and looked again, then checked it again, but to no avail.

Bllittle
 45 pts.
 

OK, another thought. Is there a way to specify the Table and Cell addresses since I’ve named them and use a Write command of some kind?

There’s got to be more than one way to skin a cat as the saying goes. ;-)

Bllittle
 45 pts.