is there a way to set the value of a number field with a formula or a button?
P

I have a field filled by the user with the amount given by a client with a method selection (cash, credit...). But It could be possible for a client to give some cash and pay the rest with a credit card...so if my first amount is less then the total, my second field will be shown and then I can enter a new amount with new method...

But if I still have an amount entered in the second field and I change the first field to the full amount, my second field will be hidden but will keep it s number...and I use this field to calculate other field...

I would like to be able to say '' if field #1 = total then field #2 = 0'' to reset the field if needed...

I have tryed to make a formula field = to field #2 or 0 but it makes my table to lag and bug... and we cannot enter any formula in number field...

any ideas? Thanks!

Ninox Profile

Use an After Update trigger on field 1.  Something like.. 

if 'Field 1' = total then 'Field 2' := 0 end

Reply