How do I split the name field into first and last

Lee created the topic: How do I split the name field into first and last

If I enter a text field on the form and select "name" as the type two fields are populated on the form. First and Last.

However, when placed in the database it appears they are concatenated into a single field called name. At least they are exported into a CSV file as a single field. This is the point I really them split. Displaying on the submission list is not a big deal.

Is there a way to split the name into two fields without a lot of extra work populating multiple regular text fields. Even if it must done at export time that would be OK.

Thanks for your assistance.

Lee

#86553

Please Log in or Create an account to join the conversation.


Agapi G. replied the topic: How do I split the name field into first and last

Hello Lee!

Thank you for posting your inquiry!

Unfortunately the values of Name field are being kept as a single value on MySQL database, and they cannot be split. However, you can try adding two Simple Text fields, one for First, and second for Last names.

Hope this is a suitable solution for you. Let me know in case you have questions.
Thanks! Have a nice start of the week!


Kind regards,
Agapi G.
Web-Dorado team
#86585

Please Log in or Create an account to join the conversation.


Lee replied the topic: How do I split the name field into first and last

Not exactly what I was hoping for but it will work.

Thanks.

Lee

#86617

Please Log in or Create an account to join the conversation.


Agapi G. replied the topic: How do I split the name field into first and last

Hello Lee!

It's wonderful to know that this solution works for you. Please don't hesitate to let our team know in case you will need further assistance.
We will be happy to help!

Thanks! Have a wonderful day!


Kind regards,
Agapi G.
Web-Dorado team
#86641

Please Log in or Create an account to join the conversation.


Lee replied the topic: How do I split the name field into first and last

I have replace the name field with the two text fields as you suggested and it will work OK. Ideally though, I desire to place these two fields on the form side by side instead of one below the other.

I'm guessing I can't see the forest for the trees, but, is this possible?

Thanks

Lee

#86657

Please Log in or Create an account to join the conversation.


Agapi G. replied the topic: How do I split the name field into first and last

Hi Lee!

Could you please try dragging the last name field next to first name? You can modify Field size and Field label size afterwards to make the field combination smaller.

Give this a try and let me know if this works for you.
Thanks! Have a good day!


Kind regards,
Agapi G.
Web-Dorado team
#86671

Please Log in or Create an account to join the conversation.


Lee replied the topic: How do I split the name field into first and last

Drag/Drop was the first thing I tried. The field I attempt to move will move up or down but has no interest in being placed beside a field.

Sorry.

Lee

#86689

Please Log in or Create an account to join the conversation.


Agapi G. replied the topic: How do I split the name field into first and last

Hey Lee!

In that case please try adding a Section Break field before these two fields. You will notice that the section break is not movable, so please drag the fields below it instead. It should let you place this pair next to each other.

Let me know how it goes.
Thanks! Have a great day!


Kind regards,
Agapi G.
Web-Dorado team
#86717

Please Log in or Create an account to join the conversation.


Time to create page: 0.206 seconds
Powered by Kunena Forum

WORLD-CLASS SUPPORT

We are here for you every step of the way. Turn to our support with any questions you might have about our products and services. Our experienced customer care team is available to help you as fast as we possibly can.

Contact us