# Formula field not available on adding new record

**URL:** <https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660>\
**Category:** Get Answers\
**Created:** [August 5, 2024, 12:59pm UTC](https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660 "2024-08-05T12:59:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaulR](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/paulr/32/4200_2.png) [@PaulR](https://forums.knack.com/u/PaulR)\
**Post date:** [August 5, 2024, 12:59pm UTC](https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660/1 "2024-08-05T12:59:32Z")

</div>

Afternoon everyone.

I have a table with these fields:

**Total Miles (number field)**  
**Pence per Mile (number field)**  
_Calculated Mileage Payment (calculated field/formula)_  
Amount Owed (number field)

When I am in a view that adds the record to the table I would like to have the user enter the first 2 fields (in bold), the system to calculate the payment and then insert the calculated payment into the Amount field.

In the record rules when I select to set the amount field I am unable to see the Calculated Mileage Payment field in the list.

I can do this on the EDIT view with no problems.

Is this something that is not possible in Knack?

Thanks

Paul

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [August 5, 2024, 3:11pm UTC](https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660/2 "2024-08-05T15:11:19Z")

</div>

Hello Paul,

We have to calculate and show value using javascript. It’s an old issue in knack. In the create record field this will mostly show the value as 0, Also I think in edit form it will not update when we change value.

Regards,  
Sunny Singla  
[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)  
+919855089359

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [August 6, 2024, 5:24am UTC](https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660/3 "2024-08-06T05:24:29Z")

</div>

This is because the value is not calculated until you have submitted the record. Once submitted the value will be written to the table.

---

<div class="post-metadata">

**Author:** ![PaulR](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/paulr/32/4200_2.png) [@PaulR](https://forums.knack.com/u/PaulR)\
**Post date:** [August 6, 2024, 12:25pm UTC](https://forums.knack.com/t/formula-field-not-available-on-adding-new-record/17660/4 "2024-08-06T12:25:14Z")

</div>

Thanks chaps… I will get creative with some Javascript then!