Any method to concatenate fields

Comments

6 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. 

    4
    Comment actions Permalink
  • Avatar
    Nathan H

    Being able to cat fields together would be very nice.

    2
    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.

    2
    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!

     

     

    2
    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...

    1
    Comment actions Permalink

Please sign in to leave a comment.