Address Label Formula
I'm trying to create a formula text field [Landlord Address Label] that combines several fields in a list form (like a mailing label) with a few If-then-that issues. I'm still learning formulas so I...
Forum Discussion
I wanted to follow up and say I got it working. I did some more searching and found out about variables. This is what ended up working:
var Text Landlord = If(Contains([Landlord Name], "Individual"), Left([Landlord Name],","), [Landlord Name]);
var Text Care = If(Trim([In Care of:])<>"","c/o" &" "& [In Care of:], [In Care of:]);
List("\n", $Landlord, $Care, "",
List(", ", [Address: Street 1], [Address: Street 2]), "",
List(", ", [Address: City], [Address: State/Region]), [Address: Postal Code])
------------------------------
Kelly-Ann Taintor
------------------------------
var Text Landlord = If(Contains([Landlord Name], "Individual"), Left([Landlord Name],","), [Landlord Name]);
var Text Care = If(Trim([In Care of:])<>"","c/o" &" "& [In Care of:], [In Care of:]);
List("\n", $Landlord, $Care, "",
List(", ", [Address: Street 1], [Address: Street 2]), "",
List(", ", [Address: City], [Address: State/Region]), [Address: Postal Code])
------------------------------
Kelly-Ann Taintor
------------------------------
- nicely done!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
