Hi Folks, After I didn't find answer I take the opportunity to post here^^ I would like to know if it's possible to declare a variable and use it in a confluence table. example: * on column 1 there is a value (this is the desired variable value) * on column 2 (same line as column 1) I call this variable so if I change the value in column 1 , it change on calumn 2 if there an embedded feature or maybe a thrid party soft you know that can do that? thx a lot in advance

Hi Vincent, You can resolve your task with the help of the Table Transformer macro (one of the Table Filter and Charts app). The macro allows performing calculations with the help of SQL queries. Look at the example: * The source table wrapped in the Table Transformer macro: * The Table Transformer macro browser: * The resulting table: * The query: SELECT *, "https://stiltsoft.com/" + 'Category' AS 'URL' FROM T*

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to declare and use a variable in a table in confluence?

Vincent_kvrezm

Hi Folks,

After I didn't find answer I take the opportunity to post here^^

I would like to know if it's possible to declare a variable and use it in a confluence table.

example:

on column 1 there is a value (this is the desired variable value)
on column 2 (same line as column 1) I call this variable

so if I change the value in column 1 , it change on calumn 2

if there an embedded feature or maybe a thrid party soft you know that can do that?

thx a lot in advance

Accepted answers

All comments

Aleksandr Zuevich_6f4k0z

Hi Vincent,

Do you mean to repeat the content of the cell inside other cell? If so you can use combination of standard Excerpt and Excerpt Include Confluence macros.

Vincent_kvrezm

Hi Aleksandr, yes this is quite what I try to achive, more exactly, my goal would be to do something like:

column1, line 1 : JKR54HJ (it's a serial)

column2, line 1: http://mywebsite/check_warranty/JKR54HJ

(and if I change the serial in c1, the url change also in c2)

Can I use the native macro for that?

Thx a lot in adance

Vincent_kvrezm

Hi Aleksandr, the thing is that in the same page, I will have multiple Excerpt, I didn't find a way to use multiple Excerpt in the same page, because when I call the include Excerpt macro, it asks for the page of the Excerpt to include (but how can I tell him to use a specify Excerpt when there is plenty?)

thanks a lot in advance

Aleksandr Zuevich_6f4k0z

Hi Vincent,

Unfortunately I don't know how to achieve this using standard Confluence functionality. But I'd recommend this plugin: https://marketplace.atlassian.com/apps/169/multiexcerpt

Alex Medved _ConfiForms_

Have look at the app we offer, ConfiTemplates

And this quick tutorial in particular - https://wiki.vertuna.com/display/ST/Using+Confluence+page+properties+with+Smart+Templates

You can define variables as page properties and you can use them inside the templates, template contents can be loaded from other pages if necessary, just like multi-excerpts

Natalie Paramonova _Stiltsoft_

Hi Vincent,

You can resolve your task with the help of the Table Transformer macro (one of the Table Filter and Charts app).

The macro allows performing calculations with the help of SQL queries. Look at the example:

The source table wrapped in the Table Transformer macro:

The Table Transformer macro browser:

The resulting table:

The query:

SELECT *,
"https://stiltsoft.com/" + 'Category' AS 'URL'
FROM T*

Vincent_kvrezm

Thx a lot folks! I will try that and let you know!

have a nice day

EPS Software Engineering AG

Hi Vicent,

Maybe our Easy Confluence Variables could be a solution for you. You can define a variable on space level and use it in pages with %variable. Of course a search for the value or the variable name works. You can find the Easy Confluence Variables on the Marketplace.

Regards,
Stephan (CEO of EPS Software Engineering, the vendor of the Easy Confluence Variables)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

table