• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Not able to bypass values in field

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
imjamesw
Asked:
imjamesw
  • 4
1 Solution
 
qwaleteeCommented:
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
 
imjameswAuthor Commented:
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
 
imjameswAuthor Commented:
I believe it is the FIELD client := key; in the client_1 that is the culprit
0
 
imjameswAuthor Commented:
Got it
0
 
imjameswAuthor Commented:
I modofied the FIELD client := key

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



THAnx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now