Jun 06, 2019 11:57 PM
Hi, i am asking for help because i do not know how to execute this action or even if i can create it.
I just want to copy one field to another with is a link field automatically. The thing is that i can copy the data and paste it ant it works… but i want to create something in which i do not need to care about all the times
Thanks for your time!
Jun 07, 2019 12:34 AM
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.
Jun 07, 2019 12:39 AM
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
Jun 07, 2019 12:50 AM
Example as below,
Jun 07, 2019 12:56 AM
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 :see_no_evil:
I expect your response, thanks for all @IT_BeeTee
Jun 07, 2019 01:06 AM
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.
Jun 07, 2019 01:26 AM
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 ^^
Jun 07, 2019 01:29 AM
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 :slightly_smiling_face:
Jun 07, 2019 01:30 AM
Okayyy!! Thanks :grinning_face_with_smiling_eyes: