Hi, miri 

Sorry for the delay

-

We are not sure we fully understood your question.

If you meant, is it possible to open a formula editor, in a Formula based column,

and to use values from a column from another table, and place it as part of the calculation,

in that case it is not possible.

-

But, if you have multiple tables in your database,  and you wish to create  a relation between tables,

to pull a column from another table  into the current table,

then you could use this column's values as part of a formula/calculation.

-

Please check out more on how you can make foreign key relations with our plugin here;

here you can see more about how our Formula based columns work.

-

And we will point out important limitations for Formula columns :

1. One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
2. In tables with server-side processing formula, columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.
3. Adding a sum in the sum row for formula columns is not yet supported.
4. Using calculation functions in formula columns is not possible

-

Let us know if you have further questions. Thanks