I know about a!writetodatastore smart service function, is it possible that without navigating away from interface we are able to save the data in database using that function or is there some other way around.
Discussion posts and replies are publicly visible
Yes. You can trigger the a!writetodatastore() within an saveInto on a user interface input component. The associated documentation for this function is pretty clear.
Thanks Stewart Burchell that's working good.