I think you are going to want to use some webhooks to make this happen for you. You will basically tell the webhook, to find the matching ShotID in the static table, and update the fields with the appropriate data.
This will need to run whenever information is added/updated.
You'll want to make sure you account for times when the data is changed manually in the static table, and that the webhook/synced data doesn't override it if not needed.
There might be some other options, but its hard to tell without knowing where all the data is coming from, and how it all gets entered or changed once in the app.
If you get stuck and want some more in-depth guidance, let me know and I can help dive into this more for you.
Matthew@cirrusops.com
