We have a number of transactions where we have a counter (i.e. Sales Order, PO Number, etc). We start a new client at 0. We have control over the formatting of a number so the thousands separators can be removed in the display of the Servoy field. i.e., PO # 15700. The problem comes when we built a list of sales orders or PO’s in a table. We need to be able to get a click on the sales order or PO number and in a table we can only do this using a label. The problem with the label is we can’t find anyway to control the thousand separator from displaying when a label is used. We don’t want to use HTML because then the line in the table doesn’t show when it is selected. In a table we get PO # 15,700 (Using a label). Any ideas how to solve this would be greatly appreciated.
We don’t want to use HTML because then the line in the table doesn’t show when it is selected.
I don’t know how many lines you are talking about but you could use a link with a method attached for eacht line so that the selected line is handed over to the method and the method builds the table again with a background for the selected line.
Or you just create a calculation that formats the number in the format you want and returns a string. Put that on the label and you are done.
patrick:
Or you just create a calculation that formats the number in the format you want and returns a string. Put that on the label and you are done.
Even better, should have thought of that!