Can I extract data from an address field so that I can format the address when printing it on a letter?ExampleAddress field: 3300 North Brook Place, Boise, ID 83710 United StatesHow I want to format address: <p>3300 North Brook Place</p><p>Boise, ID 83710 United States</p>

The field name for that subfield is listed on the field properties of the [Address field]. One of mine looks like this 31 Address: Street 1 32 Address: Street 2 33 Address: City 34 Address: State/Region 35 Address: Postal Code 36 Address: Country So my formula would just be[Address: Postal Code]------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

If you look at the address field properties, you will see that it is really made up of 6 fields, and each has its own field name and Field ID#, so "yes" is the answer to your question.Post back if you need help with the actual formula.

Thanks. I found the address fields you described. But I have encountered a new problem. The address I want to format (a customer contact address) is in the "Proposals" table. The address in the Proposals table is a lookup to the "Customer Contacts" table. The address in the "Customer Contacts" table is a lookup to the "Site List" table. What is the best way to do this? Should I format the address in the "Site List" table then carry the formatted text through to the "Proposals" table as a lookup?

Yes, I suggest that you do this on the highest up source record, so that it is easily available as a lookup field anywhere else in the app, or else you will find yourself re-building that formula concatenation field over and over, on each child and grandchild table.

HiQuick question, do you know if it's possible to make an address field have a default value? For Example Address field A will always have the address 1234 Street 1 City State Zip Code.------------------------------Wallace (DHS) Yeboah------------------------------

Extract part of address from address field

15 Replies

QuickBaseCoachD
Qrew Captain
7 years ago
If you look at the address field properties, you will see that it is really made up of 6 fields, and each has its own field name and Field ID#, so "yes" is the answer to your question.

Post back if you need help with the actual formula.
- JasonBeaver
  Qrew Cadet
  5 years ago
  How do I extract the Zip Code subfield from the address field. I want to use this value in another formula. Basically, I want to make another field the value of the Zip Code subfield.
  
  ------------------------------
  Jason Beaver
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    The field name for that subfield is listed on the field properties of the [Address field]. One of mine looks like this
    
    31 Address: Street 1
    
    32 Address: Street 2
    
    33 Address: City
    
    34 Address: State/Region
    
    35 Address: Postal Code
    
    36 Address: Country
    
    So my formula would just be
    [Address: Postal Code]
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
- ShumaChaudhuri
  Qrew Member
  5 years ago
  Hello, thanks for this article. I am a new user to Quickbase. I would like to leverage what you have mentioned above about how the address is made up of individual subfields.
  
  I will be using the map report functionality to display mapping indicators for each of my client's data submission. In the map view, I do not want the numerical portion of the address to be displayed when hovering over the map indicator. How do I create a formula text field using the subfield? Thank you.
  
  I found a formula for Excel but am having trouble applying it to quickbase. I inserted the field I saw mentioned in part of the discussion about using Address: Street 1.
  
  LEFT([Address: Street 1],1),"",LEFT([Address: Street 1],FIND(" ",[Address: Street 1])-1)
  
  ------------------------------
  Shuma Chaudhuri
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    I can certainly help you with a formula, but I don't think there is a way with either the native Maps or the 3rd Party Add On from Juiced Technologies to not show the full address.
    
    But let us know if you need help with an address based formula with an example of the format if the result. Maybe that would still be useful for you on a regular vanilla table report.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
- ShumaChaudhuri
  Qrew Member
  5 years ago
  Thanks so much for such a quick response, Mark. In my mind of working with my onboarding lead, we were thinking we can set up a formula-text field to store this "truncated" address of removing the house number, and then use this modified field to display on the map, where the actual address would still ensure the "marker" on the map is accurate.
  
  Will that work? If not, then I will abandon the idea. I need the map feature badly for my organization, but I am very worried about displaying the PII visibly for basically anyone on the internet who will be able to see the map.
  
  P.S. if it helps for me to explain my use case more, I am glad to do so.
  ------------------------------
  Shuma Chaudhuri
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    I'm sorry but in my testing I was unable to suppress the exact address from showing on a Maps report type. They allow you to show some fields in addition to the address , but I could not see a way to suppress the full address from showing.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
AndreaPahor
Qrew Cadet
7 years ago
Thanks.

I found the address fields you described. But I have encountered a new problem.

The address I want to format (a customer contact address) is in the "Proposals" table.

The address in the Proposals table is a lookup to the "Customer Contacts" table.

The address in the "Customer Contacts" table is a lookup to the "Site List" table.

What is the best way to do this? Should I format the address in the "Site List" table then carry the formatted text through to the "Proposals" table as a lookup?
QuickBaseCoachD
Qrew Captain
7 years ago
Yes, I suggest that you do this on the highest up source record, so that it is easily available as a lookup field anywhere else in the app, or else you will find yourself re-building that formula concatenation field over and over, on each child and grandchild table.
- Wallace__DHS_Ye
  Qrew Trainee
  6 years ago
  Hi
  
  Quick question, do you know if it's possible to make an address field have a default value? For Example Address field A will always have the address 1234 Street 1 City State Zip Code.
  
  ------------------------------
  Wallace (DHS) Yeboah
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    I suggest building a quick little automation.
    
    When a record is added and the address field is blank, say address line one is blank, then have the automation fill in all the address field components.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Extract part of address from address field

15 Replies

Related Content

Address field not working

Address Field - Set default value?

Change From Email Address

Email address validation

Extract Date and Comment from prepend log entry field

31	Address: Street 1
32	Address: Street 2
33	Address: City
34	Address: State/Region
35	Address: Postal Code
36	Address: Country