Basic Help With Formula
2 BASIC questions for my rich text formula field & I'll attach a screenshot... 1. I have 3 different ideas here, and each idea has 1 city on it right now. But I'd like to add a bunch of cities to ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOk, do please please don't build a giant IF.
Instead, set up a table of cities. Set the Key field to be the name of the city.
Then have a field that that gives the Territory name like North or South or Either.
Then in the details table make a field called City with a formula of [address: city] - the city part of your address field. Make a relationship with that back to Cities and then lookup the Territory. That way you will add city and edit the Territories in a table and not in an IF statement.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Instead, set up a table of cities. Set the Key field to be the name of the city.
Then have a field that that gives the Territory name like North or South or Either.
Then in the details table make a field called City with a formula of [address: city] - the city part of your address field. Make a relationship with that back to Cities and then lookup the Territory. That way you will add city and edit the Territories in a table and not in an IF statement.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MarkShnier__YouQrew Legend
Qrew LegendThere is a setting at the User level where you click on your name at the top right which allows you to set the spacing and the font size a bit. My Preferences and then UI spacing.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
