# 01_Create Project Tracking Tasks on Project Creation
#
# . Migrated from automation (a467d529-c7f3-41a9-a684-27d8427cfc7d)
#

# Account slugs:
#  - quickbase[gV2RArY]: QB Automation To Pipeline <None>
---
- META:
    name: 01_Create Project Tracking Tasks on Project Creation
    description: . Migrated from automation (a467d529-c7f3-41a9-a684-27d8427cfc7d)
    tag_names:
    - Migrated from Automations
    enabled: true
- TRIGGER quickbase[gV2RArY] record on_new_event -> a:
    inputs-meta:
      export_fields: '3'
      on_add_record: 'true'
      on_delete_record: 'false'
      on_modify_record: 'true'
      query: '{''257''.XEX.''''}AND{''260''.EX.''0''}AND{''377''.EX.''0''}'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Projects" <bpqhs9ucv>'
      trigger_fields: '"Project Commenced" <257>'
      trigger_on_all_fields: 'false'
- ACTION quickbase[gV2RArY] bulk_record_set define -> b:
    inputs-meta:
      export_fields: '"Task Name, Related Project, PM Order, Responsibility, Duration,
        Upload Notification, Responsible for Approval, Approval Notification, Approvals
        Needed, Project Types, Project Components" <6, 7, 9, 10, 19, 20, 21, 22, 46,
        49, 86>'
      merge_field: '"Record ID#" <3>'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Tasks" <bprb458ua>'
- QUERY quickbase[gV2RArY] record search -> c:
    inputs-meta:
      export_fields: 6,9,10,19,20,21,22,46,49,86
      query: '{''17''.XEX.''false''}AND{''18''.EX.''Project Tracking''}'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Tasks" <bprb458ua>'
- c<>LOOP:
  - DO:
    - b<>ACTION quickbase bulk_record_set create -> d:
        inputs:
          approval_notification: '{{c.approval_notification}}'
          approvals_needed: '{{c.approvals_needed}}'
          duration: '{{c.duration}}'
          pm_order: '{{c.pm_order}}'
          project_components: '{{c.project_components}}'
          project_types: '{{c.project_types}}'
          related_project: '{{a.id}}'
          responsibility: '{{c.responsibility}}'
          responsible_for_approval: '{{c.responsible_for_approval}}'
          task_name: '{{c.task_name}}'
          upload_notification: '{{c.upload_notification}}'
- b<>ACTION quickbase bulk_record_set commit_bulk_upsert -> e: {}
- ACTION quickbase[gV2RArY] bulk_record_set define -> f:
    inputs-meta:
      export_fields: '"Update Tasks" <256>'
      merge_field: '"Record ID#" <3>'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Projects" <bpqhs9ucv>'
- QUERY quickbase[gV2RArY] record search -> g:
    inputs-meta:
      export_fields: '"Update Tasks" <256>'
      query: '{''3''.EX.''{{a.id}}''}'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Projects" <bpqhs9ucv>'
- g<>LOOP:
  - DO:
    - f<>ACTION quickbase bulk_record_set create -> h:
        inputs:
          record_id: '{{g.id}}'
          update_tasks: 'true'
- f<>ACTION quickbase bulk_record_set commit_bulk_upsert -> i: {}
- ACTION quickbase[gV2RArY] bulk_record_set define -> j:
    inputs-meta:
      export_fields: '"Update Tasks" <256>'
      merge_field: '"Record ID#" <3>'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Projects" <bpqhs9ucv>'
- QUERY quickbase[gV2RArY] record search -> k:
    inputs-meta:
      export_fields: '"Update Tasks" <256>'
      query: '{''3''.EX.''{{a.id}}''}'
      table: '"Roche Diagnostics Global Real Estate Project Tracker: Projects" <bpqhs9ucv>'
- k<>LOOP:
  - DO:
    - j<>ACTION quickbase bulk_record_set create -> l:
        inputs:
          record_id: '{{k.id}}'
          update_tasks: 'false'
- j<>ACTION quickbase bulk_record_set commit_bulk_upsert -> m: {}
...