List questions

[Jberry]

Hi Everyone,

I have a few questions on lists. I'm just starting out (again) with them and because I find them confusing I give up and revert back to using grids so let me ask a few initial questions and once over this hurdle I can come back with more.

I created a list from a query:

(1) The first issue is that I can't get the currency values to format. I go to the Fields section of the list and in the Display Format, I put the format for currency. When the list runs the format is just straight numbers. Am I formatting in the correct place and if so, why isn't it displaying correctly?

2) On a grid I can put into the Bubble Help {Title} and when I hover over that field, the information in Title will display. Is there any way to accomplish the same thing in a List?

Thanks

-John

[lgrupido]

In the case of your numbers, you are formatting on the server side, but on the client side you selected ToNumber.

So it looks like you are overwriting your serverside formatting but then converting it to a number.

Instead, use the client side number display format. I think you'll find it works better for you.

[lgrupido]

As for bubble help, that is a "control" item. The list is a control in itself. You can have bubble help for the list, but not for individual items in the list so far as I know.

So that is a downside - but remember - lists were developed for use on mobile devices. And you can't really see bubble help on a mobile device anyway.

If your screen is never going to be viewed on anything but a big computer screen and you need bubble help, grids work fine. Lists have other cool features that make them better than lists in many ways, but not in that way.

[Jberry]

Thanks for the reply. I think I followed your instructions for the format. I removed the display format from the Server Side. On the Client-Side I changed Transform Data Type to None and I entered the display format into the Numeric Display Format (I didn't even notice that originally), however, if I now try to sort on the Budget field it isn't sorting correctly. I'm baffled :)

-John

[peteconway]

The answer: in your list layout - select Template and use this syntax.

<span title="{data:Lastname}"> {Lastname}</span>

Pete

[iRadiate]

I use my own bubble help popups in the list control all the time. You can even combine different fields to create some custom bubble help popups.

So for example, say my list has 3 fields called WEEKLYMECHQAID, CREATEUSER and CREATEDATE and when I hover the mouse over the the id field I want to display the id, the user who created the record and the date the record was created, I can do this:

List Custom Bubble Help.jpg

In the list properties, go to the OnItemDraw under Javascript - Render Time, the code for the above example is like this (modify your code accordingly):

List onItemDraw.jpg

[Jberry]

Thanks all, I'll try these today.

[peteconway]

You can access any number of data fields in the title.
Title.png