Scraping data from the another table's row

1

Hi,

Coda noob here, trying to wrap my brain around this particular problem. I am either missing something extremely simple or it requires some out of the box thinking.

Lets say I have two tables: All products and Set 1. Both have same Columns and their names: Article Number and Price.

example

Now, I need to come up with some way to tell Coda to put this magic in table Set 1 column Price:

  • Check whether the Article number indicated in the Set 1 table`s column Article Number matches any Article number from the table All products;

  • If it does, retrieving the data from table All products column Price, and putting it to the table Set 1 column Price.

Any hints or help would be so so appreciated!

2

Like this?

4 Likes
3

Exactly, yes! Thank you so much!

4

You’re welcome. Glad it helps :slight_smile:

5

Hey @Nick_Milner! Would love to request access to this doc cause I’m trying to accomplish the same thing! Thanks in advance!

6

@Nick_Milner I think I’m also trying to figure out something similar…may I also have access? Thanks also in advance :slight_smile: