Update a record from one table to another

[Sharon_Watson]

Hi All,

Apologies for the lack of scripting ability. I’m hoping to get started if someone can point me in the right direction.

I have 2 tables TableA has records in with following ID, Rate

TableB has the same ID, Rate

I want to build a script that, when run, prompts the user for the ID from TableA and then updates all records (multiple records for ID in TableB) in TableB with the value set on TableID for that ID

Hope this makes sense.

Regards

[Sharon_Watson]

Thanks Stephen, I really appreciate the time you have taken to explain.

I probably could do it with a linked table but it is more complicated than that as it’s more selective as to which records should update.

I am keen to learn the scripting as I think it will be a powerful tool when coming up against limitations in Airtable. Hopefully I can look what you have done and moved forward with my understanding of how it all works.

Thanks again, you have been a great help :thumbs_up: