Can I create an automation (or formula field) to do the following?When a record is created in the "Deals" table, if the Move-in date of that record is within the range of the start & end dates of a record in the "Payments" table, link the new Deals...
thank you. I am not sure I get it.in step 1, "The record in the ‘Deals’ tables would need to be linked to the record in the ‘Payments’ table. " do you link all records to a specific record in the payments table? Does it matter which? The purpose o...
