I have a value that is not being written to the database correctly. It appears that this value is being added with another value and being written to the database.
I have a value in an input of 310 as shown in the input below:
I checked the workflow and the input is correct.
However in the database it’s being written as 324:
This extra 14 minutes is some how added to the original value of 310. This 14 minute value is in another input on the page, but I have not summed these inputs on the workflow.
Any idea why it’s summing these 2 values when I have not specified it to do so?
Do more tests with other values…test 3 values for main input while keeping other at 14 and see if all get added 14…then test and change 14 to 15 and test 3 values in main input again to see if all 3 tests add 15. If yes, @Jici is probably correct you have a hidden or forgotten 3rd input you’ve selected as value to save which sums the 2 visible inputs, or you have some condition on main input that changes value to be summed, but most likely is nothing wrong with bubble
No I don’t however the I did have the wrong input writing to the DB in the workflow initially but I changed it’s label and re did the work flow to write from the correct input, and still had the error.
It’s almost like Bubble still writes the data to the DB from the previously labelled input and does not recognize the change…
If testing properly and checking thoroughly as suggested, and nothing seems off, but issue still persists and is consistent at adding 14 to whatever value is entered into input, check if there is a database trigger change event in backend workflow that adds 14 to the value.
But, also share screen shots of what you have already setup. In my personal experience it is most often another set of eyes that helps spot my mistakes.
If I’m unsure if an input is the correct one being referenced in a workflow I would add something like a star * in the input name. Then check if the workflow updated with that *. Then I know it is referring the correct input. Does that make sense?
Absolutely! When I first discovered the problem I had the wrong input entered as it had a very similar label. So i changed it, but for some reason it’s like Bubble did not recognize the change..