Matt,
When do the values change from 200 to 404?
Does it occur in the first part of the Pipeline as part of larger process where many new values are created and then you want to create the new records?
If this is true, then you can reference the original value from the beginning of the Pipeline in an If statement.
I just tested this. Here is my YAML.
# Previous value in a If
#
# Account slugs:
# - quickbase[XXXXXX]: Pipeline Token <None>
---
- META:
name: Previous value in a If
- QUERY quickbase[XXXXX] record search -> a:
inputs-meta:
export_fields: '"Numeric Field, Pipeline Text Field" <95, 83>'
table: '"Parents: Parent" <bp4igy3re>'
- a<>LOOP:
- DO:
- a<>ACTION quickbase record update -> b:
inputs:
numeric_field: '404'
- IF:
- AND:
- a<>numeric_field equals 200
- THEN:
- b<>ACTION quickbase record update -> c:
inputs:
pipeline_text_field: '{{a.numeric_field}}'
- ELSE: []
...
I am doing an Update and not a Create Record, but this does work. It changes all the records in the Parent table to a value of 404. The records where the value was originally 200, it writes a note that it was 200, the rest are blank.
