Formula field not available on adding new record

Help Center Get Answers
1

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

2

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
+919855089359

3

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

4

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

2 Likes