Solved

Information disappearing from Application

Posted on 2003-10-26
15
210 Views
Last Modified: 2013-12-18
Hi there

I'm newie to this area.

Creating a helpdesk application - User must enter details of a new call .  He/she must enter what type of call it is.  This is based on 3 fields. (Based on generic list created by administration)

Category
-sub-division of - (Category) -> RequestType
-sub-division of - (Category) +  (RequestType) ->
Service Type

e.g.
example 1
How To
->Desktop
-(How To) + (Desktop) ->Monitor

Do you follow........

Administration Set-Up is this.
3 forms - one for each Division - 1 field for each
Final form - where create all options - using comboboxes

Division1                   -2                    -3
How To                     -Desktop          -Monitor

Noticed - if I enter anything and save it - later all information disappears ?

Why ?

Imrane.





Category field









0
Comment
Question by:ImraneA
  • 6
  • 4
  • 3
  • +1
15 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9622276
Notes or browser?
Notes version?
Fields and code please...

My guess so far: a faulty formula in the Input Translation object of those fields
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9622347
Probably it is your field's default value formula which is overriding the changes. Give the formulas for those fields.

~Hemanth
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9622721
This MAY be due to the way comboboxes work.  Comboboxes can nly display values that are "available to pick from."  For example, say I design a simple combobox that takes values 1,2,3.  User select "2."  Later someone decides they like letters better than numbers, so the  form design changes to allow A,B,C instead of 1,2,3.  All existing documents will display blank values for the combobox, because the combobox can only display A,B,C, and 2 is not a member of A,B,C.  (And, if you re-save the document at that point, the value does indeed change to balnk, since the display-lank combobox saves its vakue over the field.)

IN your situation, you have computed the set of choices for the comboboxes. if, for whatever reason, at form load time, the choices are not set up, or not set up to include teh stored value, then the combobox will display blank, and later save that blank value.

[NOTE: This often happens when a programmer, for performance reasons, creates the choice set as @If(@IsDocBeingLoaded;@UnAvailable; ".... real choices ...") so that no lookups are performed when the form loads.]

A goof trick is to make sure that teh current value is always displayed as a choice.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:ImraneA
ID: 9625944
To - sjef_bosman

1.Notes or browser? - Notes
2.Notes version? - 5.0.12
3.Fields and code please...

Category_A,ComboBox,Editable,Refresh fields on keyword Change (ticked),Formula :-
@DbColumn("":"NoCache" ; dbname ; "vwCategory" ;1)
vwCategory - list of all Unique Categories
Input Translation - @Trim(Category_A)
----
RequestType_A,DialogList,Editable,Refresh fields on keyword Change (ticked),Formula :-
FIELD Category_A:= Category_A;
res:=@If(Category_A="";"";@Unique(@DbLookup("":"Nocache";"Tecnetdev1":"weirtech.nsf";"firstcut";Category_A;2)));
@If(@IsError(res);"";res)
firstcut - 2 columns - Category, RequestType
Input Translation - @Trim(RequestType_A)
----
ServiceType_A,DialogList,Editable,Refresh choices on document refresh(ticked),Formula :-
FIELD RequestType_A:= RequestType_A;
key:=Category_A+RequestType_A;
res:=@If(RequestType_A="";"";@Unique(@DbLookup("":"Nocache";"Tecnetdev1":"weirtech.nsf";"secondcut";key;2)));
@If(@IsError(res);"";res)
secondcut - 2 columns - Category+RquestType, ServiceType
Input Translation - Trim(ServiceType_A)

4. guess so far: a faulty formula in the Input Translation object of those fields - input translation look ok !!! What do u think ?

0
 

Author Comment

by:ImraneA
ID: 9625948
To -  HemanthaKumar

1."Probably it is your field's default value formula which is overriding the changes. Give the formulas for those fields. " - see comment for sjef_bosman

0
 

Author Comment

by:ImraneA
ID: 9625963
To -  qwaletee

1."A goof trick is to make sure that teh current value is always displayed as a choice.
" - can u explain this please.

Are u saying make my fields computed ? currently editable???

"Category_A,ComboBox,Editable,Refresh fields on keyword Change (ticked)
----
RequestType_A,DialogList,Editable,Refresh fields on keyword Change (ticked),
----
ServiceType_A,DialogList,Editable,Refresh choices on document refresh(ticked)

0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9625995
Hope you didn't forget Refresh choices on ducument refresh for RequestType_A
0
 

Author Comment

by:ImraneA
ID: 9626028
T0 -  sjef_bosman

Well spotted - forget to write that down..
0
 
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 70 total points
ID: 9626041
Category_A,ComboBox,Editable,Refresh fields on keyword Change (ticked),Formula :-
@DbColumn("":"NoCache" ; dbname ; "vwCategory" ;1)
vwCategory - list of all Unique Categories
Input Translation - @Trim(Category_A)
----> looks okay to me

RequestType_A,DialogList,Editable,Refresh fields on keyword Change (ticked),Formula :-
res:=@If(Category_A="";"";@Unique(@DbLookup("":"Nocache";"Tecnetdev1":"weirtech.nsf";"firstcut";Category_A;2)));
@If(@IsError(res);"";res)
firstcut - 2 columns - Category, RequestType
Input Translation - @Trim(RequestType_A)
----> okay, but tick Refresh choices on document refresh!!

ServiceType_A,DialogList,Editable,Refresh choices on document refresh(ticked),Formula :-
key:=Category_A+"~"+RequestType_A;
res:=@If(RequestType_A="";"";@Unique(@DbLookup("":"Nocache";"Tecnetdev1":"weirtech.nsf";"secondcut";key;2)));
@If(@IsError(res);"";res)
secondcut - 2 columns - Category+"~"+RquestType, ServiceType
Input Translation - Trim(ServiceType_A)
----> seems okay, but add an additional character inyour column formula, to be on the safe side (example: categories large and largedish, requests washer and dishwasher, you would get largedishwasher twice!)
0
 

Author Comment

by:ImraneA
ID: 9626058
Question to Experts

One application I have seen - where u have generic lists - developer has added number field

e.g.

Current Set-Up
Category

Alternative

ID Category
00 Category Item 1
01      "           "   2

So, point here, if I add these columns in would they solve my problem - or is that going in another direction...
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 9626120
Thought you were losing information? Can't see how this would solve the problem, it will only add some complexity...
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9627216
Remove input translations from all of the fields. You are doing lookups using as it is keys from view if you change them you will loose the information. THis can be tested by hitting F9 key
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 110 total points
ID: 9627505
The @trim in input translation removes extra spaces from all three field.  If teh fields, when originally looked up, had those spaces, then the @Trim changes the value.  The change in spaces causes the "current value" to fall out of the field's domain, and thus be excluded from display.  This is more or less what I was saying in the previous comment.

If there were no extra spaces, then the @Trim has no effect, and is not the source of the problem.

To be sure, you may want to use @If(@IsError(res);"";@Trim(res)) instead of @If(@IsError(res);"";res) in your choices formula.

And, as you were asking how to implement my "goof suggestion" (er, good sugestion!)...

@If(@IsError(res);"";@Trim(@Unique(res : Category_A))) -- obviously, this is for the first field, change it for the second and third fields.  That way, if the current value for Category_A is not an exact match for the returned lookup values, it STILL is valid as a choice, because the current value is alwats appended to the available selections.
0
 

Author Comment

by:ImraneA
ID: 9634711
To - HemanthaKumar +  qwaletee

Seems to have done the trick - so far no disappearing data.  But, now I have refresh problem.
e.g.

Select - first time

Category         ->How To
RequestType   ->Access Email
ServiceType    ->(Blank Selection)

Reselect
RequestType   -> Copier
ServiceType    ->(Blank Selection)

In the Dialoglist for ServiceType -> Access Email appears, when in fact it should not.

Had got this working nicely before but not now...

Any ideas... most helpful.





 
0
 
LVL 24

Assisted Solution

by:HemanthaKumar
HemanthaKumar earned 70 total points
ID: 9635166
This is a kind of exposure that it will open up when you do multiple refreshes... there is no way the second field will know that the key field has changed. One way to approach this is to preserve previous value of the key field and check if it has changed on doc refresh and clear the content accordingly. THis is costly and time consuming.


0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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