Skip to main content
Solved

Interface: Cannot use formula result in Number Element

  • August 18, 2022
  • 3 replies
  • 49 views

Forum|alt.badge.img+6

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:

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

Does anyone know what I’m doing wrong?

Best answer by Gavin_Andrews

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.

3 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • August 20, 2022

Welcome to the Airtable community!

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


Forum|alt.badge.img+6
  • Author
  • New Participant
  • Answer
  • August 22, 2022

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.


Forum|alt.badge.img
  • New Participant
  • December 3, 2022

Welcome to the Airtable community!

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


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