Format Value list

[Anuviel]

Could not find this, if there is a thread about this please point me in the right direction.

I have a value list that displays only related data. It shows data from 2 fields. First field is text and the second is number (formated as currency). The field in which it resides is text. Value list itself works perfectly. the problem is that is shows:

Item1 6

Item2 7

Item3 8

How would I format it to show

Item1 $6.00

Item2 $7.00

Item3 $8.00

or

Item1 - $6.00

Item2 - $7.00

Item3 - $8.00

[Lee Smith]

FileMaker will only store what is actually in the Field.

In other words, the value list is reflecting what was entered. It does not reflect the trailing zeros, even if you have formatted the field that way. Try typing in $6.00 in the field and see what shows.

6 will be 6

$6.00 will be $6.00

HTH

Lee

Edited March 28, 2008 by Guest

[comment]

You could create a calculation field (result is Text) =

"$" &

Int ( Number )

& "." &

Right ( "00" & Number * 100 ; 2 )

and use it in your value list.

[Anuviel]

Wow - beautiful and simple. Thanks so much. Works perfectly.

Since on the topic how would I align the value list?

Instead of showing:

Value1 $5.00

LongerValue $6.00

To show:

Value1      $5.00

 LongerValue $6.00

Edit: I could just add empty spaces in my text calc and align it that way (I know what longest value will be but I would rather have it formated as shown to the longest value currently in the list)

Edited March 28, 2008 by Guest

[Anuviel]

Thanks, good to know.

[comment]

I don't think that's possible. You might consider other options, such as popping up a new window with a list view or a portal with the values for the user to select from.

[Anuviel]

The value list is in portal already. Will just have to do without it being aligned. It would be a cool feature if it would be possible.

Thanks.,

[comment]

The value list is in portal already.

I presume you mean the field to set is in a portal. I don't see why it would matter. You can still format the field as a button that will pop up a new window, wait for user to select a value, and set the clicked field to the selected value.

[Anuviel]

Yes, the field is set in a portal. It is to enter line items (orders) so it is useful when someone wants to order item X they enter X and tab into the next field (the value list) and it shows available vendors and costs. I just wanted to try to align as it looks better visually - easier to see.

I am thinking if I set it up as you suggested - I will loose on the speed of input by the user as orders can sometimes have up to 100 items. I will test it out, rather will give it to end users to test to see what they like better and will decide based on they say.

[comment]

Well, you cannot align a value list, so something's gotta give. If you want speed, maybe you should have the other portal permanently available on the layout, and have a script create a line item when user clicks on a product.

[Anuviel]

Thanks., will keep the un-aligned value list.