O
O
Oleg2021-11-09 14:10:51
Google Apps Script
Oleg, 2021-11-09 14:10:51

How to transfer a value with a link to the site to another table?

Good afternoon.
I can't seem to find a suitable method in the google script documentation.
I have a table, in the cells of which links to different sites are attached to the text. I need a script to transfer these values ​​with links to another table.
I made a script to transfer data to another table, but it only transfers values ​​(and links are not transferred).
The most suitable method is copyTo, it transfers both values ​​and links, but it only works in one book, and I need to transfer it to another book.

Please tell me if there is a suitable method for transferring both text and links to another table.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-11-09
@Oleg_F

getRichTextValue() / setRichTextValue()

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question