Solved

Default value help!

Posted on 2003-11-03
10
222 Views
Last Modified: 2013-12-18
I have 2 fields on my form abtnm & abtnmR, for both the default value is "".  Field abtnm's value (text) is chosen, by the user,  via a dialog list that uses a @DbColumn fucntion for choices.  Field abtnmR's value can also be chosen via a dialog list that uses a @DBlookup function based on the value of abtnm for choices, OR it can be left blank.  

I want the value of abtnmR to default to the value of abtnm if the field is left blank.

How can I do this?
0
Comment
Question by:rognyn
  • 5
  • 4
10 Comments
 
LVL 14

Accepted Solution

by:
p_partha earned 250 total points
ID: 9672900
Ok in the abtnm field's input translation just put this:
field abtnmR:=@if (abtnmR ="";abtnm;abtnmR);abtnm

Let me know whether this is what u wanted...

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9672977
I would rather set the field value in abtnmR Input translation.

@if( @Trim(abtnmR) = ""; abtnm; abtnmR)

~Hemanth
0
 

Author Comment

by:rognyn
ID: 9673476
Actuall both worked.........I chose the first.
You guys make this look sooooooeasy!
Thanks...
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9673577
So can we get the points :-)

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9673802
I know both will work, but you know why I suggested that path... Guess ?
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 14

Expert Comment

by:p_partha
ID: 9673933
Hemanth,

i am not sure why u said that, but what i thougth was if the user clicks the cursor into any other field apart from abtnmR, after choosing the abtnm field then ur logic may not work... Just a thought.. but would love to hear ur side comments

Partha
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9673987
But i realized that input translation fires when the page is refreshed, so ur thing also shd work...

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9674030
Simple, whenever the problem occurs in that field like field blanks out (like you would have seen lot in this forum) and first guess is to check the current fields translation or validation...Right ! So it is most of a design standard rather than personal choice.
0
 
LVL 14

Expert Comment

by:p_partha
ID: 9681946
Is it abandoned.....


Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9682228
on vacation ?
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

18 Experts available now in Live!

Get 1:1 Help Now