When the user leaves an input blank I would like the value in the DB to not be changed.
I am using xano for my backend and when I hit the button to run the api post and the cell is blank it changes the value in the DB to the key value of the body parameter I initialized the call with. I have tried to check the box allow blank but I get an error.
The problem is that there’s a difference between null value and blank value. Bubble will let you set this field blank… but will replace the empty value by null. This should work if you remove " quotes around parameters.
Thank you it is working now. The sad thing is, I had already tried that, but my database was having a problem with another issue and I overlooked it.
I think I know what the difference is. full_name is a text value?? Do I need to do something different for text and bool values? Works fine for numbers
A boolean value normally doesn’t requiere doubles quotes. Same for number. But this depend on the API spécifications
Another question, I have a checkbox which is a Boolean value and I need to change it using an API call, but I can’t figure out a way to make a change in the database. I have tried checkbox is checked also trade check box isn’t checked, but when I run the workflow, it does not seem to change the database. I’m sure it’s something simple. Any ideas?
Can you share what you have set?
I fixed it sorry to bother you. I have something wrong in xano.
So I can change the value of the Boolean but I can’t figure out if the user leaves the field blank if I wasn’t using a checkbox then I get an error message. I tried changing the path and took out the quotes, but it doesn’t seem to work. I’ll try again tomorrow. Hopefully I can figure something out. Also, I have not tested leaving a text field blank yet, but I did get the number fields to work properly. Not sure if I need to change something on the xano end or in bubble
