Pipeline: Create a parent record if one does not exist

A: On Insert

- TRIGGER on_create -> a:
    inputs-meta:
      export_fields: '"Custom Parent Key, Related Record ID

      table: '"Child Table

B: Prepare to insert or update parent table

ACTION bulk_record_set define -> b:
    inputs-meta:
      export_fields: '"Custom Parent Key, Related Record ID1, Related Record ID2'
      merge_field: '"Custom Parent Key '
      table: '"Parent Table

C: using only recent records as candidates (to avoid looking at  the whole table, which will get very large)

- - QUERY record search -> c:
    FILTERS:
    - AND:
      - created_at less-than:
        - '5'
        - minutes
        - past
        - ''

D: Prepare records for insert or update

    inputs-meta:
      export_fields: '"Custom Parent Key, Related Record ID1, Related Record ID2'
      table: 'Child Table
- c<>LOOP:
  - DO:
    - b<>ACTION quickbase bulk_record_set create -> d:

E: Commit

        inputs:
          Custom Parent Key: '{{c.Custom Parent Key}}'
          Related Record ID1: '{{c.Related Record ID1 }}'
          Related Record ID2: '{{c.Related Record ID2}}'
    - b<>ACTION quickbase bulk_record_set commit_bulk_upsert -> e: {}