Include look up field in formula

[Clapp]

Hello,

Is there any way to compute over look up of look ups ? I mean use look up of look up values in formula in order to compute something ?

I alway have the error below:

I read that topics (Formulas problem), but don’t understant how it work.

I tried this formula in the root table but it doesn’t work :

tonumber(concat(field('my_look_up_field'),""))

Do you have any advice, or do you know when this will be solved (Lookup of Lookup fields appear as JSON and cannot be used in many functions (#1027) · Issues · Bram Wiepjes / baserow · GitLab) ?

[frederikdc]

Hello @Clapp,

I got a similar issue last week. The workaround that worked for me (might not be the “cleanest” solution) is adding an extra column.

The field temp_formula contains my lookup formula. The additional field Calories_ingredients uses the formula sum(field(‘temp_formula’)). I refer to that field in further calculations.

In the final result, I hide the column temp_formula from the user.

[Alex]

This is a known issue.

We are tracking it here on Gitlab: Lookup of Lookup fields appear as JSON and cannot be used in many functions (#1027) · Issues · Bram Wiepjes / baserow · GitLab

And here is a related post: How do I Sum If? - #19 by Alex

[Clapp]

Thank you for your replies,

I manage my case mixing “concat” function (to convert lookup to string) and “contains” (to evaluate what’s inside)