If Statement in List Control, List Layout

[Mike Reed]

Hi have a list control that I want to add an if statement to in the list layout section.

I cannot seem to find the correct format to use to get the layout to display properly.

Here is my code:

<div style="display: table; width: 100%;">
<div style="display: table-cell; vertical-align: middle;">
</div>{short_name} </div>
{*if creditcard == 'T'}
<strong>Starting:</strong> {Session1} <strong>Location: </strong>{location_name}, {location_city} <strong>Balance Due: </strong>{Balance}&nbsp;&nbsp;{PayNow}

{*elseif creditcard == 'F'}
<strong>Starting:</strong> {Session1} <strong>Location: </strong>{location_name}, {location_city} <strong>Balance Due: </strong>{Balance}

{*endif}
</div>

</div>

There is a field named {creditcard} that is a logical field. In the above code, I am trying to show the {PayNow} button if {creditcard} is true.

I have tried *if statement with using 'T' or 'true'. Tried with '1' and '0'. I have tried using the {} around the field name, but then nothing appears. I don't know the format to use.

Can someone help me with that?

Thanks,

[madtowng]

Hi Mike,

Have you tried using true and false (no quotes) ?

[Ted Giles]

Mike, I think it's .t. or .f.
It is in Desktop anyway. The dots are important.

[madtowng]

I'm 99% certain the templating uses javascript for the if/then/else commands.

[Lance Gurd]

Templating is the same in lists as it is in viewboxes I have a table with a tinyint(1) record called RETURNED in a table and the following code returns a checked checkbox in a row of a list in a viewbox

{*if RETURNED=='T'}
                    <img src="svgIcon=#alpha-icon-checkSquareBorder:icon,24{ fill: #4d73f7; stroke: #f5fa22;}" >    
                {*endif}​
​

[Russell Craycraft]

It sounds to me like you need to go to the client-side show/hide, and filter the button there.
I have attached an image with the syntax used as well.
Also, you may need to use the Chrome inspector, and see what the actual value is behind the scenes. Sometimes Alpha will change them, or Chrome will...I don't know which or for what situations.

[Mike Reed]

I have tried using the client show/hide. but that doesn't work. Using the {*if RETURNED statement doesn't work. using the .t. or .f. does work either, no surprise because it wants javascript
I'm at a loss to figure this out.
Next step will be to send an email to Selwyn to see what he has to say.

Thanks for your help.
Mike

[Ted Giles]

What does your logical field actually contain?
What value are you testing against?

[Lance Gurd]

Hi Mike,

Let's start at the beginning. Which database are you using?

[Lance Gurd]

Hi Mike,

Try this, go to the template tester and enter this into the JSON Data section

[{
    "short_name":"Lance",
    "creditcard":"T",
    "Session1":"3/8/2023",
    "Balance":250,
    "location_name":"Office",
    "location_city":"Southampton",
    "PayNow":"<Button>Pay Now</Button>"
},
{
    "short_name":"Mike",
    "creditcard":"F",
    "Session1":"1/8/2023",
    "Balance":1250,
    "location_name":"Home",
    "location_city":"Boston",
    "PayNow":"<Button>Pay Now</Button>"
}
]​

Then this into the template section

<div>{short_name}</div>
<div>
{*if creditcard=='T'}
<strong>Starting:</strong> {Session1} <strong>Location: </strong>{location_name}, {location_city} <strong>Balance Due: </strong>{Balance}&nbsp;&nbsp;{PayNow}
{*elseif creditcard=='F'}
<strong>Starting:</strong> {Session1} <strong>Location: </strong>{location_name}, {location_city} <strong>Balance Due: </strong>{Balance}

{*endif}
</div>
​

You should see this in the preview window

Lance
Starting: 3/8/2023 Location: Office, Southampton Balance Due: 250  Pay Now
Mike
Starting: 1/8/2023 Location: Home, Boston Balance Due: 1250​

[ecalan]

I have had some trouble with logical fields as well. It seems Alpha treats them "uniquely." Have you tried either, 1. using a tinytext field instead and setting a 1 and 0 in the app instead of true false or 2. creating an SQL if expression that converts the true false to a character field and then doing your show hide with the result of the expression?

[Mike Reed]

Hi,
Lance I tried what you had posted. Thank you for that. Using the template tester everything worked fine. But once posted to the website - no dice. Tried in Safari and Firefox
So I tried what Ecalan suggested. I changed my query for the list control to this: SELECT *, CAST(creditcard AS char) as cc FROM unpaidfees WHERE regid = :regid. - Basically I added the cast command
Had to uncheck the 'Portable SQL' box in order for the cast command to work.
Then I changed the IF statement to {*if cc=='1'}

It works!

Gentlemen Thank you so much. I have struggled with this for months and now it works.

Peace,

[ecalan]

Mike, your solution using CAST to change the field type is probably better than my suggestion of using IF. Less server computation burden I think. I seem to recall that when I first did this, I could not get CAST to work. I know I was unaware of the portable SQL issue. (Thanks for that education). Since then, and until someone explains to me the virtue of using a logical field instead of tinytext for 1s and 0s, I'm sticking with tinytext. (Perhaps the explanation is on its way).

Glad you got it working!

[Russell Craycraft]

Mike Reed, Can you send an image of your code and where it is? I use if/else statements all the time in lists and could help you. I can also send you a Zoom link if I can't help you over the forum, if you need this expedited.

[Mike Reed]

Hi Russell,
I have an attached the component in a zip file. If you need a sql file to go with it, I'll send that via email since it has some personal info in it.
The code is in the 'UnpaidFees' List control, List layout.

Thanks for your help.

Mike