# Populate address using text formula or number fields

**URL:** <https://forums.knack.com/t/populate-address-using-text-formula-or-number-fields/8359>\
**Category:** Get Answers\
**Created:** [August 27, 2020, 3:35am UTC](https://forums.knack.com/t/populate-address-using-text-formula-or-number-fields/8359 "2020-08-27T03:35:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChrisSchra99860](https://avatars.discourse-cdn.com/v4/letter/c/7993a0/32.png) [@ChrisSchra99860](https://forums.knack.com/u/ChrisSchra99860)\
**Post date:** [August 27, 2020, 3:35am UTC](https://forums.knack.com/t/populate-address-using-text-formula-or-number-fields/8359/1 "2020-08-27T03:35:38Z")

</div>

Hi all

I've created an app that lets people record the details of mature trees that have been removed. To help tell the story in a visual way it asks users to copy and paste the embed code from StreetView which then embeds that view. I've used extractRegex to extract the latitude and longitude from the embed code and save them into text formula fields.

Now I'm hoping to be able to combine these two to populate an address field which will then power the map view.

I've tried:

1. Using Record Rules

2. Using Conditional Rules

3. Using Conditional Rules to populate number fields (to change the data type from string to number) and then tried using these number fields using steps 1 and 2.

I have a feeling this needs to be done with an API.&nbsp;Can anyone help me out with some code for this?

Alternativey, if there is another no-code way to do it I'd be keen to hear about it.

Failing both of these, I'll see if I can pull it off with Integromat.

Thanks

&nbsp;

Chris

---

<div class="post-metadata">

**Author:** ![RezaAzmi14674](https://avatars.discourse-cdn.com/v4/letter/r/9e8a1a/32.png) [@RezaAzmi14674](https://forums.knack.com/u/RezaAzmi14674)\
**Post date:** [August 17, 2021, 8:31am UTC](https://forums.knack.com/t/populate-address-using-text-formula-or-number-fields/8359/2 "2021-08-17T08:31:28Z")

</div>

Sorry, I don’t have a solution …

I have been wanting to find a solution to extract the lat/long from an address field. What was the formula you used to do this?

API and whatnot is a bit beyond me tight now.

Thanks,

Reza