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...
DonLarson's avatar
DonLarson
Qrew Elite
3 years ago
Prashant,

I have the Quick Fill formula working now on the form.  There is a key piece that cannot be seen in your video.   The form rule that writes the formula to the text field has to have the check box cleared in the Options section. 

That is blocked by the circle where the camera capture is displaying.


I also took the formula and exploded it into components so I could figure out what was happening in it.  Here is a link to my longer version with comments:

https://github.com/mcfindustries/Magic/blob/master/Community/Quick%20Fill%20Formula.quickbase


Now I have to replicate the Pipeline action to create the records in the M2M.





------------------------------
Don Larson
------------------------------
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago
HI Don,

Thank you for your feedback. I will definitely make a v2 . 

Absolutely love your detailed GitHub comments , it makes it so much easier to explain what I was mumbling about. I'm still hoping this form rule is as useful in problem solving for you. 

For pipeline you can either use extract regex or version below by @Doug Henning in my earlier post . Modify below to set your fields setup. 

{%- set plist = a.quick_capture.split(';') -%}
{
  "to": "br8hpcpk7",
  "data": [
    {%- for x in plist if x|trim != '' %}
      {
        "18": { "value": "{{a.related_director}}" },
        "89": { "value": "{{a.id}}" },
        "6": { "value": "{{loop.index}} {{ x|trim }}" }
      }{{ ',' if not loop.last }}
    {%- endfor %}
  ]
}​​

​​​

------------------------------
Prashant Maheshwari
------------------------------