You are viewing limited content. For full access, please sign in.

Question

Question

Feature Request: Concatenate Returned Database Values

Forms Ideas
Updated August 6, 2015
asked on December 9, 2014

I would like the ability to concatenate values that are returned from a database lookup in one field. Example: In my database it has fields for last name and first name. On my Form I want to display them as one field so I would just have a name field and be able to put both the last name and first name values into one field.

0 0

Answer

SELECTED ANSWER
replied on December 10, 2014

Hi there,

Thanks for your user story. We'll take "customize sql query" request into consideration for future Forms.

0 0
replied on February 20, 2015

This request doesn't necessarily need a user to be able to customize a SQL query, but be able to take two token values returned from a database lookup and put them side by side in the Forms interface.

0 0
replied on August 6, 2015 • Show version history

to concatenate, what is the preferred seperator: use ; or , or space

0 0
replied on August 6, 2015 • Show version history

I think they should be able to insert what they want. It should work the same way it does in Workflow with tokens. You can take any two tokens in the token editor and put them side by side and add any character or space between them if so desired. Example below:

replied on August 6, 2015 • Show version history

I think the user should be able to choose what the separator is. So when Forms detects that more than one database value has been selected to fill a field, show another drop-down field with the most common values: ',' or ';' or ' ' or '-' or '.' or '/', etc. as a separator.

0 0

Replies

replied on December 9, 2014

Blake,

I agree it would make this type of thing take one less step however, this could be easily done with a SQL view. Something like below would work perfectly for this. Once you make a view it will show up as if it was another table when you select which table to query. Obviously you would want to customize it to your needs.

select first_name + ' ' + last_name as first_last, first_name, last_name, employeeid  from Users

 

0 0
replied on December 9, 2014 • Show version history

John, thank you for the information. I was just thinking that from an end users perspective that doesn't know SQL, it would be nice if they could just do it through the Forms interface much the same way you can do it in Workflow.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...