Help

Interface: Cannot use formula result in Number Element

Topic Labels: Interface Designer
Solved
Jump to Solution
2223 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Gavin_Andrews
4 - Data Explorer
4 - Data Explorer

I am using a formula to subtract one weight (ungraded weight) from another (graded weight). The formula in the dashboard is working fine to make Unaccounted Weight:
image

However, I cannot choose Unaccounted Weight in Interface Designer. I want it to appear just as a number element.

image

Does anyone know what I’m doing wrong?

1 Solution

Accepted Solutions

It is in the same table. It only shows fields that are linked records. No idea why.

However, I was able to make it work by using field elements.

image

See Solution in Thread

3 Replies 3

Welcome to the Airtable community!

It looks like your number element is connected to “Grading Lots”. Is your {Unaccounted Weight} in a different table?

It is in the same table. It only shows fields that are linked records. No idea why.

However, I was able to make it work by using field elements.

image

Have a good time, my beautiful friend. With you is Abu Wadih from Syria. Can we be friends?

IMG_20210606_001922_672.jpg