I achieved this using textbox widget and asked user to enter and run dashboard, in python code validating and inserting data in databricks.

2nd method , created excel vba application, using odbc connection to insert delete and update data in delta tables.