Hi there,
I am trying to update the last column of table 1 from table 2. I could easily copy the table directly but page A must not show the document attachment as it's confidential. We can provide a link of page B on selective basis when they request access. So the documents are only available to view in Page B. Page A will only show the link to page B instead of the document attachment and the rest of the table details.
However, I need the dates of the Expiry column from page B extracted into the Expiry column in Table 1 which is in a different page. Is it possible to do so?
Table 1 (Page A)
| Name | Type | Document link | Issue | Expiry |
|---|
| N1 | pdf | **restricted page link** | | |
| N2 | xlsx | **restricted page link** | | |
| N3 | html | **restricted page link** | | |
Table 2 (Page B- child page of page A)
| Name | Type | Document attachment | Issue | Expiry |
|---|
| N1 | pdf | abc.pdf | | |
| N2 | xlsx | def.pdf | | |
| N3 | html | ghi.pdf | | |