Solved

Percent Sign upon user input - Numeric Fields

Posted on 2004-08-31
4
243 Views
Last Modified: 2013-12-18
Hi experts,
I have several editable numeric fields formatted as % in a form.
For user "ease" I am trying find a solution to enable a "%" to be appended to the number that the user inputs, to eliminate notes translation ie. 5 to 500%, and the user not having to put % after everything they enter.

Any Suggestions ??

Thanks
Craig.
0
Comment
Question by:cwtaylo
[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
4 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 11940869
U have answer in ur question.

Try using Input translation
@Text(Urfieldname)+"%"

or what ur looking exactly?
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 125 total points
ID: 11941567
It is not possible to append % and still keep the value of the field as numeric...What you can do is enable percent for the field... but in input translation divide the field value by 100.

eg:

numberfield/100

~Hemanth
0
 

Expert Comment

by:robb3369
ID: 11942357
If the percentage value is always less than or equal to 100%, then try adding this in the field translation:

@If(@ThisValue>1;@ThisValue/100;@ThisValue)


Rob
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 11943277
I would add a separate computed notation right next to the main field, in a different font, that shows the value entered as a per cent value, inlucding the % symbol.  That way, there are no issues of input validation, number conversion, applying the % reduction more than once (20 -> .2 -> .002), etc.  User enters 15, an right next to it you have the text "%", and right next to that, you have a parenthetical (0.15).
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes email code 6 127
Lotus Notes Database "Invalid NSF Version" 5 2,267
Scan to Email - HP 477 Printer and Lotus Notes 8 100
Lotus Notes shared mailbox 'Sent by' in header 3 155
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
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

739 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