Hi,
Does anyone have an idea how could I have the info bellow aligned:
<IF (Not IsEmpty({{.TownCountyTaxDescription#}}))>{{.TownCountyTaxDescription#}}: {{.TownCountyPeriod#}}
Full Tax: ${{.TownCountyFullTaxAmount#}} <IF (IsEmpty({{.TownCountySecondInstallmentDue#}}))>Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
<ELSE>
1st Inst: ${{.TownCounty1stInstallmentAmount#}} Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountySecondInstallmentDue#}}))>2nd Inst: ${{.TownCounty2ndInstallmentAmount#}} Due {{.TownCountySecondInstallmentDue# M}}/{{.TownCountySecondInstallmentDue# D}}/ {{.TownCounty2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountyThirdInstallmentDue#}}))>3rd Inst: ${{.TownCounty3rdInstallmentAmount#}} Due {{.TownCountyThirdInstallmentDue# M}}/{{.TownCountyThirdInstallmentDue# D}}/ {{.TownCounty3rdInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountyFourthInstallmentDue#}}))>4th Inst: ${{.TownCounty4thInstallmentAmount#}} Due {{.TownCountyFourthInstallmentDue# M}}/{{.TownCountyFourthInstallmentDue# D}}/ {{.TownCounty4thInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $
</IF>
<IF (Not IsEmpty({{.CityTaxDescription#}}))>{{.CityTaxDescription#}}: {{.CityTaxPeriod#}}
Full Tax: ${{.CityFullTaxAmount#}} <IF (IsEmpty({{.CitySecondInstallmentDueDate#}}))>Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}
<ELSE>
1st Inst: ${{.City1stInstallmentAmount#}} Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.CitySecondInstallmentDueDate#}}))>2nd Inst: ${{.City2ndInstallmentAmount#}} Due {{.CitySecondInstallmentDueDate# M}}/{{.CitySecondInstallmentDueDate# D}}/ {{.City2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.CityThirdInstallmentDate#}}))>3rd Inst: ${{.City3rdInstallmentAmount#}} Due {{.CityThirdInstallmentDate# M}}/{{.CityThirdInstallmentDate# D}}/ {{.City3rdInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $
</IF>
<IF (Not IsEmpty({{.SchoolTaxDescription#}}))>{{.SchoolTaxDescription#}}: {{.SchoolTaxPeriod#}}
Full Tax: ${{.SchoolFullTaxAmount#}} <IF (IsEmpty({{.School2ndInstallmentDueDate#}}))>Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.SchoolFullTaxPaymentStatus#}}
<ELSE>
1st Inst: ${{.School1stInstallmentAmount#}} Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.School1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.School2ndInstallmentDueDate#}}))>2nd Inst: ${{.School2ndInstallmentAmount#}} Due {{.School2ndInstallmentDueDate# M}}/{{.School2ndInstallmentDueDate# D}}/ {{.School2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.School3rdInstallmentDueDate#}}))>3rd Inst: ${{.School3rdInstallmentAmount#}} Due {{.School3rdInstallmentDueDate# M}}/{{.School3rdInstallmentDueDate# D}}/ {{.School3rdInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $
</IF>
<IF (Not IsEmpty({{.VillageTaxDescription#}}))>{{.VillageTaxDescription#}}: {{.VillageTaxPeriod#}}
Full Tax: ${{.VillageFullTaxAmount#}} <IF (IsEmpty({{.VillageTaxSecondDueDate#}}))>Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.VillageFullTaxPaymentStatus#}}
<ELSE>
1st Inst: ${{.Village1stInstallmentAmount#}} Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.Village1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.VillageTaxSecondDueDate#}}))>2nd Inst: ${{.Village2ndInstallmentAmount#}} Due {{.VillageTaxSecondDueDate# M}}/{{.VillageTaxSecondDueDate# D}}/ {{.Village2ndInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $
</IF>
Water / Sewer: <IF ({{.TypeOfWater#}}=”Public”)>{{.TypeOfWater#}} (Account #)
Amount: ${{.WaterAmount#}} Due {{.WaterDueDate# M}}/{{.WaterDueDate# D}}/ {{.WaterPaymentStatus#}}
<ELSE><IF ({{.TypeOfWater#}}=”Private”)>{{.TypeOfWater#}}
<ELSE><IF ({{.TypeOfWater#}}=”Vacant Land”)> N/A - Vacant Land
<ELSE><IF ({{.TypeOfWater#}}=”Under Construction”)>Public When Improved
<ELSE><IF ({{.TypeOfWater#}}=”Nassau / Suffolk”)>Not Searched – Homeowner should present bill / receipt @ closing.
<ELSE><IF ({{.TypeOfWater#}}=”Missing Info”)>To Follow
<ELSE><IF ({{.TypeOfWater#}}=”Condo”)>Common Charges
<IF></IF></IF></IF></IF></IF></IF></IF></IF>
An example of the way I want it to look is:
200 Town / County Tax: : 1/1-12/31 200
Full Tax: $.00
1st Inst: $.00 Due 1/1/ Paid
2nd Inst: $.00 Due 7/1/ Paid
Tax W/O Exemption: $
Thanks
Aligning information in an IF statement
Re: Aligning information in an IF statement
That's a tough example, I believe one just needs to be crazy about where they put hard returns. Can't really test your formula, with the custom fields. Could you show us the what the output of your formula looks like? What is being misaligned?
Here's my best guess without any testing.
Hope it formats good for you,
Dan Van Fleet
Here's my best guess without any testing.
Code: Select all
<IF (Not IsEmpty({{.TownCountyTaxDescription#}}))>{{.TownCountyTaxDescription#}}: {{.TownCountyPeriod#}}
Full Tax: ${{.TownCountyFullTaxAmount#}} <IF (IsEmpty({{.TownCountySecondInstallmentDue#}}))>
Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
<ELSE>1st Inst: ${{.TownCounty1stInstallmentAmount#}}
Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountySecondInstallmentDue#}}))>2nd Inst: ${{.TownCounty2ndInstallmentAmount#}} Due {{.TownCountySecondInstallmentDue# M}}/{{.TownCountySecondInstallmentDue# D}}/ {{.TownCounty2ndInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountyThirdInstallmentDue#}}))>3rd Inst: ${{.TownCounty3rdInstallmentAmount#}} Due {{.TownCountyThirdInstallmentDue# M}}/{{.TownCountyThirdInstallmentDue# D}}/ {{.TownCounty3rdInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountyFourthInstallmentDue#}}))>4th Inst: ${{.TownCounty4thInstallmentAmount#}} Due {{.TownCountyFourthInstallmentDue# M}}/{{.TownCountyFourthInstallmentDue# D}}/ {{.TownCounty4thInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.CityTaxDescription#}}))>{{.CityTaxDescription#}}: {{.CityTaxPeriod#}}
Full Tax: ${{.CityFullTaxAmount#}} <IF (IsEmpty({{.CitySecondInstallmentDueDate#}}))>
Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}<ELSE>1st Inst: ${{.City1stInstallmentAmount#}} Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}</IF>
<IF (Not IsEmpty({{.CitySecondInstallmentDueDate#}}))>2nd Inst: ${{.City2ndInstallmentAmount#}} Due {{.CitySecondInstallmentDueDate# M}}/{{.CitySecondInstallmentDueDate# D}}/ {{.City2ndInstallmentPaymentStatus#}}</IF>
<IF (Not IsEmpty({{.CityThirdInstallmentDate#}}))>3rd Inst: ${{.City3rdInstallmentAmount#}} Due {{.CityThirdInstallmentDate# M}}/{{.CityThirdInstallmentDate# D}}/ {{.City3rdInstallmentPaymentStatus#}}</IF>
Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.SchoolTaxDescription#}}))>{{.SchoolTaxDescription#}}: {{.SchoolTaxPeriod#}}
Full Tax: ${{.SchoolFullTaxAmount#}} <IF (IsEmpty({{.School2ndInstallmentDueDate#}}))>Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.SchoolFullTaxPaymentStatus#}}<ELSE>1st Inst: ${{.School1stInstallmentAmount#}} Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.School1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.School2ndInstallmentDueDate#}}))>2nd Inst: ${{.School2ndInstallmentAmount#}} Due {{.School2ndInstallmentDueDate# M}}/{{.School2ndInstallmentDueDate# D}}/ {{.School2ndInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.School3rdInstallmentDueDate#}}))>3rd Inst: ${{.School3rdInstallmentAmount#}} Due {{.School3rdInstallmentDueDate# M}}/{{.School3rdInstallmentDueDate# D}}/ {{.School3rdInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.VillageTaxDescription#}}))>{{.VillageTaxDescription#}}: {{.VillageTaxPeriod#}}
Full Tax: ${{.VillageFullTaxAmount#}} <IF (IsEmpty({{.VillageTaxSecondDueDate#}}))>Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.VillageFullTaxPaymentStatus#}}
<ELSE>1st Inst: ${{.Village1stInstallmentAmount#}} Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.Village1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.VillageTaxSecondDueDate#}}))>2nd Inst: ${{.Village2ndInstallmentAmount#}} Due {{.VillageTaxSecondDueDate# M}}/{{.VillageTaxSecondDueDate# D}}/ {{.Village2ndInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF>Water / Sewer: <IF ({{.TypeOfWater#}}=”Public”)>{{.TypeOfWater#}} (Account #)
Amount: ${{.WaterAmount#}} Due {{.WaterDueDate# M}}/{{.WaterDueDate# D}}/ {{.WaterPaymentStatus#}}
<ELSE><IF ({{.TypeOfWater#}}=”Private”)>{{.TypeOfWater#}}
<ELSE><IF ({{.TypeOfWater#}}=”Vacant Land”)> N/A - Vacant Land
<ELSE><IF ({{.TypeOfWater#}}=”Under Construction”)>Public When Improved
<ELSE><IF ({{.TypeOfWater#}}=”Nassau / Suffolk”)>Not Searched – Homeowner should present bill / receipt @ closing.
<ELSE><IF ({{.TypeOfWater#}}=”Missing Info”)>To Follow
<ELSE><IF ({{.TypeOfWater#}}=”Condo”)>Common Charges
<IF></IF></IF></IF></IF></IF></IF></IF></IF>
Dan Van Fleet
I blog at http://DanVanFleet.com on SoftPro and other things
-
- Posts: 67
- Joined: Sun Oct 26, 2008 6:14 am
Re: Aligning information in an IF statement
Hi Mr. Van Fleet,
I need the repetitive words within the lines to be aligned. example is attached
The words that should be aligned are : the $ sign, the Due dates and the status (Paid/Open)
I need the repetitive words within the lines to be aligned. example is attached
The words that should be aligned are : the $ sign, the Due dates and the status (Paid/Open)
- Attachments
-
- default.doc
- (21.5 KiB) Downloaded 69 times
Re: Aligning information in an IF statement
Hi Miri,
Oh shucks, call me Dan. <Smile>
So our first decision is if you want the $ signs lined up, or the decimal in the number lined up. Since I generally prefer to read numbers, when the decimal is aligned vertically, that is how this solution is generated. To change, simply change the Decimal tab to a Left Tab in the attached.
What I see is your document has to many tab stops. With tabs and merge documents, the fewer the better. If you want things to remained aligned, you can not use more than one tab to separate items. Spaces never work to align columns. As I'm sure you're aware, the document will potentially look quite goofy in design mode, the tab separators will pull it all together and print time. So I deleted all the tab stops, then added a decimal tab at 1.63", a Left Tab at 2" and a Left Tab at 3.5", and went through the formula removing a few Hard Returns, and separating items with a Tab rather than a space.
I'm having problems with Select right now, so I can't look at the attached document, but it will come pretty close to the mark.
Dan Van Fleet
Oh shucks, call me Dan. <Smile>
So our first decision is if you want the $ signs lined up, or the decimal in the number lined up. Since I generally prefer to read numbers, when the decimal is aligned vertically, that is how this solution is generated. To change, simply change the Decimal tab to a Left Tab in the attached.
What I see is your document has to many tab stops. With tabs and merge documents, the fewer the better. If you want things to remained aligned, you can not use more than one tab to separate items. Spaces never work to align columns. As I'm sure you're aware, the document will potentially look quite goofy in design mode, the tab separators will pull it all together and print time. So I deleted all the tab stops, then added a decimal tab at 1.63", a Left Tab at 2" and a Left Tab at 3.5", and went through the formula removing a few Hard Returns, and separating items with a Tab rather than a space.
I'm having problems with Select right now, so I can't look at the attached document, but it will come pretty close to the mark.
Dan Van Fleet
- Attachments
-
- Taxes Formated.Doc
- Example Document with Formatted Taxes
- (667 KiB) Downloaded 59 times
I blog at http://DanVanFleet.com on SoftPro and other things
Re: Aligning information in an IF statement
Hi,
Would a table with a single row also work? I have one wrapped in a FOR statement to have the columns align because I'm not using the standard tabs. To get rid of the extra line problem I change the size of the carriage return (aka end of line) character to a very small font size of 1.
Would a table with a single row also work? I have one wrapped in a FOR statement to have the columns align because I'm not using the standard tabs. To get rid of the extra line problem I change the size of the carriage return (aka end of line) character to a very small font size of 1.
Re: Aligning information in an IF statement
Yep sure would, I just don't like tables, and avoid them whenever possible.
Dan
Dan
I blog at http://DanVanFleet.com on SoftPro and other things
Re: Aligning information in an IF statement
I know what you mean. Thank you Dan
~ Debby
~ Debby
-
- Posts: 67
- Joined: Sun Oct 26, 2008 6:14 am
Re: Aligning information in an IF statement
Thank you Dan