I have two tables Tenants and Property so i am creating a new record in a 3rd table called interaction where condition is The tenant's move-in date should not be more than one month later than the property's availability date.
How to do this ?
Find Records Automation With Date Condition
+2
+31You could try using the trigger "When record enters view" and create a view the move-in date meets your conditions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.