Hey Sharon:
I’d highly recommend using linked records and lookups (like in @Jeremy_Oglesby’s example) for this use case, as it will save you having to manually run a script every single time you change rates. This will ultimately reduce the chance of errors; for example, if a collaborator updates the rate but forgets to run the script, the data will be wrong.
If you do want to use a script, here’s a quick example that should get you started (you’ll have to change the names of the tables/fields to match your own base).
let tableA = base.getTable('People');
let tableB = base.getTable('Bookings');
let person = await input.recordAsync("Whose rate changed?", tableA);
let query = await tableB.selectRecordsAsync();
// Find all the affected bookings and update them
let updates = [];
for (let booking of bookings) {
// This assumes you aren't using a linked record field.
// If you are using a linked record field, you want to do
// booking.getCellValue('People')[0].id instead, since the cell value
// is returned as an array of records.
if (booking.getCellValue('Person ID') === person.id) {
updates.push({
id: booking.id,
fields: {
// Update the cell values — change this
'Field to update': 'New value'
}
});
}
}
// Only up to 50 updates are allowed at one time, so do it in batches
while (updates.length > 0) {
await tableB.updateRecordsAsync(updates.slice(0, 50));
updates = updates.slice(50);
}
