Solved

Not able to bypass values in field

Posted on 2004-08-10
5
184 Views
Last Modified: 2013-12-18
Hi Guys

OK

Well I have a field client
When a document is created,  client is automatically updated by a hidden field that sets the Username. Client_1 also does many lookups and fills in several other fields

However there is occasion where Client is written to manually

The problem is client_1 keeps resetting the client field to it value

Client_1 is above the Client field and contains FIELD client := key;(Key is a value either input computed or pulls from User ID)
Client contains @If(@IsNewDoc & client = "";client_1;client != client_1;client;client)
0
Comment
Question by:imjamesw
  • 4
5 Comments
 
LVL 31

Accepted Solution

by:
qwaletee earned 500 total points
ID: 11766406
James, slow down!  Hard to understand you this time.

Sounds like you need several fields:

Client_1 to do the calculation
Client_Override for a user to enter a different value
Client to contain the actual current values -- calculated to @If(Client_Override = ""; Client_1; Client_Override)

This way, if user types something in, that value will be used, else, the default value will be used.

0
 

Author Comment

by:imjamesw
ID: 11767091
Hi there

Here is what I did

Added Client_Override field after Client_1 but before client
Added a button that sets Client_Override to new value,also sets new client field value
Added @If(Client_Override = ""; Client_1; Client_Override) to client field

Pushed button entered new name,the name changed until I left the field the it recalculated to original value(BAD)

Sub Click(Source As Button)
      Dim workspace As New NotesUIWorkspace
      Dim s As New NotesSession
      Dim db As NotesDatabase
      Dim Doc As notesdocument
      Dim UIDoc As NotesUIDocument
      Dim NewName As String
      Set db = s.CurrentDatabase
      Set UIDoc=workspace.CurrentDocument
      Set Doc = UIDoc.Document
      
      NewName =Inputbox$("Enter a new name for this Security Access request.")
      doc.client_overide = NewName
      doc.client =NewName
      Print doc.client_overide(0)
End Sub

0
 

Author Comment

by:imjamesw
ID: 11767112
I believe it is the FIELD client := key; in the client_1 that is the culprit
0
 

Author Comment

by:imjamesw
ID: 11767505
Got it
0
 

Author Comment

by:imjamesw
ID: 11767547
I modofied the FIELD client := key

FIELD client := @If(client_override = "" ; key; client_override);



THAnx
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Lotus notes forward mail problem 5 345
Lotus Notes - Broken Links report 5 194
Lotus notes VB code 4 200
Bulk lotus notes account creation 3 68
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now