How to copy data from one record to another in same table

[Michael_bn]

Hi,

I am trying to figure out a way to copy data from one record to another in the same table. In the example Ordrenummer primær should be the key and I want Navn and Mail from the record with values to be copied to other records with the same value in Ordrenummer primær.

Thanks for your help.

/Michael

[Kamille_Parks]

Ordrenummer primær should be its own table, with one record that has a key of 643211 and two fields for Name and Mail.

The field Ordrenummer primær in your existing table, Ordreliste restorde, shouldn't be a text field, it should be a "Link to another record" field pointed at your new table. Then you could bring Name and Mail over as loopkups.

That way you only have to define the name/mail for 643211 and it will automatically show up everytime 643211 is linked.

Lookup Field basics video: https://www.youtube.com/watch?v=chLX3zc6fCU 

Linked Record Field documentation: https://support.airtable.com/docs/linking-records-in-airtable 

Lookup Field documentation: https://support.airtable.com/docs/lookup-field-overview 

[DisraeliGears01]

This is a classic instance of you need another table. Presumably the Navn and Mail fields are contact information, while the Ordrenummer primær field is a constituent id (which Airtable doesn't really need, but you can use if it integrates with other systems). Just make a 3rd table called Customers (or what have you) with those three fields, and then add a linked record field to your original table with lookups for Navn and Mail. 

[Michael_bn]

Hi Kamille,

Thanks a lot. I did as you suggested and it is working 😀

I have an issue though. When I use the Ordrenummer primær which is the key, make.com does not see the order number but instead in this example Ordrenummer recqQkcb9OCrSLdht

make.com is linked to Ordrenummer primær and the result should be Ordrenummer 643394

Do you have any idea why it acts like this when it is a linked field?