The record that worked is:
\n
\n
\nAnd, for those who have stuck around this long, here's the YAML:
# Sunnytech - Move BOMs from PCBA Upload Table to PCB Scan Table
#
# Takes all of the records in the PCBA Upload Table and moves them to the
# Scans tables
#
# Account slugs:
# - quickbase[28nbQjo]: SunnyTech App <None>
---
- META:
name: Sunnytech - Move BOMs from PCBA Upload Table to PCB Scan Table
description: Takes all of the records in the PCBA Upload Table and moves them
to the Scans tables
- TRIGGER quickbase[28nbQjo] record on_new_event -> a:
export_fields: '\"Ready to Import\" <12>'
on_add_record: 'false'
on_delete_record: 'false'
on_modify_record: 'true'
table: '\"SunnyTech Serial and Lot Tracking: PCBA Upload Table\" <bsj24w3rd>'
trigger_fields: '\"Ready to Import\" <12>'
trigger_on_all_fields: 'false'
___: ___
FILTERS:
- AND:
- ready_to_import equals Importing Records to PCBA table
- QUERY quickbase[28nbQjo] record search -> b:
export_fields: '\"Calculated Assembly PartID\" <12, 11, 7, 9, 14>'
table: '\"SunnyTech Serial and Lot Tracking: PCBA Upload Table\" <bsj24w3rd>'
___: ___
- b<>LOOP:
- DO:
- IF:
- AND:
- b<>upload_problem set
- THEN:
- b<>ACTION quickbase record update -> c:
___: ___
ready_to_import: PROBLEM - Won't be imported!
- ELSE:
- b<>ACTION quickbase record update -> d:
___: ___
ready_to_import: Preparing to import this record
- QUERY quickbase[28nbQjo] record search -> e:
export_fields: '\"ComponentID\" <7>'
table: '\"SunnyTech Serial and Lot Tracking: PCB Scans\" <bse7txtrg>'
___: ___
FILTERS:
- AND:
- component_id equals {{b.calculated_assembly_part_id}}
- IF:
- AND:
- e<> empty
- THEN:
- ACTION quickbase[28nbQjo] record create -> f:
table: '\"SunnyTech Serial and Lot Tracking: PCB Scans\" <bse7txtrg>'
___: ___
component_id: '{{b.calculated_assembly_part_id}}'
- b<>ACTION quickbase record update -> g:
___: ___
pcb_scans_record_id: '{{f.id}}'
ready_to_import: Importing this record
- ELSE:
- b<>ACTION quickbase record update -> h:
___: ___
pcb_scans_record_id: '{{e.id}}'
ready_to_import: Importing this record
...
