Any method to concatenate fields

Comments

9 comments

  • Hi Tracy,

    There isn't, unfortunately. This is a great feature request though, so I'm going to move this post to that topic so that folks can upvote it (since we do get asked a lot!). 

    You can kind of fake it on the PDF and you can do on exported data coming through, for example, a Zapier integration to GoogleSheets, but this is another instance where those don't really (I think) satisfy the need. 

    6
    Comment actions Permalink
  • Avatar
    Nathan H

    Being able to cat fields together would be very nice.

    3
    Comment actions Permalink
  • Avatar
    Corinn James

    Being able to concatenate fields is a must.  You don't typically write letters and other formal documents with the City, State, and Zip Code all on different lines. Also first and last names typically go together on a formal document.  Very disappointed this isn't already a feature.  Making our PDF look the way we want is seemingly out of the question now.

    4
    Comment actions Permalink
  • Avatar
    Julie Gowen

    Concatenation has become a real need for me. For instance I have a crew that needs to measure in feet and inches over and over. It is items that are on a loop screen. I would like for them to not have to enter the foot or inch marks (' and ") but just the numbers. They do not work in decimal feet which is a few examples I have seen in some apps. Also, these amounts are not summed just recorded. I would love to have two fields: feet and inch where in my pdf grid it shows up in a concatenated field like" 1' - 8" where they only had to enter 1 and 8.  

    Any suggestions on how to do this with the current version of gocanvas?

    Thank you!

     

     

    3
    Comment actions Permalink
  • Avatar
    Sara Kaplow, Community Manager

    Hi Julie,

    This is an interesting situation because they're in a Loop. Outside of a Loop, this would be pretty easy to solve using static field and getting rid of some borders. Inside a Loop, I think to get to the ideal situation, you'd need to have a custom PDF built (but that's exactly how I'd do it - two separate fields in one cell). 

    Maybe someone else has solved for this though. Anyone make this work? 

    0
    Comment actions Permalink
  • Avatar
    Nathan H

    Sure would be nice to be able to concatenate fields together... Maybe the code for the mirror field and / or the mirror backdoor could be re-used for this on some level...

    2
    Comment actions Permalink
  • Avatar
    IT Support

    Is there any progress on this request (or this one https://help.gocanvas.com/hc/en-us/community/posts/360027667933-Combine-Fields-Create-the-ability-to-combine-2-or-more-fields-like-First-Name-and-Last-Name) in the last 2 years?

    Or the ability to have multiple lookups on reference data?
    Which is what this feature request seems to be trying to achieve.

    For example:

    List A = List of Suppliers
    List B = List of Projects
    List C = List of Purchase Orders Raised (includes Supplier and Project info)

    Depending on someones selections against drop-downs referencing List A & List B, a 3rd drop-down would display a list of Purchase Orders raised against the selected Supplier and Project.

    Imagine trying to build an app where someone is requesting a variation to a Purchase Order where you want to find the PO based on the Supplier and Project.

    1
    Comment actions Permalink
  • Howdy,

    Thank you for checking in on this Feature Request! We do not have an estimated timeline for the ability to concatenate fields. However, our Product team is in the planning stages for updates to the App Builder and this functionality is being discussed. I have shared your feedback, along with the existing comments and upvotes, directly with our Product managers for their consideration.

    For your question about multiple lookups on reference data, I have reached out to some of my colleagues for their input on any workarounds for this particular use case. I'll post any potential solutions here, and would be interested if other users have found ways to achieve something like this example.

    1
    Comment actions Permalink
  • Avatar
    Alan Hurwitz

    Hi

    Has any progress been made regarding this?

    I'm evolving app for a client & the need for this has arisen, which could be a deal breaker!!! 

    Is there any way maybe to "hard code" some concatenation?

     

    1
    Comment actions Permalink

Please sign in to leave a comment.