Use an object reference in a formula

1

I’m trying to achieve this:

Calories = Sum([Sausage Pita].Calories)

Where [Sausage Pita] - the table being referenced - is filled by thisrow.Recipe, which is a plaintext column filled with an @ reference to the [Table] object.

E.g. thisrow.Recipe = @Sausage Pita

So if thisrow.Recipe were = @Macaroni Cheese

Calories would be = Sum([Macaroni cheese].Calories)

Editing to add link to the actual coda:

2

Is there a reason you’re using @ instead of having it be a Relation column?

3

HI John,

It is VERY much easier to help with questions if you share the document or an anonymized copy of it.

1 Like
4

Yeah I wonder if there’s a way of structuring this so that relation columns work.

The problem is that each recipe is its own table, and seems to need to be.

5

Hi John,

Here is an example (work in process) of a bunch of recipes in a single table:

image
image1688×839 102 KB

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.