Referencing(?) issue?

[Road_Dog_Supply]

I’m trying to auto populate rows in my form dependant on first selection, I want the next line to fill in the address of the matching selection…

But when I try to(de?)reference it with [show id].[venue address], it says it’s right, but if I put it in the formula box, it makes the field disappear?..and if I put the same expression in the initial value box, it doesn’t work?

What am I doing wrong?

[JuneCorpuz]

Can you please upload here the whole formula for Name and Address?

[Aleksi]

It sounds either you don’t have any address in Show record or because you are using normal column, you haven’t opened and saved the record after the formula is created.

[Road_Dog_Supply]

Thanks aleksi, I guess I needed to sleep on it. I think I was also kept looking at the wrong “date”.

But I’m still having issues understanding referencing.

I’ve created a vcolumn that measures the distance from the latlong in one column and the latlong in another and then converts it to miles. This column is called [in miles]
I have a regular column called [milage], that I want populated with the number from [in miles]

But I’ve tried many different ways and put the reference different places and opened and [milage] just comes up blank even when I try to re-save in case it just hasn’t picked it up. I keep getting hung up on little references like total road blocks for what I’m doing
I’ve tried just referencing [in miles] or [_thisrow].[in miles] or id[in miles] and anything else I can think of
(Just tried a couple more ways that came to mind, but still nothing)

*on a side note, once I get this figured out…
If you have 2 columns: 1 with an address and 1 with a latlong
Is there a way for the latlong column to pick up the latlong from the address entered in the address coloumn? Or no?

[Aleksi]

Yes you can read it like LOOKUP([_THISROW].[ADDRESS],“TableName”,“Address”,“LatLongColumn”)

[Road_Dog_Supply]

Aleksi:

LOOKUP([_THISROW].[ADDRESS],“TableName”,“Address”,“LatLongColumn”)

Is there an article on more about this?

[Aleksi · Accepted solution]

In generally… please check this article.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[Road_Dog_Supply]

Thank you!!!

[Aleksi]

Please check this article…

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Road_Dog_Supply]

I feel terrible for asking so many questions, but I just can get this figured out and have watched every single video and read sooooo many links related to what I’m trying to do and distance, latlong, addresses and locations and I’m STILL stuck and seriously don’t want to give up…
I’m pretty sure what I’m trying to do IS doable, I just can’t get it to work.
Not sure if I need more columns to help it better calculate or what.

I have an “itinerary” table
I want to be able to enter a “coming from” address and then have the “hidden from” column reference(?) the address in “coming from” and translate it to the approx latlong.
Then I have a “going to” column and a “hidden going” column, that I want to basically do the same, but with a different address.

Then I want to be able to calculate the distance between the 2 as well as calculate the travel time that would take.

• I think I know how to do this part, at least the distance part and I’ll have to figure out some math to calculate the time…somehow, if that possible.

But I’m stuck because I can’t figure out how the get the latlong columns to pick up on the addresses entered and then calculate the latlong without physically moving the latlong indicator or knowing the latlong of the address.

If anyone understands what I’m trying to do and could offer some advice, it would be GREATLY appreciated!

Thank you so much in advance.

[WillowMobileSys]

Road_Dog_Supply_Co:

But I’m stuck because I can’t figure out how the get the latlong columns to pick up on the addresses entered and then calculate the latlong without physically moving the latlong indicator or knowing the latlong of the address.

Unfortunately, at the moment, there is not a direct way to get the LatLong for an address. We hope that this will be changing soon with Google acquiring AppSheet. (A lot of Geo Location functions are most likely changing for the better - fingers crossed)

For now, you have two options:

1. Manually lookup and enter an approximate LatLong for the address.
2. Create a Google API call to get the LatLong value. Depending on frequency of calls, this option can result in restrictions or require a paid account. Check into those restrictions first.

[Road_Dog_Supply]

Thank you! Great to know before I stress even more!

[Road_Dog_Supply]

Just to confirm…

I won’t be able to pick up an address from a latlong OR a latlong from an address? Correct?
As in, even if an address is entered into one field and drops a pin, there’s no way to have another field with a latlong see that pin and translate that into a latlong…right?

[Aleksi]

That’s correct.