End-to-End Event Lifecycle Management Workflow

Start of the Workflow/Process.

Create a new entry in the 'Event Request' data model to initiate the lifecycle.

Create a task for the Event Management team to review the initial request.

Update the status field of the Event Request entry.

Retrieve entries from the 'Venues' data model to check for available dates.

Calculate the initial budget estimate based on attendee count and venue base cost.

Create a task for the logistics officer to finalize the venue choice.

Create an entry in the 'Bookings' data model linked to the selected venue.

Update the 'Event Logistics' entry with confirmed venue and date details.

Create tasks for sourcing catering, AV, and decor vendors.

Get all entries from 'Vendor Quotes' associated with the current event.

Aggregate the 'Price' property from all related Vendor Quote entries to find total cost.

Subtract total vendor costs from the allocated event budget.

Create a task for the Finance Manager to approve the calculated expenditure.

Send an email to the event stakeholders confirming budget approval.

Change the status of the Event Request entry to 'Confirmed'.

Create a task for the communications team to distribute event invites.

Retrieve all entries from the 'Registrations' data model for the specific event.

Aggregate the number of entries in the 'Registrations' model to get total headcount.

Send an SMS reminder to all registered attendees 24 hours before the event.

Create a task to collect feedback and close the event lifecycle.

Create a final report summarizing costs, attendance, and vendor performance.

Update the event entry status to 'Completed' and mark for archiving.

End of the Workflow/Process.