Formulas: take value from other table

  • Resolved Anonymous User 11529997

    (@anonymized-11529997)


    4 years, 2 months ago

    Hello Tobias,

    I would like to use a simple formula x * 3 in +300 tables.

    The x value however changes every year, so I would like to take the x value from another table. That way I can change x in that table every year, and it will adjust all the other 300 table values.

    I read this article: https://tablepress.org/tablepress-features-formulas/
    But I don’t find which formula to use: can I do something like in excel?

    =table_id_10 * 3

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, this is possible. First, you will need to use the TablePress Extension from https://tablepress.org/extensions/table-cell-shortcode/ which allows you to retrieve values from a table cell for use in another table.

    Then, you will need the TablePress Shortcodes before Formulas Extension, from https://tablepress.org/extensions/shortcodes-before-formulas/
    After installing and activating it, modify the Shortcode that you use with an extra parameter:

    [table id=1 shortcodes_before_formulas=true /]

    Inside table 1, you can then use a Shortcode like

    [table-cell id=4 cell=A1 /]

    inside a formula, to load the value of cell A1 of table 4.

    Regards,
    Tobias

    Hello Tobias,

    That worked like a charm. Thank you.

    Is there any chance these 2 plugins will be incorporated into the main tablepress plugin?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no, these will remain Extensions, simply because they provide extra functionality and can be maintained more easily this way.
    There’s simply no need to incomporate them into TablePress directly. Having them as separate plugins does not do any harm.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Formulas: take value from other table’ is closed to new replies.