Hi there,

If the source and the destination fields are one the same table, you can just set up the destination field to be of type Formula and input the name of the source field to copy data over.

Regards,

Alex

Hi, Can you give/expose me an example, I do not really know how to create that kind of function

Thank you so much for the post

Example as below,

Regards,

Alex

Okay, As I see this is in the case the link field is in the same table but if the link i want is in other table, can I use a formula too?

I mean imagine i wanna copy apple(which is a record in column1 in Table 1) to the link field (column 2 in table 1) but this is a link to table 2

I think I expose quite bad

I expect your response, thanks for all @IT_BeeTee

Yes you can,

Firstly you need to create a Link in Table 2 which you have already did.

Then, you create another field with type Lookup in Table 2 and point it to Source field in Table 1.

I have tried your solution but i realised that I need to continue copying the data to the first link set to make the lookup work

Again, thanks cause you are showing me a lot ^^

Hi,

There is no other way to get data from another table without the link. I do agree with you it seems to be more or less the same as copying data manually but if you need more data from another table, it will save you a lot of time

Regards,

Alex

Okayyy!! Thanks :grinning_face_with_smiling_eyes: