Update a data field with automation

[James_Rhoads]

Hello all!

I am working on a project where I am inputting data that we collect into one table based around different areas we collect from and how many days it took to collect data. In the other table, I have been manually updating the rate of collection. It is structured by: Column 1 - Date Data Collected (with some repeat dates as multiple collections happen in a single day sometimes), Column 2 - Single Selection Dropdown of the Area Collected From, and then another Column - Data Points Collected. With these columns, is it possible to update data in another table that has a list of all the offices in one column and their estimated rate of collection in another column based on new data input into the first table.

I hope this makes sense and thank you for your help!

[Kamille_Parks · Accepted solution]

Is

James_Rhoads:

Dropdown of the Area Collected From

the same as

James_Rhoads:

list of all the offices

If so, then instead of a Single Select field you should be using a Link to Record field and Lookups.

Airtable Support

How to link records in Airtable

When you’re managing a workflow, there’s a lot of information to keep track of. Knowing which project connects to which client, or which venue you’re using for which event, is crucial to staying on...

You cannot arbitrarily say “a change in Table 1 should affect a change in Table 2” in Airtable. Either you have to link your records together (recommended, as that’s how Airtable is designed) or set up one or more Automations.

[James_Rhoads]

Okay so linked fields and automations will be how I need to proceed.

Thank you!