Correct format for Address in Pipelines, if field name has a space

Question

I recently had trouble having a pipeline populate one address to another. My originating address field had a space in the name, and I thought I just needed to include an underscore to make it work. It turns out, that is not the case. Through testing and customer support's help, the correct syntax is:

{{a['Address 1_city']}}

as opposed to

{{a.Address 1_city}} or {{a.Address_1_city}}

Hope this helps others who run into this unfortunate bug!

------------------------------
Mike Tamoush
------------------------------

prashantmaheshw · Answer

Thank you , this would be infinitely useful to me in future------------------------------Prashant Maheshwari------------------------------

ryanfarrington · Answer

Thank you for posting this! I was just working on a pipeline with address fields and was about to report this bug.

------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------

miketamoush · Answer

No problem. It was a real headache trying to figure out why my pipeline wasn't working! Still might be worth reporting it so you can get on the 'bug' list and they update you when it is fixed.

------------------------------
Mike Tamoush
------------------------------

laszlom · Answer

Thank's for posting this!I had real trouble finding my workaround: replacing spaces with underscores in the original field label.Reading through this thread I understand the problem is Pipelines is not putting together a correct JINJA syntax just assumes the field labels do not contain spaces...In fact I have found this in the QB documentation:
Example - workaround for address fields with spaces
Address fields in Quickbase using the ‘parent’ label have the safe field name applied when creating the keys for address sub-fields in the pipelines schema. This means that any time a you try to access a sub-field of an address field that contains spaces in the name, the&nbsp;jinja&nbsp;expressions become invalid due to the spaces, or may get interpreted as a&nbsp;jinja&nbsp;expression that differs from the user’s intent.
To work with this behavior in a&nbsp;jinja&nbsp;expression, we suggest you follow these guidelines:
Properties of objects in&nbsp;jinja&nbsp;can be accessed either with the formats of&nbsp;{{a.my_field}}&nbsp;or through&nbsp;{{a['my_field']}}, which supports spaces in the property name.
Well, Mike, THX anyway!------------------------------Laszlo M------------------------------

Forum Discussion

Correct format for Address in Pipelines, if field name has a space

Example - workaround for address fields with spaces