Are you able to have a check box in one base that will trigger the creation of a line of data in another base? I have two bases where I want to combine some of the data into third base, but because the primary fields are not the same I cannot simply sync the data.
Yes, I would recommend looking into a third party tool like Zapier to help you with this; take you maybe an hour to set up. You can do this via automations with scripting as well but that's probably more work than it's worth
If you're using Airtable's multi-source syncing, the primary fields not being the same shouldn't affect anything as we should have the option to choose which field to send each field's data to, per table, no?