Fill a Link Record based on an other field

Jean-Philippe_E · ‎Oct 24, 2019

I have a PLACES table with an address (string) field
I have a GPS table with an address (string) field and a Link to PLACE

How can I set the PLACE fileld according to the address ?

I can do it in NodeJS

Caching all the PLACES
Then finding the matching address

But would be better to use a kind of “reverse rollup”

Justin_Barrett · ‎Oct 24, 2019

Outside of using an API-based tool (whether hand coded, or an existing third-party tool like Zapier or Integromat), link fields can only be set manually. In that case, your NodeJS option is probably the best way to go.

Now, there is a way to build a “dictionary” of sorts and look up specific data based on other data, but it’s a slightly convoluted setup, and the end result is just plain text. It can’t be a link.

See Solution in Thread

Justin_Barrett · ‎Oct 24, 2019

Outside of using an API-based tool (whether hand coded, or an existing third-party tool like Zapier or Integromat), link fields can only be set manually. In that case, your NodeJS option is probably the best way to go.

Now, there is a way to build a “dictionary” of sorts and look up specific data based on other data, but it’s a slightly convoluted setup, and the end result is just plain text. It can’t be a link.