(Video) How to generate children from simple text field using Jinja

Question

I've been using below methodology at LOT for quickly capturing info on the go on mobile , this is also used by my assistant for quick capturing information in 1 place during meetings.

Why am I posting this ? Barely any information exists on JINJA on forums and online from pipeline perspective.

PS : This is a Version 1 video , I do skip through explanation of jinja code thoroughly , if people demand , version 2 would be created

Jinja - Generated Children through text fields

Loom

remove preview

Jinja - Generated Children through text fields

View this on Loom >

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

Loom
remove preview

Jinja - Generated Children through text fields

View this on Loom &gt;

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

markshnier__you · Answer

Thx for posting!------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

forrestparker2 · Answer

Very interesting! Thanks for posting!------------------------------Forrest Parker------------------------------

doughenning1 · Answer

Thank you for making the video and sharing your knowledge with others!&nbsp; For the sake of learning, I'd like share some improvements you can make to the Jinja for more streamlined code.&nbsp; 1. Try not to use variables that are also the names of filters (list is a filter). While it will work most of the time, it can cause confusion.2. The namespace functionality is very useful, but in your case you don't actually need it.&nbsp; I assume you're using it because some lines may be blank and you don't want to count them.&nbsp; If you filter the list to exclude the blank lines then you can just use the loop index instead:
{% for x in plist if x|trim != '' -%}​
3. Use the variable specified in the for loop (x) instead of list[loop.index0]4. You can use loop.last to see if you need to add the comma:
{{ ',' if not loop.last }}
Here's the complete updated code:
{% 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 -%}
  ]
}
Thanks again for sharing and hope this helps!
------------------------------Doug Henning------------------------------

donlarson · Answer

First, thank you.&nbsp; The concept of a "Quick Capture" is going to be helpful with many business cases.Second, I am going to have to watch this several times and then come back to you with questions.------------------------------Don Larson------------------------------

prashantmaheshw · Answer

Thank you Don, Mark and Forrest for kind encouragement. &nbsp;All future questions are appreciated. Mark do try running Quick Capture &nbsp;on a mobile page , it's a thing of beauty&nbsp;Thank you @Doug Henning for detailed reply .Your reply and insights have made it worth to create and share. I have one question . In my trial errors , I found if I only write {{x}}&nbsp;as in ("6": { "value": "{{loop.index}} {{x}}" } ,&nbsp;&nbsp;output was always empty . I still don't understand why?
"6": { "value": "{{loop.index}} {{ x|trim }}" }
​

{% for x in plist if x|trim != '' -%}​​
Yes you are right , namespace was used specifically to have counter variable inside the loop for avoiding blank lines. I had no clue , there was a concept of conditional loop , this will help me tonnes of my other much longer jinja code !
{{ ',' if not loop.last }}
Again thank you for this much simpler code , I copy pasted {% if not loop.last %},{% endif %}&nbsp;from one of the pipeline sessions .THANKS for the much simpler and easy to read code
​------------------------------Prashant Maheshwari------------------------------

Forum Discussion

(Video) How to generate children from simple text field using Jinja