Autofills

Below is a list of helpful autofills you can use to customize templates:
''If you require a list of the possible fields please add "/field_names.a4d to the server URL e.g. "http://payg.ezadspro.co.uk/field_names.a4d"

If a field is not in use then use another

<%If([Lineage]internet_description="")%> <%write("{{character2}}"+[Lineage]Strap_line+", "+[Lineage]PropertyAddress+", "+[Lineage]Area+", "+[Lineage]Town+", "+[Lineage]County+"{TAB}")%> <%else%> <%write("{{character1}}"+[lineage]internet_description)%> <%end if%> i.e If internet description is not in use then apply style character2 followed by the strap line, address, area, town and county. Otherwise use character1 style and the internet field

Formatting a numeric price
<%=string([lineage]numericprice;"£###,###,##0")%> i.e user inputs 342455 and £342,455 is outputted

Formatting an abbreviated year
\U2019<%substring([Lineage]Year;3;2)%> i.e user inputs 2016 and 16 is outputted

If a flash exists
<% If([Lineage]flash_1#"") %><% write([lineage]flash_1) %><% else %><% write([lineage]price)%><% end if %> i.e (Flash 1 contains text) - SOLD i.e (Flash 1 is empty) - £20,000

Change a flash character style by text
<% If([Lineage]Flash_11="brown”)%><% write("{{brown}}" + [Lineage]Flash_11) %><% else %><% write("{{red}}"+[Lineage]Flash_11)%><% end if %> i.e user inputs "brown" into Flash 11 - The flash uses character style "brown" Otherwise any other text into the flash it will use the "red" character style

Changing order by text

query selection([lineage];[lineage]bodytype="Truck";*) query selection([lineage];|;[lineage]bodytype="Van";*) query selection([lineage];|;[lineage]bodytype="SUV") order by formula([lineage]; lowercase([lineage]make); >; lowercase([lineage]model); >; PM2_Order_Zero_At_End([lineage]numericprice); multi-sort using the workflow pagination section that will filter out trucks, cars, and vans and then sort them by make, model, and price