This suggestion is simple, in addition to the “Keep Value if Blank” in the Update Row block, please add a checkbox or something under the column or in a select box next to Keep Value if Blank to clear value if blank and allow for keeping all blank data other than the selected columns
Doing something like this will allow to keep the value of the non-checked fields while clearing the value of the checked ones even though the block is showing to keep all fields if blank
PS: I didn’t have the font Inventor uses nor do I know how to add elements to the page so I had to improvise using photoshop and try to get a font that looks passable
1 Like
I thought of a better idea for this. Instead of having a separate checkbox just add a thing like @now in time blocks. @current, for example. It could just replace @current with the current value. This would also be useful for stuff like adding to a comma separated list or something.
@current could also possibly be used but what about adding that value to the db as regular text if you wanted to use that in say a message command flow where @current gets the current user. Having a checkbox is nice because it doesn’t matter how many columns you create or delete, you will always have that 1 column get cleared without having to go into every single update row block that is attached to that db and update it
