Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Extract only one column from another table

NM March 7, 2024

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)

NameType Document linkIssueExpiry
N1pdf**restricted page link**

07 Mar 2024 

 
N2xlsx**restricted page link**

08 Mar 2024 

 
N3html**restricted page link**

09 Mar 2024 

 

 

Table 2 (Page B- child page of page A)

NameType Document attachmentIssueExpiry
N1pdfabc.pdf

07 Mar 2024 

31 Mar 2024 

N2xlsxdef.pdf

08 Mar 2024 

30 Mar 2024 

N3htmlghi.pdf

09 Mar 2024 

29 Mar 2024 

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi @NM ,

Please take a look at this case that was implemented with the help of our app - Table, Filter, Charts & Spreadsheets for Confluence.

Seems that it is smth similar to what you need.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events