I have a Timesheets base with a “Timesheets” table that is filled when my workers submit timesheets each month.
I have a separate “Rates” table (in a different base) that is synced to my Timesheets base and table.
In this Rates table, I have a list of rates connected to each of my referral partners, including a start and stop date. If they do not have a stop date then that rate is considered active, if it does have a stop date than that is not an active rate.
My problem is that I am currently manually syncing the Rates table Referral partner to the Timesheet entry, and it’s too much work and error prone.
The whole point of doing Rates in a different table was to not break that past timesheet entry’s as you can see here: Financial reporting dynamic changing past data - #3 by Justin_Barrett
I am looking for a script that can automatically detect what record selection to make in the Timesheets table from the Rates table, connecting my referral partner to the timesheet. The identifier can be email (or something else) as the referral partner is already tagged to that Timesheet, but the Rate is not automatically tagged…