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

[Vincent]

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

[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*

[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)

[Vincent]

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

have a nice day

[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

[Vincent]

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]

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

[Aleksandr Zuevich]

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]

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