I am having a bit of a basic mind blank and could do with some direction.
The objective is to join two lists of separate entries as a new third master list of separate entries.
At a basic level it would look like this:
After some research it seems to be that scheduling an API workflow on a list or a recursive workflow on a list would be the best option. Typically there may be 10 or 20 items on this list in my use case but it could in theory be up to 500ish depending on the user.
It’s important that this data is copied over accurately and no entries are missed. It is a process that does not need to be done on the front end and I don’t mind if it takes a few minutes to complete and compile but I do want the entries to be accurate.
Which method should I use and how do I tell the API to set an increment so it goes from the first item to the next item sequentially. I’ve tried it where all items get added to a single entry as a list and that does not work for my use case, they must be individual entries.
I’ve also tried to specify :first item but of course that just loops through and repeats the first item. What’s the thought process perhaps with some exapmle workflow screenshots on setting a +1 increment so it can work through a list to create a separate master list?
The actual lists I need to merge are booked dates and blocked dates for a property rental site.
Confirmed paid bookings shown here
Will need to be added to user blocked date ranges shown here
In a final database that is iCal compliant (can talk to other rental sites) and tell them which dates are not available to be booked.
Ultimately and perhaps this is another question, I need this workflow to trigger whenever a booking comes in or is modified or a blocked date is added or modified. The master list should only ever contain the most up to date summary of both lists combined so it can be converted to ical file via @muneer.hameer beautifully crafted iCal creator and shared with the world.
Any guidance from the bubble eco system appreciated