Forum Discussion

NickCharalambou's avatar
NickCharalambou
Qrew Cadet
11 months ago

Pipelines and appending / joining

I have a jinja expression that simply compares old to new, and writes to the text field it sits in on the pipeline: {% set result = "" %} {% if a.requested_offer_types != a.$prev.requested_offer_...
Pipelines
NickCharalambou's avatar
NickCharalambou
Qrew Cadet
11 months ago

OK I have updated as follows as I realised the opening string was incorrect and simply blank.

However it still not working. 

{# Capture the initial detail value that is passed into the template #}
{% set initial_detail = g.detail %}

{# Initialize a list starting with the initial content of j.detail #}
{% set messages = [initial_detail] %}

{# Check if the requested offer types have changed and append a message if true #}
{% if a.requested_offer_types != a.$prev.requested_offer_types %}
    {# Create a message about the change #}
    {% set message = "Requested Offer Types changed from '" + a.$prev.requested_offer_types + "' to '" + a.requested_offer_types + "'" %}
    {# Append the message to the messages list #}
    {% set _ = messages.append(message) %}
{% endif %}

{# Output all accumulated messages, including initial and new ones, separated by new lines #}
{{ messages | join('\n') }}

I think the join is wrong.

 

 

 

  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Captain
    11 months ago

    We recently solved something like this when a.$prev didn't work for us. In our case 

    1. Existing field was getting update via incoming webhook
    2. Step 1 , Receive webhook 
    3. Step 2 , Receive the value of existing value (which is what I am detailing here)
    4. Step 3 , Join existing value and webhook value 

      First do a query on
      https://api.quickbase.com/v1/records/query

    In my scenario it looked like below
    {  
    "from": "{{a.body_params.parentid}}",   --> tableid
    "select": ["{{a.body_params.fid}}"],    --> fid of record you want 
    "where": "{3.EX.{{a.body_params.recordid}}}" }. --> Query you

    This will allow you to 'get' the value of the existing field first. 

    This was stored inside for me
    {b.json.data[0]}

    Then another query doing make request and append value. Hope this makes sense

    As for your actual join , you can trying using ~ to concat like {{ (a.firstname) ~ ' ' ~ (a.lastname) }}