Oh I see that’s what i thought on your first explanation. I understand your solution but. If I need the relation on their own Sheet . It is possible ?
yes… you can record that with the row ID with a sum equal to 2… that will be your relation…
when they are creating a new record for the timesheet… make a date set in sheet 1 before you create a record of that.
I hope I understand your process correctly 
Ok, what if the data is already there. And to check the relation?
your steps is the solution for the situation which data is not yet in right ? but what if its there, and need to check which have relation for both sheet ?
App workflow:
- worker applies for a leave
- leave is approved and recorded in sheet 1
- worker is adding a new time sheet record (sheet 2)
- check if a new record is matching dates range in leaves data (sheet 1)
Is that correct?
- Mark the new record as invalid if it matches dates range?
or - Do not record new timesheet records?
1 to 5 is correct. on step 6, we can also record or create the row for the leave date but. with different status let say status “Off Day/on Leave” instead of “approved/rejected/pending approval”
Depends on the situation which is more easier . But right now, the most important thing that I really need on the Sheet 2 can have the relation column whether its already in Sheet 1 or not.
Then you need to break step 3 into two phases…
a. worker enters a date
(two-step custom action)
b 1. the date is copied to sheet 1, and check if it is valid… return the row ID of matched date range
b 2. record new timesheet
I have to go… I hope this will put you on the right track to solving your problem.
yes @Uzo . Its 2.20 am in your place right. Have a good rest.