Is it possible to set function argument with variable ?

laurent_g9ifka

I need two fields. One formula field to calculate a value and second field (rule or IFTTT) to run a function with the calculate value.

For example formula field result give me a number and I want use this number as argument in function trunk(var) or trim(var) or other function with argument. 

Katerina Kovriga {Stiltsoft}

Hi @laurent ,

I guess you use ConfiForms tables and want to perform calculations in such tables.

Maybe our app will come in handy for your case - Table Filter and Charts for Confluence. The app works with the TableView macro perfectly well: you just wrap your TableView macro in our macros and perform various calculations, filter data, create pivots and charts.

To calculate some values using custom formulas, you may try the Table Transformer macro. It has two default presets (to merge and lookup tables) and a custom preset where you can paste your own SQL query to perform calculations. 

Here are the most common uses cases from our customers (using math formulas, comparing dates, calculating work periods, conditional formatting, etc.). Hope you'll find something that will help your case.