Re: Field "Contract Balance" cannot accept the provided value: Could not parse number

451 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi Folks,

I’m having a problem with an automation that I built. Initially it worked but now it doesn’t. Essentially what I’m trying to do is this:

  1. the trigger is a new record creation in 'Table C"
  2. Then we work to update a field in “Table B” using the linked id of a lookup field from 'Table C". Then in the field area I simply try to create a simple subtraction formula: Current balance - amount

But I keep getting this error! (screenshot attached) Any idea what could be happening?

Screen Shot 2021-03-03 at 2.10.41 PM

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

Ever figure this out? Not sure how operations work in this context