Question

Select a certain amount of character from a string in a field

Forms

Updated April 13, 2017

asked on April 13, 2017

Hello,

In my form i got 2 fields (a and b) and i am concatenating the strings from them and display it to a 3rd field (c).

For example :

If a = hello and b = world, then c = helloworld.

But i must display only the first 7 characters of field c.

The display must be c = hellowo.

How can i do this? Is it possible to do this through Insert Formula(fx) in the advanced tab?

1 0

Answer

SELECTED ANSWER

replied on April 13, 2017 • Show version history

Hi Guillaume,

I just tested this out in Forms and found a solution.

First, make sure you assign a variable name to your 'a' and 'b' fields (in my example below, the fields are named 'Field 1' and 'Field 2' and have variable names of 'f1' and 'f2', respectively).

Next, make sure you set a character limit of on your concatenation field (field 'c' in your post above, 'Field 3' in my example).

Then you'll want to setup a CONCAT formula using the variable names you assigned to your fields, like this:

Finally, you can preview your form to ensure that it's working:

I hope this solves your problem! Please let me know!

Thank you,

Rob

4 0

Replies

replied on April 13, 2017

Hello Rob, thank you for the fast answer. I tried it and it worked perfectly. Thank you.

0 0

replied on April 13, 2017

No problem! Would you mind liking my reply or marking it as an answer? Thanks!

0 0

replied on April 13, 2017

Done. Thanks again for your help

0 0

replied on April 13, 2017

Much obliged, any time!

0 0

You are not allowed to follow up in this post.

Question

Question

Select a certain amount of character from a string in a field

Answer

Replies

Sign in to reply to this post.