table_trigger "New RSVP Answer" {
  table = "RSVP"

  input {
    json new
    json old
    enum action {
      values = ["insert", "update", "delete", "truncate"]
    }
  
    text datasource
  }

  stack {
    db.query event {
      where = $db.event.id == $input.new.event_id
      return = {type: "single"}
    } as $event
  
    function.run "DocuGenerate/Generate Document" {
      input = {
        template_id  : "<YOUR_TEMPLATE_ID>"
        name         : "Ticket for %s"|sprintf:$input.new.name
        output_name  : ""
        output_format: ".pdf"
        data         : {}|set:"rsvp_name":$input.new.name|set:"rsvp_email":$input.new.email|set:"event_name":$event.name|set:"start_at":($event.start_at|format_timestamp:"M j, Y h:i A":"UTC")|set:"end_at":($event.end_at|format_timestamp:"M j, Y h:i A":"UTC")|set:"event_photo":$event.cover_photo.url
      }
    } as $document
  }

  actions = {insert: true}
}