Display Lotus Notes Document field

45 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bllittle
    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.
    45 pointsBadges:
    report
  • Stiletto
    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.
    4,065 pointsBadges:
    report
  • Bllittle
    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.
    45 pointsBadges:
    report
  • Edvabnik
    You can activate advanced menu (under menu view) to see additional item as "create - computed text"
    75 pointsBadges:
    report
  • Bllittle
    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.
    45 pointsBadges:
    report
  • Bllittle
    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. ;-)
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following