Create a synced view of Formation 1 in the base where you have Formation 2. Then create an automation that triggers when the status changes to Refused in Formation 1 and then copy over the fields you need to the other record.I would recommend making ...
Hello!You don't need a formula to make this work actually. Assuming you have an identifier, username or fullname in your player records:Go to your Matches table.Add two Lookup columns.Set the Source of each lookup to Player 1 and Player 2.Set the Fie...