Address field with Pipelines QB channel?
Hello... I am trying to enter Street 1, Street 2, City, State, Zip from one app's address field to another app's address field and get the error below. The pipeline is set up correctly and runs fine w...
Forum Discussion
This is not mentioned in Pipelines docs, but you'd want to use bracket notation with fields that have a space in them, particularly, an address field. For example:
If you're using a dot (.) to reference a field value in an expression like
{{a.Patient Address_city}}You should update that by removing the dot and referencing the field in brackets and single quotes, like so:
{{a['Patient Address_city']}}------------------------------
AR
------------------------------
See also this related discussion.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Ah, did not see that. Thank you!
------------------------------
AR
------------------------------
How do we copy an address field like "Project Address" from a table in one app to another table in another app through pipelines? I've been trying all methods but it still isn't working. Need urgent help with this.
I've even tried the using [] brackets as well
{{a['Project Address_project address_project address_project address_street_1']}}
------------------------------
Rahul Mathew
------------------------------It might be better to start a new thread with your question. And when you do, if you can post the section of your pipeline where you copy the addess over. From above, it looks like the formula is repeating, as that indicates your field name is: [Project Address Project Address Project Address]
Without seeing the rest of your pipeline, it could just need to be: {{a['Project Address_street_1']}}
------------------------------
Mike Tamoush
------------------------------Also, you may want to take a look at Quickbase's Jinja docs on proper syntax. It's helpful for this exact thing you're facing. Using Jinja in Quickbase Pipelines
------------------------------
AR
------------------------------
Thank you Mike. I have added a new post: https://community.quickbase.com/discussion/address-field-from-one-table-to-another-table-in-a-new-app-using-pipelines?ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dd860b0f8-6a48-487b-b346-44c47a19a804
------------------------------
Rahul Mathew
------------------------------
