Text format with line-through

rbross

Hello,
Is there a way to format the font in a query to have the line-through style?
I have a query that shows Donation batches and when a batch is posted I was thinking of have the font have the line-through style.
It is not one of the options for font styles in the BO under Style properties.
I tried adding some html for the line-through style but it is not working.

customaware

You may have the use a Custom Query Roger.

text-decoration: line-through; works when added to the attribute style on a Form but strangely does not show up in a Query even though use attribute style is checked.

customaware

Another alternative is to display html equivalents of the Attributes you want in the Query.

So the normal Attribute is Name then create another attribute called NameHTML and stuff the html/css styled version in there. Then display that in the Query.

rbross

Thanks Mark,
That would work but the field would need to be conditioned so if it was not posted it displayed the field normal and if it was posted it is displays it with the line-through.
Not sure you can have a IF statement on a field in a query?
You can have a field be conditional under styles settings in the BO, but line-through does not seem to work there for some reason?
For now I'll just change the color to be a light gray background and dark gray text color. Looks good and they will be able to tell easily that the batch is posted.

customaware

Here is one of mine and yes, it can be conditioned... but you conditional the update of the Attribute rather than the conditioning the css.

However...... If you have two css classes named, say myclassYes and myclassNo and then you have a Yes/No attribute then your can pick up a different class depending on the value of the attribute... if you know what I mean.

If ProjectSummary.SummaryLevel<>'AREA' Then
ProjectSummary.Finance_OriginalBudgethtml=<a href=+SystemSettings.CharQuote+#+SystemSettings.CharQuote+class=+SystemSettings.CharQuote+ProjectSummary.SummaryLevel+SystemSettings.CharQuote+onClick=+SystemSettings.CharQuote+AwareApp.startProcess2('VIEWOriginalBudget','ProjectSummary',+ProjectSummary.ID+,'new_tab')+SystemSettings.CharQuote+>+AS_STRING(ProjectSummary.Finance_OriginalBudget,'#,###;(#,###)')+</a>
ELSE
ProjectSummary.Finance_OriginalBudgethtml=<a href=+SystemSettings.CharQuote+#+SystemSettings.CharQuote+class=+SystemSettings.CharQuote+ProjectSummary.SummaryLevel+aw-decorated-grid-cell+SystemSettings.CharQuote+onClick=+SystemSettings.CharQuote+AwareApp.startProcess2('VIEWOriginalBudget','ProjectSummary',+ProjectSummary.ID+,'new_tab')+SystemSettings.CharQuote+>+AS_STRING(ProjectSummary.Finance_OriginalBudget,'#,###;(#,###)')+</a>

rbross

Nice!
I'll take a closer look.
This mean I would need an HTML attribute for each of the fields in the Donation Header BO.

customaware

Correct.

rbross

Is that the same technique you used to be able to Zoom from a field when clicked on like F5 in Magic?

customaware

Yep.

That code I posted is indeed exactly that.

rbross

To get your HTML text in the attribute did you just paste it into the initial value property in the BO?

customaware

No.... Update in a Rule whenever the sister attribute is changed

rbross

Right!
I was thinking about the name of the attribute not the value of the attribute for some reason. Thx