Hi, my client is using the following way of calculating the fee for an Inspection (see image). However, he still wants to be able to change that price if he wants so an App Formula doesnโt seem to work. The field is currently set to โPriceโ. Initial Formulas donโt work either since the value is based on two other fields (Billing rate and Loan type). Is there a workaround to this?
Solved! Go to Solution.
Add two more columns.
IF( ISBLANK( [manual override] ) , โฆcalculationโฆ , [manual overrride] )
Add two more columns.
IF( ISBLANK( [manual override] ) , โฆcalculationโฆ , [manual overrride] )
I was trying to avoid this but i guess there isnโt a way around it. Thanks for the help
Huh? So?
I tested it by selecting a Bank & a Loan type both when editing an entry and when creating a new one but no calculation result. It was 0$ every time.
Thatโs unexpected.
Is there something wrong with Appsheet currently? Iโm experiencing all kinds of weird stuff.
Yes. It is majorly tweaking out.
Please report these two bugs to support@appsheet.com.
As long as the user hasnโt modified the value, the value should be recomputed automatically until the new row is first saved. After the new row is first saved, the Initial value expression is not applied upon subsequent row edits unless Reset on edit? is used.
@Marc_Dillonโs suggestion is a good one in your situation, it sounds like.
Will do, thank you for the help. Iโll report them to support!
I imagine it has to do with entering in manual input to the field w/ initial value first, thus overriding the expression, then deleting the manual input, but of course now the expression has been overridden and wonโt calculate even if you enter info into the other fields. Can be mostly fixed with some setting Reset On Edit, but Iโve always found it to be an easier setup AND more robust solution to just add the extra columns as I described above.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |