Workflows - add formula to a NUM field possible?

Hey,

Is it possible to add a formula to a NUM field in a workflow like this? Im not getting it to work.

When User Creates new project they have specify Size in m2.

I want the Amount in the workflow to be a % of this Size: Size*0.2

And I also want the User to be able to edit this Amount once the project is created.

Hi @Landbronx you can’t use a formula like this but what you can do is create a formula field that will do the calculation (this will be read-only) but then you can use that in your workflow in place of where you’re doing your calculation.

This way you get an editable calculation of the initial value

Hi @darragh, thank you for the help! Im not really getting it to work though.

I created a formula that does this, but its in another collection / table so I dont think it works because of that (I have a lookup field for it in my Project table but there are many values so perhaps that doesnt work?)

So i created another workflow within the same collection and that works, however the first workflow does not trigger workflow 2 so im stuck.

Is there a smart way of solving this?

I did a quick recording showing what I mean here:

Hey @Landbronx - having reviewed your loom (thank you very much)

I think your formula needs to be on the Project table, because that is what you are using currently in the Klimatkalkyl table to calculate AmmountTemplate through lookups, but you’re right, each project is linked to multiple Klimatkalkyl so you can’t easily use the lookup going that way.

My proposal is to write your formula on the Project table and then when creating your linked Klimatkalkyl in your workflow, you can use that formula to set the new value

Ok I will try this, but not sure how to do use a formula this way since i need to have a lookup with multiple values from Klimatkalkyl in the same field.

Lets say that in Klimatkalkyl there is different BuildingElements
Innerwall {100 m2}
Floor {500 m2}
Roof {200 m2}

Where e.g. {100 m2} is calculated by {ProjectSize*BuildingElement}

Each line in klimatkalkyl needs to be able to have a specific Amount depending on material type.

I don’t understand why you’re creating a new Klimatkalk but saying you need to reference values in that table?

I think this is where I’m losing you.
And in that case, would a formula just be better, does it need to be editable?

1 Like