Creating Name Field From First And Last Name

[jnordstrand]

Can someone help me to create a "Name" field by combining First Name and Last Name Automatically?

[MayMusic]

When you add the data to the table through a submission page you can use this script to combine first and lastname: http://forums.caspio.com/index.php/topic/3200-js-concatenatecombine-two-fields-into-one-field/

[jnordstrand]

It is not working for me.  Is a Capture Web Form and Submission Form?

[MayMusic]

Capture web form can be an update page or submission page which one you have? Can you give me the link to the page to take a look at the code?

[cheonsa]

Hi @jnordstrand,

 

You can also concatenate or combine two fields into one field using a formula field. In your table set your "Name" field as Formula and perform the calculation.

Look at this screenshot:

 

Another thing, calculations in submission form is now available in the current platform. It does not require custom coding anymore.

Please refer to this link: https://howto.caspio.com/datapages/datapage-components/calculated-values/

 

Regards,

kristina

[RuisiHansamu]

Hi there, for those you would like to separate the full name into first and last name, you may want to check this forum post. This is accurate and helped me a lot. 

then for your function reference. use this: https://howto.caspio.com/function-reference/ 

Lastly, for you to add a formula field in a Table and concatenate values into one field, try this: https://howto.caspio.com/tables-and-views/data-types/formula-fields/

 

[Queso]

Hi,

You can concatenate or concatenate your field for First Name and Last Name using the following formula:

[@field:First_Name] + ' ' + [@field:Last_Name] 

You can modify the character between these two fields by replacing the space character between the single quotes with your desired character.