Hi all,
Can somebody suggest some logic or rule set, wherein above case say a Vessel(VSL 1) submits 10 forms in form of excel namely (i.e 1.xlsx to 10.xlsx) considering form 3,5,7 submission is 3 monthly interval and rest all forms submission is every month.
What is required is that once the excel is captured (by list files and folder node) & we do know submission intervals (i.e 1 or 3 monthly) we should be able to check for the next submission data automatically considering September 2021 as a starting month for this form pattern.
Suppose consider VSL1 didn’t have 3 monthly forms then what it must do is in the future whenever those 3 monthly forms are submitted say in October , it must suggest to us the next submission and the previous submission(3 months)-historical data.
Is that possible to consider September 2021 as a flag point?