Right alignment of numbers in an Attribute

RLJB

I have a simple invoice that has 3 Number attributes. Each attribute is calculated, I have them formatted as $#,##0.00. Typically dollar amounts are right aligned in their "cell" so as the dollars and cents all line up and look nice.

How can I get the number in the attribute to align on the right hand side of the form element?

Thanks

R.[/img]

aware_support

You cannot do this at the moment for editable fields. If the field is not editable, you can present it in the HTML cell and use HTML styles to right-align it.

RLJB

Thanks, I have now done this. Which leads to the next question:

I have a rule that calculates this subtotal as follows:

Invoices.SubTotal=SUM InvoiceLines.Amount WHERE (InvoiceLines IN Invoices.LineNumber)

The rule is set to Dynamic, so previously (when I wasn't using an HTML cell) the Invoices.Subtotal was updated every time I saved a new InvoiceLine - which is perfect.

Now I'm using the HTML cell the Invoices.Subtotal only sums when the invoice is saved (not the Invoice Line). The rule is still set to dynamic.

Is there a way to make the HTML cell update as the normal cell used to?

Thanks

aware_support

No, not at the moment. Adding this to the list of issues to fix...

aware_support

This has been fixed in version 4.9

BobK

😃 I was really looking forward to HTML cells being dynamically updated, but it is not working for me. Is there something new that needs to be done to get HTML cells to dynamically update.

Here is my HTML:
<table frame="border" bgcolor="#ededed" width="125" height="20"><tr><th style="text-align:right"><<BO.Total>></th></tr>

Here is the rule to calculate the field:
BO.Total=ROUND(BO.Count*BO.Rate,2)

Thanks.

tford

Hi Bob,

FYI -- I have successfully dynamically update a simple HTML cell like:

Total: <<Country.Total>>

Is your rule set as a dynamic rule?

tford

I was also able to get your HTML to dynamically update successfully in my BO:

BobK

Thanks Tom,

Yes, my rule is set to dynamic, I forgot to mention that in my earlier post.

Since this is working for you, I started thinking what else might be the problem. I now think it might be a browser (Firefox) issue. I usually use Firefox, where this is not working. But it is working for me in Internet Explorer.

BobK

I am still having problems with the dynamic update of HTML cells.

I have a simple bsv with 1 Business object which has 7 numeric Attributes:
GrandTotal
RateA
RateB
TotalA
TotalB
UnitA
UnitB

Attributes GrandTotal, TotalA and TotalB are all calculated.

I only have the following 3 rules which are all set to 'use rule in dynamic re-calculation on forms':
BO.GrandTotal=BO.TotalA+BO.TotalB
BO.TotalB=BO.UnitBBO.RateB
BO.TotalA=BO.UnitABO.RateA

On the Form GrandTotal, TotalA and TotalB are displayed in HTML cells with the HTML similar to the following:
<table frame="border" bgcolor="#ededed" width="125" height="20"><tr><th style="text-align:right"><<BO.TotalA>></th></tr>

When creating an object, I enter a number in UnitA
Tab to RateA and enter a number
Tab to UnitB and TotalA and GrandTotal update correctly
Enter a number in Unit B
Tab to RateB and TotalA and GrandTotal disapear
Enter a number in RateB
Tab out of RateB and TotalB updates correctly but GrandTotal displays the same amount as TotalB.
Press the create button.

Go find the record and display it
All fields show the correct values.
Change the number in UnitA
Tab to RateA and TotalA and GrandTotal update correctly
Tab to UnitB and nothing changes correctly
Change the value of UnitB
Tab to RateB and TotalA reverts back to its previous value, TotalB updates correctly and GrandTotals = the previous value of TotalA + the correct value for TotalB.

FYI: this was all done in Firefox. I get similar results in Internet Explorer and Chrome

Sample bsv is on the way to support

BobK

HTML cells are now dynamically updating correctly.

THANK YOU