Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago

(Video) Become Multi Select Hero by Automating Multi to Multi Relationships

I would be the first to admit , multi to multi is a pain to setup . In this video we are automating the process of Multi to Multi by using form rules and pipelines (Jinja). See the video here Purpo...
DougHenning1's avatar
DougHenning1
Community Manager
3 years ago
Hey Don,

In the example code it includes the index in the output:
"6": { "value": "{{loop.index}} {{ x|trim }}" }​


Just delete {{loop.index}} from the beginning of the string so it's only referencing x:

"6": { "value": "{{x|trim}}" }


------------------------------
Doug Henning
------------------------------
DonLarson's avatar
DonLarson
Qrew Elite
3 years ago
Doug,

Success!  Many thanks.  It works.

I comprehend 40% of the syntax at best.  :(


For everyone else this is the Body of the Post in the Pipeline
{%- set plist = a.quick_fill_reference_fields.split(';') -%}
{
"to": "bsvvexhkj",
"data": [
{%- for x in plist if x|trim != '' %}
{
"6": { "value": "{{a.id}}" },
"8": { "value": "{{ x|trim }}" }
}{{ ',' if not loop.last }}
{%- endfor %}
]
}

Here is the architecture of the sample


Now you can exploit Many to Many Relationships without having to hit the "Add Child" button.

Waiting for Prashant's video #2 on Jinja in the Pipeline.


​

------------------------------
Don Larson
------------------------------