Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Default value help!

Posted on 2003-11-03
10
Medium Priority
?
232 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 14

Accepted Solution

by:
p_partha earned 1000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

596 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