+4Hi,
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
Best answer by Kamille_Parks11
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
+25Ordrenummer 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
+17This 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.
+4Ordrenummer 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
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
