how to merge 2 fields

[DRAhmed]

how to merge 2 fields in a table

[CoopperBackpack]

Hello @DRAhmed,

I am not sure that I got the question. I will describe a solution for the request as I understand it. If this is not the case, please provide an example of what you need to achieve.

 

1) For example, I have a table with 2 fields: City and Address

And the goal is to store both these values in the Address field. For example: Philadelphia , 3006 Medical Center Drive

2) The Task can update the field using some logic. In my case, it is like this: 

The Task concatenates the City and the Address in each record.

3) After the Task run I have the following result:

So I can delete the 'City' field now.

Hope this helps.  

[kpcollier]

Could also download the data into something like Excel, merge them yourself, and then upload the updated values into the table.

[cheonsa]

7 hours ago, DRAhmed said:

how to merge 2 fields in a table

Hi @DRAhmed, what do you mean by merging 2 fields in a Table? If you are referring to combining values from two fields, you can use a Formula Field to concatenate the fields.

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

[DRAhmed]

19 hours ago, cheonsa said:

Hi @DRAhmed, what do you mean by merging 2 fields in a Table? If you are referring to combining values from two fields, you can use a Formula Field to concatenate the fields.

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

not in this way 

i have to field in a table where the fields contain data 

i want to merge data from both of the fields in one of those fields and delete the other

[DRAhmed]

2 hours ago, CoopperBackpack said:

Hello @DRAhmed,

I am not sure that I got the question. I will describe a solution for the request as I understand it. If this is not the case, please provide an example of what you need to achieve.

 

1) For example, I have a table with 2 fields: City and Address

And the goal is to store both these values in the Address field. For example: Philadelphia , 3006 Medical Center Drive

2) The Task can update the field using some logic. In my case, it is like this: 

The Task concatenates the City and the Address in each record.

3) After the Task run I have the following result:

So I can delete the 'City' field now.

Hope this helps.  

if i dont have access to triggered actions , how to do it 

[cheonsa]

5 hours ago, DRAhmed said:

if i dont have access to triggered actions , how to do it 

Hi @DRAhmed, if you have no access to Triggered Actions, you can use the Formula Field instead. However, the value in both fields should be retained. 

[Queso]

Hi @DRAhmed,

For more details on concatenating two fields with a Formula Field, see this other Forum Post: