Sorry if my question was already asked here in the community, but I didn’t find the solution I needed
Is there a way to apply rules on 2 or more pages?
I have 2 tables. Say
ClaimTable: Claim ID, Name, Job, Due Date, Date Paid.
Job Table: Job ID, Name, Job, Job Start, Job End
I need to link the claim with the job where Name=Name and Job = Job and Job Start<DueDate<Job End + 3 months.
I can do it with Rule action but not sure how to apply rules on 2 tables.
Any help would be much appreciated.